1. What is a formula?
2. What character must precede a formula that you type into Excel?
3. What are the mathematical operators used
in a formula for:
Addition:
Subtraction:
Division:
Multiplication:
Exponents:
4. What is the order in which the computer
calculates mathematical operations?
First:
Second:
Third:
Fourth:
5. How do you format a column of numbers to be dollars and cents?
6. What is a range?
7. Formulas may be copies to another cell
(or range of cells) and even to another worksheet or workbook.
What is an easy way to copy
a formula across a row or down a column?
8. What are the top and bottom default margins in Excel? Top: Bottom:
9. What is an absolute reference?
10. How do you indicate an absolute reference
name for a cell?