PART A: On your own piece of paper, write the letter of
the correct answer for each question. Write True or False for questions #10-20.
1. The active cell can be identified in all of the following ways except _____.
a. the active cell reference displays in the Name box
b. a heavy border surrounds the cell
c. the column heading and row heading are highlighted
d. a block arrow displays in the center of the cell
2. The easiest way to select a cell (make it active) is to _____.
a. type the cell reference in the status bar
b. use the function keys located at the top of the typewriter keys on the keyboard
c. type the cell reference in the formula bar
d. use the mouse to move the block plus sign to the cell and then click
3. The _____ is the small black square located in the lower-right corner of the heavy border around the active cell.
a. sizing handle
b. fill handle
c. move handle
d. marquee
4. When one range is copied to another, Excel displays the _____ that can be used to choose whether to copy the value with formatting, without formatting, or only copy the format.
a. Auto Sum Options button
b. Auto Correct Options button
c. Auto Fill Options button
d. Auto Complete Options button
5. A new workbook opens with ____________ sheets.
a. 1
b. 2
c. 3
d. 4
6. As you type, data displays in the ____________.
a. formula bar
b. status bar
c. toolbar
d. d. menu
bar
7. A group of adjacent cells, for example, B2, B3, B4, B5, are called a ____________.
a. grouping
b. range
c. set
d. sorting
8. _________________________ is a powerful spreadsheet program that allows users to organize data, complete calculations, make decisions, graph data, develop professional looking reports, publish organized data to the Web, and access real-time data from Web sites.
9. The intersection of a row and column in the worksheet in the accompanying figure is a(n) _________________________, which is the basic unit into which data is entered.
|
|
|
|
T F |
10. A number above the worksheet grid, also called the row heading, identifies each column. |
|
T F |
11. A letter on the left side of the worksheet grid, also called the column heading, identifies each row. |
|
T F |
12. To identify a cell, specify the row number first, followed by the column letter. |
|
T F |
13. The mouse pointer appears as a block arrow whenever it is located in a cell on the worksheet. |
|
T F |
14. When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as these cells contain no data. |
|
T F |
15. Text entered in a cell cannot be realigned. |
|
T F |
16. The main thing Excel is used for is typing text documents. |
|
T F |
17. A range is a group of cells. |
|
T F |
18. The merge and center button will combine several cells into one cell and place the text in the middle of the merged cell. |
|
T F |
19. The Freeze Panes command freezes rows abouve and columns to the right of the highlight. |
|
T F |
20. To select a group of cells, click each cell individually until all cells have been selected. |
PART B) Write the Letter
of the Correct Matching Term next to the Definition
TURN YOUR TEST INTO THE TRAY WHEN YOU ARE FINISHED.