 |
|
|
| 1. |
The intersection of a row and a column is called a _______.
|
|
|
|
| 2. |
A predefined computational task, such as AVERAGE, is known as a(n) _______.
|
|
|
|
| 3. |
Which of the following is considered a constant?
|
|
|
|
| 4. |
The ____________ contains buttons corresponding to the most basic commands in Excel.
|
|
|
|
| 5. |
You have an open workbook named Budget. The command that will save that workbook with the name Revised Budget is:
|
|
|
|
| 6. |
The command used to create a new workbook is located on the __________ menu.
|
|
|
|
| 7. |
You want to delete column B from your worksheet. The command that accomplishes this is:
|
|
|
|
| 8. |
The command that gives you control over the printed worksheet is:
|
|
|
|
| 9. |
You have entered the name "Grauer" in cell B12. In cell B19, you type a G, and Excel fills in the letters "rauer". This feature is known as:
|
|
|
|
| 10. |
The command(s) needed to duplicate the contents of one cell range in another location is(are):
|
|
|
|
| 11. |
Cell D16 contains the function =AVERAGE(D1:D15). If you copy D16 over 2 columns, the contents of the destination cell will be:
|
|
|
|
| 12. |
A cell reference that does not adjust when it is copied is referred to as a(n):
|
|
|
|
| 13. |
Cell J5 is formatted as percentage with one decimal place and displays 47.8%. The value of that cell (in decimal format) is:
|
|
|
|
| 14. |
By default, text entries are:
|
|
|
|
| 15. |
The tab in the Format Cells dialog that allows you to choose a different color in which to shade a cell is:
|
|
|
|
| 16. |
An Excel worksheet consists of one or more workbooks.
|
|
|
|
| 17. |
A formula is a cell entry whose value will not change.
|
|
|
|
| 18. |
You can define the margins on a printed worksheet with the Page Setup command.
|
|
|
|
| 19. |
An absolute reference is one that is adjusted when a cell containing that reference is copied.
|
|
|
|
| 20. |
In a copy operation, the cell you are copying from is called the source range.
|
|
|
|
| 21. |
Identify the type of cell reference.
Using the pulldown boxes, match each item on the left to the corresponding item at right.
|
0.1
|
|
|
A. B4
|
|
0.2
|
|
|
B. $B$4
|
|
0.3
|
|
|
C. B$4
|
|
|
|
|
| 22. |
Match the term with its best definition.
Using the pulldown boxes, match each item on the left to the corresponding item at right.
|
0.1
|
|
|
A. a computerized version on an accountant's ledger
|
|
0.2
|
|
|
B. contains one or more worksheets
|
|
0.3
|
|
|
C. an Excel spreadsheet
|
|
0.4
|
|
|
D. the intersection of a row and column
|
|
|
|
|
| 23. |
Match the type of cell entry with its characteristics
Using the pulldown boxes, match each item on the left to the corresponding item at right.
|
0.1
|
|
|
A. a predefined computational task
|
|
0.2
|
|
|
B. will not change
|
|
0.3
|
|
|
C. value changes as the values of the underlying cells change
|
|
|
|
|
|
Answer choices in this exercise are randomized and will appear in a different order each time the page is loaded.
|
| |
|
|