The Workshop is designed to help you anticipate possible questions, review what you've learned, and begin learning how to put your knowledge into practice.
Quiz
1:
How do you begin a formula in Calc?
2:
How do you format a range of numeric data cells as currency in Calc?
3:
How do you use a simple function such as sum() or average() within a formula in Calc?
Answers
A1:
Click the cell you want and then type the equal sign.
A2:
Select the range of cells with your pointing device and then click the currency format button in the Formatting bar.
A3:
Enter the name of the function by hand followed by the left parenthesis. Then select the range of cells to include in the function's calculation using your pointing device. Finally, close the function by entering a right parenthesis.
Activities
Try using Calc for a practical calculation of some sort, such as creating a budget or balancing a checkbook.
See what happens when negative numbers are entered into Calc cells.