CIT 130
Quiz 2
Name:
Quote of the day: “It's so much easier, to push instead of pull.” - Sammy Hagar
1. Give the formula needed to total all numbers (use a range).
Give the formula needed to get the average of these numbers.
2.
Give the formula needed to total these numbers (do not use a range).
3. What are some limitations of Excel? (provide at least 3)
4. How many cells are on a spreadsheet? Give the cell address of the last row and column.
5. What is the Excel file program name? What is the Excel file extension?
6.
What is the purpose of the black square circled? Explain.
7. How can you access another cell from another worksheet? Give an example.
8.
Give the payment formula given the following cell data:
A1 = $72,945
B1 = 12%
D1 = 60
9. What is the freeze pane? What is its purpose?
10. Define the three basic charts used in Excel and their definition.