1. | $A1 is an absolute reference to column A and a relative reference to row 1. As a mixed reference is copied from one cell to another, the absolute reference stays the same but the relative reference changes |
A. |
B. |
2. | A formula result is in cell C6. You wonder how you got the result. To see the formula, you: |
A. |
B. |
C. |
3. | Formula =C4*$D$9 - absolute cell reference is: |
A. |
B. |
C. |
D. |
4. | The ##### error value indicates |
A. |
B. |
C. |
D. |
5. | The two CDs purchased in February cost $12.99 and $16.99. The total of these two values is the CD expense for the month. You can add these values in Excel by typing a simple formula in a cell: |
A. |
B. |
C. |
D. |
6. | Excel will calculate date :1/20/1900 (month/day/year) as: |
A. |
B. |
C. |
D. |
7. | Relative references: |
A. |
B. |
C. |
D. |
8. | What would happen if you used a formula to do math with dates? |
A. |
B. |
C. |
D. |
9. | The MAX function finds the _______ |
A. |
B. |
C. |
D. |
10. | In the practice, you learned that if you misspell SUM in this formula =SUME(B4:B7), you'll get an error value of #NAME? To fix the formula, you must delete it and start over again. |
A. |
B. |
11. | In Excel if you write =TODAY() in the formula bar (Fx) |
A. |
B. |
C. |
D. |
12. | How would you print formulas? |
A. |
B. |
C. |
D. |
13. | A 'function' in Excel is : |
A. |
B. |
C. |
14. | If you copy the formula =C1*$D$9 from cell C1 to cell C2, what will the formula be in cell C5? |
A. |
B. |
C. |
D. |
15. | The button shown below is use for ________ in Excel |
A. |
B. |
C. |
D. |
16. | In Excel 2007 you can write simple formulas that cannot automatically update their results when values change |
A. |
B. |