Multiple Choice Identify the
choice that best completes the statement or answers the question.
|
|
1.
|
The first step in creating an effective worksheet is to make sure you
_____.
a. | apply font formatting | c. | insert a chart | b. | understand what is required | d. | enter the data |
|
|
2.
|
To enter data in a cell, you must first select or activate the _____.
a. | row | c. | column | b. | worksheet | d. | cell |
|
|
3.
|
To cancel an entire entry before entering it into the cell, press the _____
key.
|
|
4.
|
Clicking the _____ box completes an entry.
a. | Cancel | c. | Enter | b. | Formula | d. | Tab |
|
|
5.
|
The _____ is a blinking vertical line that indicates where the next typed
character will appear.
a. | scroll box | c. | insertion point | b. | sheet tab | d. | split bar |
|
|
6.
|
The _____ feature works behind the scenes, fixing common typing or spelling
mistakes when you complete a text entry.
a. | AutoComplete | c. | AutoFormat | b. | AutoCorrect | d. | AutoTyping |
|
|
7.
|
Pressing the _____ key to complete an entry activates the adjacent cell to the
right.
a. | RIGHT ARROW | c. | UP ARROW | b. | LEFT ARROW | d. | DOWN ARROW |
|
|
8.
|
By default, text is _____ in a cell.
a. | left-aligned | c. | justified | b. | centered | d. | right-aligned |
|
|
9.
|
In Excel, a number can contain the characters _____.
a. | 0 1 2 3 4 5 6 7 8 9 | c. | . $ % E e | b. | + - ( ) , / | d. | all of the
above |
|
|
10.
|
To enter a number such as 6,000,000,000,000,000 you can type
6,000,000,000,000,000 or you can type _____.
a. | 6,000T | c. | 6Q | b. | 6K000 | d. | 6E15 |
|
|
11.
|
A _____ is a series of two or more adjacent cells in a column or row or a
rectangular group of cells.
a. | range | c. | nearby cell | b. | bunch | d. | neighbor |
|
|
12.
|
You can enter the correct range in a function by typing the beginning and ending
cell references separated by a ____.
a. | semi-colon (;) | c. | period (.) | b. | colon (:) | d. | none of the
above |
|
|
13.
|
The _____ is the small black square located in the lower-right corner of the
heavy border around the active cell.
a. | selection handle | c. | fill handle | b. | sizing handle | d. | copy handle |
|
|
14.
|
You _____ a worksheet to emphasize certain entries and make the worksheet easier
to read and understand.
a. | save | c. | format | b. | print | d. | clear |
|
|
15.
|
You can apply the Bold font style by pressing the _____ keyboard shortcut
keys.
a. | ALT+B | c. | SHIFT+B | b. | CTRL+B | d. | TAB+B |
|
|
16.
|
Combining two or more selected cells into one cell is called _____ cells.
a. | merging | c. | combining | b. | mixing | d. | spanning |
|
|
17.
|
Which of the following is the Ribbon path to the Cell Styles button?
a. | (Home tab | Styles group) | c. | (Home tab | Format
group) | b. | (Styles tab | Home group) | d. | (Format tab | Styles group) |
|
|
18.
|
A(n) _____ chart is drawn on the same worksheet as the data.
a. | embedded | c. | embodied | b. | emboldened | d. | empowered |
|
|
19.
|
The _____ area on the status bar displays common calculations, such as SUM or
AVERAGE, for selected numbers in the worksheet.
a. | AutoFormat | c. | AutoFunction | b. | AutoComplete | d. | AutoCalculate |
|
|
20.
|
The _____ button is located on the Quick Access Toolbar.
a. | Undo | c. | Bold | b. | Cell Style | d. | Increase
Decimal |
|