Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
1.
|
__________ are a collection of worksheets.
a. | Workbooks | c. | Papers | b. | Booklets | d. | Work hours |
|
|
|
2.
|
The person or persons requesting the worksheet should supply their requirements
in a __________ document.
a. | blank | c. | requirements | b. | test issues | d. | certified |
|
|
|
3.
|
What is the title of the blank workbook that opens when you first start Excel
from the Windows Start menu?
a. | Workbook1 | c. | Book | b. | Work1 | d. | Book1 |
|
|
|
4.
|
The intersection of each column and row is called a __________.
a. | row-column | c. | column-row | b. | Worksheet tab | d. | cell |
|
|
|
5.
|
The __________ toolbar, which appears automatically based on tasks you perform
(such as
selecting text), contains commands related to changing the appearance of text in a
worksheet.
a. | Quick | c. | Mini | b. | Short | d. | Long |
|
|
|
6.
|
A(n) __________ is a list of additional commands associated with the selected
command.
a. | Alt command | c. | call-out | b. | submenu | d. | Quick command |
|
|
|
7.
|
In Excel, any set of characters containing a letter, hyphen (as in a telephone
number), or
space is considered __________.
a. | text | c. | empty | b. | numeric | d. | incorrect |
|
|
|
8.
|
If you prefer using the keyboard, instead of the mouse, you can press the ALT
key on
the keyboard to display a(n) __________.
a. | Keyboard picture | c. | Image mouse | b. | Key Tip badge | d. | Mouse image
badge |
|
|
|
9.
|
When a cell entry is positioned at the far left in the cell, it is considered
__________.
a. | left- and right-aligned | c. | left-aligned | b. | center-aligned | d. | right-aligned |
|
|
|
10.
|
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 |
|
|
|
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.
|
The cell being copied is called the source area (or copy area). The range of
cells receiving the copy is called the __________.
a. | receiver cell | c. | receiving range | b. | final cell | d. | destination area (or paste
area) |
|
|
|
13.
|
Saving the workbook frequently is important for the following reason:
a. | so you have a lot of copies of the same file | b. | because the workbook
loses data the longer it sits | c. | if you lose power, the worksheet could be
lost | d. | it is not necessary to save frequently |
|
|
|
14.
|
While Excel is saving your file, it briefly displays a message on the status bar
indicating __________.
a. | the number of cells used | c. | the amount of the file
saved | b. | the author name | d. | you must click the Save button |
|
|
|
15.
|
Combining two or more cells together is called __________ cells.
a. | merging | c. | combining | b. | mixing | d. | spanning |
|
|
|
16.
|
What effect does the Accounting Number Format have on the selected cells?
a. | converts alphabetic characters to numbers | b. | causes cells with
two decimal places to align vertically correctly | c. | performs tax calculations | d. | copies the numbers
of one cell to another |
|
|
|
17.
|
What effect does the Comma Style format have on the selected cells?
a. | converts decimals to commas within a cell | b. | converts decimals to
commas within merged cells | c. | causes the cells to display with two decimal
places and commas as thousands separators | d. | allows for substitution of selected
characters |
|
|
|
18.
|
A(n) __________ chart is drawn on the same worksheet as the data.
a. | embedded | c. | author-signature | b. | sketch | d. | cell-outline |
|
|
|
Figure 1-1
|
|
|
19.
|
In the accompanying figure, the __________ identifies the colors assigned to
each bar in the chart on a worksheet.
a. | color code | c. | explanation | b. | identifier | d. | legend |
|
|
|
20.
|
Which key on the keyboard toggles between Insert mode and Overtype mode?
a. | Insert | c. | Tab | b. | Enter | d. | Num Lock |
|
|
|
Figure 1-2
|
|
|
21.
|
Excel opens a new workbook with three __________ , as shown in the accompanying
figure.
a. | shakes | c. | worksheets | b. | names | d. | charts |
|
|
|
22.
|
The commands to insert a chart are located on the __________ tab, as shown in
the accompanying figure.
a. | Fast Chart | c. | Quick Chart | b. | Home | d. | Insert |
|
|
|
23.
|
In the acccompanying figure, the __________ button and __________ button next to
the Help icon, are used to minimize and restore the worksheet within the Excel window.
a. | Collapse, Expand | c. | Help, Answer | b. | Minimize, Restore | d. | Question,
Answer |
|
|
|
24.
|
In the accompanying figure, by using the __________ area on the status bar, you
easily can obtain a total, an average, or other information about the numbers in a range.
a. | AutoCalculate | c. | CalculateNow | b. | AutoNumbering | d. | FastRange |
|
|
|
25.
|
Every time you enter a value into a cell in the worksheet, Excel automatically
____ formulas.
a. | recalculates new | c. | recalculates old | b. | recalculates some | d. | recalculates
all |
|
|
|
26.
|
To save a previously saved workbook with a new name or on a different drive,
____.
a. | click the Save button on the Quick Access Toolbar | b. | click Save As on the
File menu | c. | press CTRL+S | d. | click Save on the File
menu |
|
|
|
27.
|
When Excel follows the order of operations, the formula, 8 * 3 + 2, equals
____.
|
|
|
28.
|
When an error occurs in a formula in a cell, Excel displays the ____ button next
to the cell and identifies the cell with the error by placing a green triangle in the upper left of
the cell.
a. | Smart Tag Actions | c. | Trace Error | b. | AutoCorrect Options | d. | Auto Fill
Options |
|
|
|
29.
|
Using the ____ button on the Ribbon instructs Excel to display additional
decimal places in a cell.
a. | AutoFormat | c. | Increase Decimal | b. | Currency Style | d. | Percent Style |
|
|
|
30.
|
Click ____ in the Conditional Formatting gallery to display the New Formatting
Rule dialog box.
a. | Rule Format | c. | New Format | b. | New Rule | d. | Format Rule |
|
|
|
31.
|
____ means that the width of the column will be increased or decreased so
the widest entry will fit in the column.
a. | Auto column adjust | c. | Auto adjust | b. | Width fit | d. | Best fit |
|
|
|
32.
|
To instruct Excel to display a hidden column, position the mouse pointer to the
____.
a. | left of the column heading boundary where the hidden column is located and then drag
to the right | b. | right of the column heading boundary where the hidden column is located and then drag
to the left | c. | left of the column heading boundary where the hidden column is located and then drag
to the left | d. | right of the column heading boundary where the hidden column is located and then drag
to the right |
|
|
|
33.
|
As with column widths, when you decrease the row height to 0, the row is
____.
a. | hidden | b. | visible temporarily at the top of the
worksheet | c. | deleted | d. | visible temporarily on the left side of the
worksheet |
|
|
|
Figure 2-3
|
|
|
34.
|
In the Print dialog box shown in the accompanying figure, the ____ instructs
Excel to print the selected range.
a. | Selection option button | c. | Active sheet(s) option
button | b. | Print to file check box | d. | Collate check box |
|
|
|
35.
|
In the Print dialog shown in the accompanying figure, the ____ instructs Excel
to print the worksheet currently on the screen or the selected worksheets.
a. | Selection option button | c. | Active sheet(s) option
button | b. | Print to file check box | d. | Collate check box |
|
|
|
36.
|
In the Print dialog box shown in the accompanying figure, the ____ instructs
Excel to print all the worksheets with content in the workbook.
a. | Entire workbook option button | c. | Selection option
button | b. | All option button | d. | Active sheet(s) option button |
|
|
|
37.
|
In the accompanying figure, what will be printed when you click the OK
button?
a. | The entire workbook | c. | All pages in the worksheet | b. | The active
workbook | d. | The active
worksheet |
|
|
|
38.
|
Excel does not display the Print dialog box shown in the accompanying
figure when the ____ is used.
a. | Print button in a dialog box | c. | Print button in the Preview
window | b. | Print command on the File menu | d. | Print button on the Quick Access
Toolbar |
|
|
|
Figure 2-2
|
|
|
39.
|
In the accompanying figure, the Page Setup button displays the ____ dialog
box.
a. | Print setup for the page | c. | Page Setup | b. | Setup | d. | Page |
|
|
|
40.
|
The ____ button, in the accompanying figure, allows you to view the page in
larger or smaller sizes in the Preview window.
a. | Next page | c. | Page Setup | b. | Zoom | d. | Preview |
|
|
|
41.
|
To toggle between the values version and the formulas version of a worksheet,
hold down the ____ key.
a. | ALT key while pressing the ACCENT MARK (`) | b. | ALT key while
pressing the SINGLE QUOTATION MARK (') | c. | CTRL key while pressing the ACCENT MARK
(`) | d. | CTRL key while pressing the SINGLE QUOTATION MARK
(') |
|
|
|
42.
|
The ____ of the worksheet shows the actual formulas you have entered, rather
than the resulting values.
a. | Actual symbol | c. | formulas version | b. | current version | d. | Formulas Print
symbol |
|
|
|
43.
|
The process of finding and correcting errors in a worksheet is called
____.
a. | searching and replacing | c. | verifying | b. | debugging | d. | validating |
|
|
|
44.
|
To import data stored on a Web site use a ____.
a. | Web query | c. | Web import | b. | Web search | d. | Web copy |
|
|
|
45.
|
To rename sheets, double-click the sheet tab in the lower-left corner of the
window, type the new sheet name, and then ____.
a. | click the Cancel box | c. | click the Name box | b. | press the ESC key | d. | press the ENTER
key |
|
|
|
46.
|
E-mailing a workbook from Excel sends the workbook as a(n) ____ in the
e-mail.
a. | picture | c. | box | b. | attachment | d. | table |
|
|
|
Figure 3-1
|
|
|
47.
|
In the accompanying figure, if you enter 90 in the Degrees box in the
Orientation area, the text will appear ____.
a. | horizontal and read from left to right in the row | b. | horizontal and read
from top to bottom in the column | c. | vertically and read from top to bottom in the
cell | d. | vertically and read from bottom to top in the cell |
|
|
|
48.
|
In the accompanying figure, the Alignment tab allows you to position data by
____.
a. | indenting, rotating | c. | centering, left-aligning, or right-aligning | b. | aligning at the top,
bottom, or center | d. | all of
the above |
|
|
|
49.
|
In addition to creating a series of values, dragging the fill handle instructs
Excel to ____ the format of a cell to a range.
a. | copy | c. | delete | b. | move | d. | cut |
|
|
|
50.
|
Which of the following is not a valid format symbol?
a. | semi-colon (;) | c. | dollar sign ($) | b. | percent sign (%) | d. | comma (,) |
|
|
|
51.
|
When assigned to a cell, the ____ function returns a number that corresponds to
the system date and time beginning with December 31, 1899.
a. | SYSDATE | c. | DATETIME | b. | NOW | d. | CURRENT |
|
|
|
52.
|
A formula using the ____ cell reference B20 instructs Excel to adjust the cell
reference as it copies it to the destination area.
a. | variable | c. | relative | b. | absolute | d. | constant |
|
|
|
53.
|
The ____ function is useful when you want to assign a value to a cell based on a
logical test.
|
|
|
54.
|
Which comparison operator means “not equal to”?
|
|
|
55.
|
A Pie chart with one or more slices offset is called a(n) ____.
a. | exploded Pie chart | c. | Bar chart | b. | segmented Pie chart | d. | 2-D chart |
|
|
|
56.
|
When you change a value on which a chart is dependent, Excel ____.
a. | does not do anything until you save the change | b. | immediately redraws
the chart based on the new value | c. | gives an error message | d. | prompts you to save
the change |
|
|
|
57.
|
When you ____ a worksheet, Excel is able to display more columns and
rows.
a. | shrink | c. | expand | b. | minimize | d. | maximize |
|
|
|
58.
|
Using Excel to scrutinize the impact of changing values in cells that are
referenced by a formula in another cell is called ____.
a. | verification seeking | c. | goal seeking | b. | the IF function | d. | what-if
analysis |
|
|
|
59.
|
If you know the result you want a formula to produce, you can use ____ to
determine the value of a cell on which the formula depends.
a. | verification seeking | c. | goal seeking | b. | the IF function | d. | what-if
analysis |
|
|
|
60.
|
The ____ is ideal for returning the worksheet to its original state after you
have changed the values in a worksheet to answer a what-if question.
a. | Undo button | c. | Copy button | b. | Redo button | d. | Cut button |
|