Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
1.
|
On the Ribbon each __________ surrounds a collection of groups.
a. | cluster | c. | aggregate | b. | tab | d. | mode |
|
|
|
2.
|
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 |
|
|
|
3.
|
A(n) __________ is a list of additional commands associated with the selected
command.
a. | Alt command | c. | call-out | b. | submenu | d. | Quick command |
|
|
|
4.
|
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 |
|
|
|
5.
|
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 |
|
|
|
6.
|
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 |
|
|
|
7.
|
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 |
|
|
|
8.
|
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 |
|
|
|
9.
|
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 |
|
|
|
10.
|
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) |
|
|
|
11.
|
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 |
|
|
|
12.
|
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 |
|
|
|
13.
|
The ____ button lists formatting options following an insertion of cells, row,
or columns.
a. | Paste Options | c. | Auto Fill Options | b. | Insert Options | d. | AutoCorrect
Options |
|
|
|
14.
|
In Excel, functions can be entered using any of the following methods
except the ____.
a. | Function command on the Tools menu | c. | Insert Function box in the formula
bar | b. | keyboard or mouse | d. | AutoSum command on the Formulas tab |
|
|
|
15.
|
How do you activate Range Finder to verify a formula in a cell?
a. | Range Finder does not verify formulas | c. | Double-click in the
cell | b. | Press the ESC key | d. | Click the Range Finder button |
|
|
|
16.
|
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 |
|
|
|
17.
|
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 |
|
|
|
18.
|
When Excel starts and the blank worksheet displays on the screen, all of the
columns have a default width of ____.
a. | 8.43 characters, or 64 pixels | c. | 12.75 points, or 17
pixels | b. | 64 characters, or 8.43 pixels | d. | 17 points, or 12.75
pixels |
|
|
|
19.
|
____ 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 |
|
|
|
20.
|
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 |
|
|
|
21.
|
If you want to increase or decrease column width significantly, you can
right-click a column heading and then use the ____ command on the shortcut menu to change the
column’s width.
a. | Column Width | c. | Width Adjustment | b. | Adjust Width | d. | Increase Column |
|
|
|
22.
|
Click Microsoft Office in the ____ list to display the Microsoft Office
list.
a. | All Applications | c. | Start | b. | Excel | d. | All Programs |
|
|
|
23.
|
With large worksheets that extend beyond the size of a window, it is best to
enter titles in the ____.
a. | upper-right corner | c. | upper-center | b. | left-center row | d. | upper-left
corner |
|
|
|
Figure 3-1
|
|
|
24.
|
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 | c. | vertically and read from top to
bottom in the cell | b. | horizontal and read from top to bottom in the
column | d. | vertically and read
from bottom to top in the cell |
|
|
|
25.
|
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 |
|
|
|
26.
|
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 |
|
|
|
27.
|
If you drag the fill handle to the left or up, Excel will ____ the series rather
than ____ the series.
a. | increment, decrement | c. | copy, cut | b. | decrement, increment | d. | cut, copy |
|
|
|
28.
|
Which of the following is not an Auto Fill option?
a. | Copy Cells | c. | Fill Series | b. | Fill Cells | d. | Fill Formatting
Only |
|
|
|
Figure 3-2
|
|
|
29.
|
In the accompanying figure, the split double arrow mouse pointer ____.
a. | indicates a hidden column | c. | is the result of moving the mouse
pointer to the boundary between column heading A and column heading B | b. | allows text to be
entered at that location | d. | indicates the proposed width of column A |
|
|
|
30.
|
In the accompanying figure, if you drag the pointer to the right, a ScreenTip
indicates the ____.
a. | name of the column | c. | width of the column | b. | heading of the column | d. | height of the
row |
|
|
|
31.
|
The Increase Indent button indents the contents of a cell to the right by ____
spaces each time you click it.
|
|
|
32.
|
In a formula, to use a cell name that is made up of two or more words, replace
any space with the ____.
a. | ampersand character (&) | c. | plus sign character
(+) | b. | hyphen (-) | d. | underscore character (_) |
|
|
|
33.
|
Which arguments belong to the PMT function?
a. | rate | c. | loan amount | b. | payment | d. | all of the
above |
|
|
|
34.
|
What does Excel do as you enter a function in a cell?
a. | displays the function’s form in a ScreenTip | c. | displays the function’s form
in the ToolTips | b. | calculates the value | d. | finishes entering the formula |
|
|
|
35.
|
To test formulas in a worksheet, consider using ____.
a. | negative numbers | c. | zero | b. | large positive numbers | d. | all of the
above |
|
|
|
36.
|
A ____ is a range of cells that shows the answers generated by formulas
in
which different values have been substituted.
a. | function | c. | formula variable | b. | data table | d. | formula table |
|
|
|
37.
|
With a ____, you vary the value in one cell and then Excel calculates the
results of one or more formulas and fills the data table with the results.
a. | two-input data table | c. | one–input data table | b. | function | d. | formula |
|
|
|
38.
|
The purpose of a data table is to organize ____.
a. | sections and formats | c. | the answers to what-if questions | b. | functions in the
worksheet | d. | formulas in the
worksheet |
|
|
|
39.
|
The two kinds of data tables that can be created are ____ and ____.
a. | row, column | c. | section, title | b. | one input, two input | d. | single,
multiple |
|
|
|
40.
|
By double-clicking the top of the heavy black border surrounding an active cell,
Excel will make the first ____ in the column active.
a. | non-blank cell | c. | filled cell | b. | row | d. | formatted cell |
|
|
|
41.
|
By double-clicking the ____ side of the heavy black border surrounding the
active cell, Excel will make the first non-blank cell in the row the active cell.
a. | top | c. | bottom | b. | left | d. | right |
|
|
|
42.
|
To treat the range of cells over which a single cell is centered, what method
would you use?
a. | select center | c. | move and center | b. | right-click and select
center | d. | merge and
center |
|
|
|
43.
|
Another way to format a range as a table is to ____.
a. | select range, on Insert tab on Ribbon click Table, click OK button | c. | select range, press
ALT+D, I, C | b. | select range, press ALT+H+T, select quick style | d. | all of the
above |
|
|
|
44.
|
Excel automatically creates an empty row in the table so that you are ready to
enter the first ____ in the table.
a. | formula | c. | record | b. | field | d. | cell |
|
|
|
45.
|
No visible changes appear on the worksheet when the table contains no records.
As records are entered into the table, the assigned formats apply, even as more ____ are added to the
table.
a. | rows | c. | data | b. | columns | d. | functions |
|
|
|
46.
|
Excel has built-in data ____ features to ensure that the data entered into a
cell or range of cells is within limits.
a. | calculation | c. | validation | b. | guideline | d. | maximization |
|
|
|
47.
|
To change an active list back to a normal range of cells, right-click the range,
point to Table on the shortcut menu, and then click ____ on the Table submenu.
a. | Inactive Range | c. | Convert to Range | b. | Active Range | d. | Normal Range |
|
|
|
48.
|
A data validation rule that is cautionary, is also considered to be a
____.
a. | Mandatory rule | c. | Stop | b. | Warning | d. | Relaxed rule |
|
|
|
49.
|
The output of inaccurate information that results from the input of invalid data
is known as ____.
|
|
|
50.
|
Excel ignores data validation if data is ____ the Office Clipboard.
a. | validated on | c. | copied to | b. | cut from | d. | pasted from |
|
|
|
51.
|
You can change the ____ for each element listed in the Table Element
list.
a. | formula | c. | validation | b. | function | d. | formatting |
|
|
|
52.
|
The form of the ROUND function is ____.
a. | =ROUND()+number of digits | c. | =ROUND (number,
10) | b. | =ROUND (10, number of digits) | d. | =ROUND (number, number of
digits) |
|
|
|
53.
|
To change from Enter mode or Edit mode to Point mode, start by ____.
a. | clicking Mode + = | c. | pressing ALT + EQUAL SIGN (=) | b. | pointing to the
Normal mode | d. | typing the
EQUAL SIGN (=) |
|
|
|
54.
|
Saving a template is just like saving a workbook, except that the file type ____
is selected in the Save as type box in the Save As dialog box.
a. | Template | c. | XPS | b. | PDF | d. | Chart |
|
|
|
55.
|
A function that sums all the values in all the cells in column A is ____.
a. | =sum(a:*) | c. | =sum(A:*) | b. | =sum(A) | d. | =sum(a:a) |
|
|
|
56.
|
A(n) ____ always appears in the same position in a cell (regardless of the
number of significant digits).
a. | formula | c. | function | b. | fixed dollar sign | d. | consolidated
reference |
|
|
|
57.
|
A format code is a series of ____ that defines how a cell entry assigned a
format will appear.
a. | numbers | c. | format symbols | b. | function symbols | d. | references |
|
|
|
58.
|
A section in a format code can be ____.
a. | functions | c. | zeros | b. | formulas | d. | colors |
|
|
|
59.
|
A style is a group of format specifications that ____.
a. | are separate for a range | c. | are assigned to a group
name | b. | are assigned to a style name | d. | must be assigned to multiple
cells |
|
|
|
60.
|
If two different styles are assigned to a range of cells, Excel ____.
a. | adds the second style to the first | c. | ignores the second
style | b. | replaces the first style | d. | ignores both styles |
|
|
|
61.
|
The Normal format style is ____.
a. | used for printing a workbook | c. | used for saving a
workbook | b. | initially assigned to all cells in a workbook | d. | none of the
above |
|
|
|
62.
|
A ____ ensures that users cannot unprotect the worksheet simply by clicking the
Unprotect button.
a. | Protect button | c. | certificate | b. | macro | d. | password |
|
|
|
63.
|
Protecting the structure of a workbook means that users cannot ____
sheets.
a. | add | c. | unhide | b. | move | d. | all of the
above |
|
|
|
64.
|
To undo several actions at once, click the Undo button arrow and then
____.
a. | select an action from the list | c. | click the Delete
button | b. | click the Undo button for each action | d. | all of the
above |
|
|
|
65.
|
When you first create the macro, you must ____.
a. | click the Start button | c. | record it | b. | save it | d. | name it |
|
|
|
66.
|
If you ____, you should reset the Quick Access Toolbar before you quit
Excel.
a. | create macros for others | c. | assign a digital
signature | b. | share a computer with others | d. | add a password |
|
|
|
67.
|
Some earlier versions of Excel use a language called ____, rather than VBA, for
their macros.
|
|
|
68.
|
If Excel is in Run mode and you click any control button in the Controls
Gallery, Excel immediately switches to ____ mode.
a. | Stop | c. | Design | b. | Start | d. | Macro |
|
|
|
69.
|
A Command Button control has ____ different properties.
|
|
|
70.
|
The Properties window includes two property sheets: Alphabetic and ____.
a. | Categorized | c. | Symbolic | b. | Numeric | d. | none of the
above |
|
|
|
71.
|
Comments can be placed in between lines of code or at the end of a line of code
as long as the comment begins with a(n) ____.
a. | semi-colon (;) | c. | comma (,) | b. | apostrophe (') | d. | exclamation mark
(!) |
|
|
|
72.
|
____ is a what-if analysis tool that allows you to record and save different
sets of what-if assumptions used to forecast the outcome of a worksheet model.
a. | Validator | c. | Solver | b. | Analyzer | d. | Scenario
Manager |
|
|
|
73.
|
Formula auditing is useful both for analyzing a complex worksheet and for
finding the source of ____ that can occur in your worksheet.
a. | formulas | c. | data | b. | functions | d. | errors |
|
|
|
74.
|
Visual auditing tools that display cues to help you understand the worksheet are
in the form of ____ and circles around worksheet.
a. | highlighted cells | c. | tracer arrows | b. | cell borders | d. | none of the
above |
|
|
|
75.
|
Tracer arrows appear in ____ when one of the referenced cells contains an
error.
|
|
|
76.
|
A ____ is a cell that is referenced in a formula.
a. | solver | c. | precedent | b. | dependent | d. | none of the
above |
|
|
|
77.
|
A ____ is useful for finding where a cell is used to perform calculations in a
worksheet.
a. | tracer | c. | dependent | b. | precedent Range | d. | solver |
|
|
|
78.
|
If a cell has precedents or dependents on other worksheets or in other
workbooks, Excel ____ to an icon of a worksheet to indicate that the precedent or dependent cell is
outside of the current worksheet.
a. | flashes a pointer | c. | highlights a line | b. | draws a dashed arrow | d. | none of the
above |
|
|
|
79.
|
When no more levels of precedents are available on the worksheet, Excel ____ if
you try to trace another level.
a. | beeps | c. | opens a worksheet | b. | displays an error message | d. | all of the
above |
|
|
|
80.
|
The ____ allows you to monitor values and formulas in cells as you work on a
worksheet.
a. | Error Checking window | c. | Show Formula command | b. | Validation Circle | d. | Watch Window |
|
|
|
81.
|
____ display in red to indicate that these cells contain error values.
a. | Cell borders | c. | Watch Windows | b. | Error messages | d. | Validation
circles |
|
|
|
82.
|
Copying a formula causes Excel to adjust the cell ____ so the new formulas
contain references corresponding to the new locations.
a. | range | c. | format | b. | dimension | d. | references |
|
|
|
83.
|
____ allows multiple people to work independently on the same workbook at the
same time, if they are in a networked environment.
a. | Revising | c. | Modifying | b. | Changing | d. | Sharing |
|
|
|
84.
|
Until a workbook is ____, Excel provides no indication that another user has
changed the shared workbook.
a. | saved | c. | replicated | b. | copied | d. | deleted |
|
|
|
85.
|
Multiple users reviewing the workbook often use ____ to communicate suggestions,
tips, and other messages.
a. | revisions | c. | elements | b. | tags | d. | comments |
|
|
|
86.
|
If either ____ or sharing is enabled, Excel enables the other by default.
a. | saving | c. | changing | b. | tracking | d. | none of the
above |
|
|
|
87.
|
Excel keeps a ____ with each shared workbook.
a. | table | c. | change history | b. | range | d. | learning
history |
|
|
|
88.
|
After a workbook has been reviewed by others, it usually is returned to the
owner, who can then review those changes and ____.
a. | change the history | c. | decide whether or not to accept them | b. | revise the comments
of others | d. | all of the
above |
|
|
|
89.
|
When you save a shared workbook, Excel may notify you that ____.
a. | multiple users had no revisions | c. | an error exists in one of the
formulas | b. | your changes might conflict with changes made by another user | d. | all of the
above |
|
|
|
90.
|
When workbook sharing is enabled, Excel denies access to creating ____.
a. | PivotTables | c. | new workbooks | b. | new worksheets | d. | text files |
|
|
|
91.
|
A(n) ____ workbook is one that is not shared and can be opened only by a single
user.
a. | inclusive | c. | protected | b. | exclusive | d. | single |
|
|
|
92.
|
The saved Web page is a snapshot of the workbook. It is similar to a printed
report in that you can ____ it, but you cannot ____ it.
a. | print, view | c. | modify, view | b. | modify, print | d. | view, modify |
|
|
|
93.
|
Excel allows you to publish workbooks, which is the process of ____.
a. | printing workbooks for others | c. | selling workbooks of
others | b. | making workbooks available to others | d. | modifying workbooks of
others |
|
|
|
94.
|
You can publish Web pages by saving them on a(n) ____, if you have access to
it.
a. | Web server | c. | local drive | b. | USB drive | d. | software page |
|
|
|
95.
|
You can add ____ to the Quick Access Toolbar.
a. | HTML | c. | Web pages | b. | commands | d. | data |
|
|
|
96.
|
Excel allows you to remove commands from the Quick Access Toolbar ____.
a. | if you share a computer with someone | c. | by clicking the Reset button on the
Excel Options dialog box | b. | if the toolbar becomes
cluttered | d. | all of the
above |
|
|
|
97.
|
You can add ____ to an Excel workbook before you save it as a Web page.
a. | hyperlinks | c. | toolbars | b. | browsers | d. | spell checkers |
|
|
|
Figure 1
|
|
|
98.
|
In the accompanying figure, what will the file extension be for the saved Web
page?
a. | .mhtl | c. | .htm | b. | .xtml | d. | .mht |
|
|
|
99.
|
In the accompanying figure, how many files will be saved?
a. | 1 folder | c. | 1 file | b. | 1 files for each worksheet | d. | 1 file plus folder
components |
|
|
|
100.
|
After you open the Customize Quick Access Toolbar and click the More Commands
command, Excel allows you to ____.
a. | add a command to the Quick Access Toolbar | c. | remove the browser from active
status | b. | customize the worksheet for the browser | d. | add the browser to active
status |
|