Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
1.
|
The ___________ lets you access commands no matter which tab you are
on. a. | Access All Commands Button | c. | Quick Access
Toolbar | b. | Mini-Ribbon | d. | Shortcut Bar |
|
|
|
2.
|
To merge two or more cells together, use the
___________ command.
a. | Autosum | c. | Merge and Center | b. | Format as Table | d. | Wrap Text |
|
|
|
3.
|
Which number format
should you use if don't want Excel to alter the formatting? a. | Currency | c. | Text | b. | Scientific | d. | Time |
|
|
|
4.
|
Which command should you use if you want to save
your workbook with a different filename?
a. | Info | c. | Save As | b. | Options | d. | Save |
|
|
|
5.
|
When a formula contains the address of a cell, it
is called a(n) ___________.
a. | Addressbook | c. | Group | b. | Cell Reference | d. | Order of Operations
|
|
|
|
6.
|
Worksheets can be ___________.
a. | Named | c. | Grouped | b. | Color-Coded | d. | All of the Above
|
|
|
|
7.
|
If you're printing a workbook and want certain
rows and columns to appear on each page, you should use the ___________ command.
a. | Background | c. | Print Area | b. | Orientation | d. | Print Titles |
|
|
|
8.
|
A cell reference that does not change when copied
or filled is called a(n) ___________.
a. | Absolute Reference | c. | Immutable Reference | b. | Concrete Reference | d. | Relative Reference
|
|
|
|
9.
|
To select a common function such as SUM or AVG, you
can use the ___________ command.
a. | AutoSum | c. | PivotTable | b. | CommonFunction | d. | QuickSum |
|
|
|
10.
|
If you want to alphabetize your rows, you should
use the ___________ command.
a. | Alphabetize | c. | Merge & Center | b. | Filter | d. | Sort |
|
|
|
11.
|
To automatically group and summarize your data, you
can use the ___________ command.
a. | AutoGroup | c. | Merge & Center | b. | Conditional Formatting | d. | Subtotal |
|
|
|
12.
|
You can use ___________ to narrow down the data in
your worksheet or hide parts of it from view.
a. | Borders | c. | Filters | b. | Conditional Formatting | d. | Functions |
|
|
|
13.
|
Instead of creating a blank workbook, you can
create one that's based on a pre-defined pattern called a ___________.
a. | ClipArt | c. | Formula | b. | Conditional Formatting | d. | Template |
|