Multiple Choice Identify the
choice that best completes the statement or answers the question.
|
|
1.
|
You can ensure correctness in your formulas by carefully checking them using
_____.
a. | Range Finder | c. | the requirements document | b. | the
Ribbon | d. | Backstage
view |
|
|
2.
|
When you first enter text, its angle is _____ degrees, and it reads from left to
right in a cell.
|
|
3.
|
Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by
dragging the fill handle?
a. | Quarter 1 | c. | Qtr2 | b. | Qtr1 | d. | Quarter4 |
|
|
4.
|
Which of the following patterns extends the fill series to 575, 550, 525?
a. | 650, 600 | c. | 560, 580 | b. | 625, 600 | d. | 500, 475 |
|
|
5.
|
Which of the following is an extension of the fill pattern Sunday,
Tuesday?
a. | Wednesday, Thursday, Saturday | c. | Saturday, Sunday,
Monday | b. | Thursday, Saturday, Monday | d. | Monday, Wednesday, Friday |
|
|
6.
|
Which of the following is the path to the Increase or Decrease Indent
button?
a. | (Home tab | Clipboard group) | c. | (Home tab | Alignment
group) | b. | (Home tab | Editing group) | d. | (Home tab | Number group) |
|
|
7.
|
The Increase Indent button indents the contents of a cell to the right by ____
spaces each time you click it.
|
|
8.
|
The Copy button copies the contents and format of the source area to the Office
____, a reserved place in the computer’s memory.
a. | Ribbon | c. | Folder | b. | Clipboard | d. | File |
|
|
9.
|
Using the mouse to move or copy cells is called _____.
a. | drop and drag | c. | drag and copy | b. | drag and drop | d. | drag and paste |
|
|
10.
|
Which of the following is the path to the Insert button?
a. | (Home tab | Editing group) | c. | (Home tab | Cells
group) | b. | (Home tab | Number group) | d. | (Home tab | Inserting group) |
|
|
11.
|
When assigned to a cell, the _____ function returns a number that corresponds to
the actual current system date and time.
a. | SYSDATE | c. | DATETIME | b. | NOW | d. | CURRENT |
|
|
12.
|
Which of the following formulas contains an absolute cell reference?
|
|
13.
|
The _____ function is useful when you want to assign a value to a cell based on
a logical test.
|
|
14.
|
Which comparison operator means “not equal to”?
|
|
15.
|
_____ refers to cells not wide enough to display the entire entry.
a. | ##### | c. | $$$$$ | b. | &&&&& | d. | +++++ |
|
|
16.
|
A(n) _____ chart provides a simple way to show trends and variations in a range
of data within a single cell.
a. | Sparkie | c. | Special | b. | Sparkline | d. | Sparkle |
|
|
17.
|
You should use a _____ chart to show the relationship or proportion of parts to
a whole.
|
|
18.
|
A(n) _____ is a separate sheet in a workbook that contains only a chart.
a. | worksheet | c. | chart sheet | b. | dialog box | d. | range |
|
|
19.
|
A Pie chart with one of more slices offset is called a(n) _____.
a. | maximized Pie chart | c. | imploded Pie chart | b. | exploded Pie chart | d. | moving Pie
chart |
|
|
20.
|
Which of the following is the path to the Zoom button?
a. | (View tab | Zoom group) | c. | (Insert tab | Zoom
group) | b. | (Home tab | Zoom group) | d. | (Zoom tab | View group) |
|