Name:            Excel Study Guide 5-8

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?
  1