1. | Tutorial 1Excel is an electronic version of a(n) |
A. |
B. |
C. |
D. |
2. | Tutorial 1Excel stores its documents as files called |
A. |
B. |
C. |
D. |
3. | Tutorial 1A(n) ____ is a group of cells. |
A. |
B. |
C. |
D. |
4. | Tutorial 1The characters +, -, *, and / are examples of |
A. |
B. |
C. |
D. |
5. | Tutorial 1The formula used to multiply cell A1 by cell C1 is ____. |
A. |
B. |
C. |
D. |
6. | Tutorial 2 TRUE/FALSE Formatting changes only the appearance of data - it does not affect the data itself. |
A. |
B. |
7. | Tutorial 2 TRUE/FALSE You can use a picture or image as the background for all the cells in a worksheet. |
A. |
B. |
8. | Tutorial 2 TRUE/FALSEBackground images do not print in Excel. |
A. |
B. |
9. | Tutorial 2 TRUE/FALSEWhen using a data bar, changing the value of one cell in the range will not affect the size of all the other cells’ data bars. |
A. |
B. |
10. | Tutorial 2 TRUE/FALSEIn Excel, if the built-in styles don’t meet your needs, you can modify an existing style or create a new one. |
A. |
B. |
11. | Tutorial 3The PMT function is a(n) ____ function. |
A. |
B. |
C. |
D. |
12. | Tutorial 3 The F FV function stands for ____. |
A. |
B. |
C. |
D. |
13. | Tutorial 3 Abs Abolute references are marked with a ____. |
A. |
B. |
C. |
D. |
14. | Tutorial 3 When you copy a formula that contains an absolute reference to a new location, the reference ____. |
A. |
B. |
C. |
D. |
15. | Tutorial 3Which function counts how many cells in a range contain numbers, where value1, value2, and so forth are text, numbers, or cell references? |
A. |
B. |
C. |
D. |
16. | Tutorial 4Every chart must have a data source. |
A. |
B. |
17. | Tutorial 4 For For which of the following reasons would you choose to use a chart or graph? |
A. |
B. |
C. |
D. |
18. | Tutorial 4To move or resize an embedded chart, ____. |
A. |
B. |
C. |
D. |
19. | Tutorial 4A(n) ____________________ is a visual representation of a set of data. |
A. |
B. |
20. | Tutorial 4Excel supports ____________________ built-in charts. |
A. |
B. |