Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
1.
|
In Excel, a computerized spreadsheet is called a ____.
a. | worksheet | c. | workbook | b. | table | d. | file |
|
|
|
2.
|
When Excel starts, the program window displays a blank workbook titled
Book1, which includes ____ blank worksheets.
|
|
|
3.
|
The name of each worksheet appears in the ____ at the bottom of the worksheet
window.
a. | sheet box | c. | sheet dialog box | b. | sheet task bar | d. | sheet tab |
|
|
|
4.
|
____ of the worksheet appear vertically and are identified by letters at the top
of the worksheet window.
a. | Columns | c. | Cells | b. | Rows | d. | Headings |
|
|
|
5.
|
____ appear horizontally and are identified by numbers on the left side of the
worksheet window.
a. | Columns | c. | Headings | b. | Rows | d. | Cells |
|
|
|
6.
|
Each cell is identified by a unique cell reference, which is formed by combining
the cell’s column letter and ____.
a. | row number | c. | cell contents | b. | row heading | d. | column heading |
|
|
|
7.
|
The ____, or cell reference area located below the Ribbon, displays the cell
reference of the active cell.
a. | Name Space | c. | Name Pane | b. | Formula Bar | d. | Name Box |
|
|
|
8.
|
The range is identified by its range reference, which is the cell in its
upper-left corner and the cell in its lower-right corner, separated by a ____.
a. | colon | c. | comma | b. | semicolon | d. | period |
|
|
|
9.
|
Numbers that extend beyond a cell’s width appear as ____ in the
cell.
|
|
|
10.
|
The____ always appear in the Formula Bar.
a. | contents of the active cell | c. | workbook name | b. | file
name | d. | worksheet
name |
|
|
|
11.
|
To edit the data directly in a cell, make the cell active and then press the
____ key or double-click the cell.
|
|
|
12.
|
The ____ dialog box enables you to select a printer, the number of copies to
print, the parts of the worksheet to print, and the way the printed worksheet will look.
a. | Selection | c. | Print | b. | Print Now | d. | Output |
|
|
|
13.
|
To switch to Print Preview, click ____ in the Print dialog box.
a. | Review | c. | View | b. | Print | d. | Preview |
|
|
|
14.
|
If you want to specify a precise column width, use the Column Width ____.
a. | wizard | c. | status bar | b. | task pane | d. | dialog box |
|
|
|
15.
|
____ determines the best width for a column or the best height for a row, based
on its contents.
a. | MaxFit | c. | FitNow | b. | FitAuto | d. | AutoFit |
|
|
|
16.
|
You can change the width of several columns at one time. Select the columns you
want to resize. Then, use the pointer to click and drag the ____ edge of one of the selected column
headings.
a. | top | c. | right | b. | left | d. | bottom |
|
|
|
17.
|
Unless you specify otherwise, numbers you enter in a cell are lined up along the
____ side of the cell.
a. | bottom-right | c. | bottom-left | b. | upper-right | d. | upper-left |
|
|
|
18.
|
Excel ____ all numbers.
a. | right-aligns | c. | top-aligns | b. | left-aligns | d. | bottom-aligns |
|
|
|
19.
|
You can also center cell contents across several columns. Select the cells, and
then click the ____ button in the Alignment group on the Home tab of the Ribbon.
a. | Align | c. | Center | b. | Merge | d. | Merge &
Center |
|
|
|
20.
|
Data can be indented (or ____) within cells to help distinguish categories or
set data apart.
a. | shifted to the right | c. | shifted up | b. | shifted to the left | d. | shifted down |
|
|
|
21.
|
To change text orientation, select the cells whose contents you want to rotate.
Click the ____ button in the Alignment group on the Home tab of the Ribbon.
a. | Move | c. | Orientation | b. | Text | d. | Align |
|
|
|
22.
|
A ____ is a preset collection of design elements, including fonts, colors, and
other effects.
a. | gallery | c. | theme | b. | style | d. | group |
|
|
|
23.
|
As you format cells, ____ shows the results of the different formatting options
you
can choose.
a. | Print Preview | c. | Gallery Preview | b. | Live Preview | d. | Format Preview |
|
|
|
24.
|
Press the ____ keys to apply underlining.
a. | Ctrl+B | c. | Ctrl+U | b. | Ctrl+L | d. | Ctrl+I |
|
|
|
25.
|
After you copy and paste, the ____ button appears next to the cell or range with
the pasted item.
a. | Paste Parameters | c. | Paste Options | b. | Paste Format | d. | Paste Selection |
|
|
|
26.
|
Click the Ctrl+C keys to ____ selected cells.
|
|
|
27.
|
Click the Ctrl+V keys to ____ the selected cells.
|
|
|
28.
|
____ places the last item from the Clipboard into the cell or range selected in
the worksheet.
a. | Moving | c. | Selecting | b. | Losing | d. | Pasting |
|
|
|
29.
|
To insert a row, click the ____ to select the row where you want the new row to
appear. Then, click the Insert button in the Cells group on the Home tab.
a. | row number | c. | column letter | b. | row letter | d. | column number |
|
|
|
30.
|
Worksheets printed in ____ orientation are wider than they are long.
a. | portrait | c. | wide | b. | landscape | d. | normal |
|
|
|
31.
|
Excel inserts ____whenever it runs out of room on a page.
a. | a blank row | c. | an automatic hyperlink | b. | an automatic page
break | d. | a paragraph
marker |
|
|
|
32.
|
The simplest way to adjust page breaks in a worksheet is in ____.
a. | Page Break Preview | c. | Design View | b. | Layout View | d. | Controls View |
|
|
|
33.
|
A ____ is text that prints in the top margin of each page.
a. | header | c. | margin | b. | footer | d. | marker |
|
|
|
34.
|
A ____ is text that prints in the bottom margin of each page.
a. | header | c. | margin | b. | footer | d. | marker |
|
|
|
35.
|
A(n) ____ is a constant (text or number) or cell reference used in a
formula.
a. | factor | c. | formula | b. | operator | d. | operand |
|
|
|
36.
|
After you finish typing a formula in a cell, you must enter it by pressing the
____.
a. | Enter key | c. | Enter button on the formula bar | b. | Tab
key | d. | all of the
above |
|
|
|
37.
|
The sequence used to calculate the value of a formula is called the ____.
a. | evaluation map | c. | order of evaluation | b. | sequence map | d. | sequence order |
|
|
|
38.
|
When evaluating formulas, the ____ of parentheses is evaluated first.
a. | innermost set | c. | set that starts farthest to the right | b. | outermost
set | d. | set that starts
farthest to the left |
|
|
|
39.
|
Three types of cell references are used in formulas that do NOT include
____.
a. | relative | c. | mixed | b. | absolute | d. | relational |
|
|
|
40.
|
Cell references that contain both ____ references are called mixed cell
references.
a. | relative and absolute | c. | relative and relational | b. | relational and
absolute | d. | none of the
above |
|
|
|
41.
|
You can press the ____ key to cycle a selected cell reference from a relative
reference to an absolute reference to a mixed reference with an absolute row to a mixed reference
with an absolute column and back to a relative reference.
|
|
|
42.
|
You can also switch between showing formulas and showing formula results in a
worksheet by pressing the ____ keys.
a. | Ctrl+? (question mark) | c. | Ctrl+! (exclamation point) | b. | Ctrl+` (grave
accent) | d. | Ctrl+*
(asterisk) |
|
|
|
43.
|
When you move the pointer into the formula bar or edit directly in a worksheet
cell, the pointer changes to ____.
a. | a hand | c. | double arrows | b. | crosshairs | d. | an I-beam |
|
|
|
44.
|
A relative cell reference adjusts to its new location when copied or moved. For
example, when the formula =A3+A4 is copied from cell A5 to cell B5, the formula changes to
____.
a. | =B3+B4 | c. | =$B3+$B4 | b. | =B4+B5 | d. | =B$4+B$5 |
|
|
|
45.
|
When the formula =$A$3+$A$4 in cell A5 is copied to cell B7, the formula is
____.
a. | =$A$3+$A$4 | c. | =A3+A4 | b. | =$B$5+$B$6 | d. | =$B$3+$B$4 |
|
|
|
46.
|
The SUM function that adds the numbers in the range D5:D17 is ____.
a. | SUM(D5:D17) | c. | (D5:D17)SUM | b. | =SUM(D5:D17) | d. | =(D5:D17)SUM |
|
|
|
47.
|
____ helps you enter a formula with a valid function name and arguments. As you
begin to type the function name, a list of function names appears below the active cell.
a. | Formula Complete | c. | Formula Selector | b. | Formula Now | d. | Formula
AutoComplete |
|
|
|
48.
|
An example of a square root function written correctly is ____.
a. | SQRT(C4) | c. | =SQRT(C4) | b. | =SQROOT(C4) | d. | SQROOT(C4) |
|
|
|
49.
|
An example of the function that returns the number of cells in a range of cells
that contain data is ____.
a. | =NUMBER(B4) | c. | =NUMBER(B4:B15) | b. | =COUNT(B4) | d. | =COUNT(B4:B15) |
|
|
|
50.
|
In the IF function, the second argument determines the value that appears in the
cell if the logical test is ____.
a. | false | c. | an error | b. | true | d. | none of the
above |
|
|
|
51.
|
In the IF function, the third argument determines the value that appears in the
cell if the logical test is ____.
a. | false | c. | an error | b. | true | d. | none of the
above |
|
|
|
52.
|
The ____ function returns the current date and time based on the
computer’s date and time settings.
a. | NOW( ) | c. | CURRENT( ) | b. | WHEN( ) | d. | DATE( ) |
|
|
|
53.
|
____ functions are used to format and work with cell contents
a. | Word | c. | Statistical | b. | Logical | d. | Text |
|
|
|
54.
|
To hide more than one row, select how many rows you want to hide, and then ____
the selection to show the short-cut menu.
a. | right-click | c. | highlight | b. | left-click | d. | double-click |
|
|
|
55.
|
When the shape is selected, the ____ appear on the Ribbon and contain the Format
contextual tab.
a. | Drawing Tools | c. | Graphic Tools | b. | Shape Tools | d. | Editing Tools |
|
|
|
56.
|
When you no longer need a shape or any other object in a worksheet, you can
delete it. First, click the object to select it. Then press the ____ key.
a. | Recycle | c. | Erase | b. | Remove | d. | Delete |
|
|
|
57.
|
____ graphics enhance worksheets by providing a visual representation of
information and ideas.
a. | SmartClips | c. | SmartPhotos | b. | SmartPictures | d. | SmartArt |
|
|
|
58.
|
A(n) ____ is a digital photograph or other image file.
a. | attachment | c. | picture | b. | fax | d. | shape |
|
|
|
59.
|
To insert a picture from a file, click the ____ button in the Illustrations
group on the Insert tab of the Ribbon.
a. | Format | c. | Data | b. | Shape | d. | Picture |
|
|
|
60.
|
The ____ contextual tab contains tools to edit and format the picture.
a. | Edit | c. | Delete | b. | Format | d. | Graphics |
|
|
|
61.
|
A ____ is a cell in a worksheet that opens another file or page when you click
it.
a. | hyperlink | c. | transporter | b. | button | d. | pop-up cell |
|
|
|
62.
|
You can create hyperlinks to ____.
a. | another Web page | b. | a specific location in the current
workbook | c. | an e-mail address | d. | all of the
above |
|
|
|
63.
|
A ____ is a note attached to a cell that is usually used to explain or identify
information contained in the cell.
a. | memo | c. | callout | b. | pop-up | d. | comment |
|
|
|
64.
|
The ____ task pane provides access to information typically found in references
such as dictionaries, thesauruses, and encyclopedias.
a. | Research | c. | Library | b. | Resource | d. | Reference |
|
|
|
65.
|
Until the ____ are named, they are identified as Sheet1, Sheet2, and so
on.
a. | worksheets | c. | cells | b. | workbooks | d. | ranges |
|
|
|
66.
|
The active sheet has a ____ sheet tab.
a. | blue | c. | red | b. | white | d. | black |
|
|
|
67.
|
To rename a worksheet, double-click its sheet tab, type the new name, and then
press the ____ key.
|
|
|
68.
|
To change the tab color of a worksheet, right-click the sheet tab you want to
recolor, point to ____ on the shortcut menu, and then click the color you want for that tab.
a. | Tab | c. | Recolor | b. | Color | d. | Tab Color |
|
|
|
69.
|
You can reposition a worksheet by dragging its ____ to a new location.
a. | sheet tab | c. | file name | b. | cells | d. | right border |
|
|
|
70.
|
In a worksheet range, as in a cell range, a ____ separates the names of the
first worksheet and the last worksheet in the group.
a. | period | c. | comma | b. | colon | d. | semicolon |
|
|
|
71.
|
When working with cell references, any change you make to the ____ cell also
changes the value in the destination cell.
a. | source | c. | main | b. | primary | d. | active |
|
|
|
72.
|
The Print what option called ____ prints all of the worksheets in a
workbook.
a. | Active Sheet(s) | c. | Entire workbook | b. | Selection | d. | All Sheet(s) |
|
|
|
73.
|
To select multiple worksheets in a workbook, hold down the ____ key as you click
the sheet tab of each worksheet you want to include in the group.
|
|
|
74.
|
To make a workbook active, just click ____.
a. | its title bar | c. | either a. or b. | b. | anywhere in the worksheet | d. | neither a. nor
b. |
|
|
|
75.
|
To move or copy a worksheet, right-click the sheet tab of the worksheet you want
to move or copy, and then click ____ on the shortcut menu.
a. | Move or Copy | c. | New | b. | Relocate | d. | Location |
|
|
|
76.
|
The chart types are available on the ____ tab in the Charts group.
a. | Data | c. | Worksheet | b. | Edit | d. | Insert |
|
|
|
77.
|
You can rename a chart sheet like any other worksheet. Right-click its sheet
tab, and then click ____ on the shortcut menu.
a. | Text box | c. | File name | b. | Rename | d. | Chart name |
|
|
|
78.
|
The chart element called ____ is the graphical representation of all of the data
series.
a. | Chart area | c. | Data area | b. | Plot area | d. | Data marker |
|
|
|
79.
|
The chart element called ____ is a symbol that represents a single data point or
value from the corresponding worksheet cell.
a. | Chart area | c. | Data marker | b. | Plot area | d. | Data symbol |
|
|
|
80.
|
A selected chart element is surrounded by a ____.
a. | fill box | c. | text box | b. | selection box | d. | border |
|
|
|
81.
|
A chart, whether embedded in a worksheet or on a chart sheet, is considered part
of a ____.
a. | workbook | c. | data file | b. | database | d. | report |
|
|
|
82.
|
You switch between a chart sheet and a worksheet by clicking the appropriate
____.
a. | sheet tab | c. | icon | b. | file name | d. | data marker |
|
|
|
83.
|
The chart element called ____ is a grid that displays the data plotted in the
chart.
a. | Data label | c. | Data table | b. | Data series | d. | Data marker |
|
|
|
84.
|
A ____ chart shows the relationship of a part to a whole.
a. | pie | c. | line | b. | column | d. | scatter |
|
|
|
85.
|
To access the Format dialog box, select the chart you want to edit. Then, on the
Format tab under Chart Tools on the Ribbon, in the Current Selection group, click the ____
button.
a. | Format | c. | Format Selection | b. | Selection | d. | Chart Selection |
|