Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
1.
|
The intersection of each row and column is called a(n) ____.
a. | place holder | c. | cell | b. | object | d. | box |
|
|
|
2.
|
____ tabs appear only when a particular type of object is selected and are
otherwise not available.
a. | Object based | c. | Need based | b. | Select-view | d. | Contextual |
|
|
|
|
|
|
3.
|
In the accompanying figure, item 1 points to a(n) ____.
a. | end-of-cell mark | c. | row | b. | end-of-row mark | d. | column |
|
|
|
4.
|
In the accompanying figure, item 2 points to a(n) ____.
a. | end-of-cell mark | c. | row | b. | end-of-row mark | d. | column |
|
|
|
5.
|
In the accompanying figure, item 3 points to the ____ tab.
a. | Table | c. | Table Tools Design | b. | Table Tools | d. | Table Design |
|
|
|
6.
|
In the accompanying figure, item 4 points to a(n) ____.
a. | end-of-cell mark | c. | row | b. | end-of-row mark | d. | column |
|
|
|
7.
|
In the accompanying figure, item 5 points to a(n) ____.
a. | end-of-cell mark | c. | row | b. | end-of-row mark | d. | column |
|
|
|
8.
|
You can use commands on the ____ Layout tab to add or delete columns and
rows.
a. | Tools | c. | Update Tables | b. | Table | d. | Table Tools |
|
|
|
9.
|
____ is a feature that lets you easily create professional-looking business
diagrams such as organizational charts, process diagrams, and time lines.
a. | SmartArt | c. | SmartOrg | b. | OrgArt | d. | SmartDiagram |
|
|
|
10.
|
When Word searches for clip art the search results appear as small pictures
called ____ in the task pane.
a. | icons | c. | thumbnails | b. | graphics | d. | clips |
|
|
|
11.
|
Once you select a clip and insert it in a document, you can enhance it by
applying ____ Styles to it.
a. | Clip | c. | Graphic | b. | Image | d. | Picture |
|
|
|
|
|
|
12.
|
In the accompanying figure, item 3 points to the Search for ____ box.
a. | text | c. | pattern | b. | image | d. | identification |
|
|
|
13.
|
In the accompanying figure, item 4 points to the ____ task pane.
a. | Picture | c. | Clip Insert | b. | Image | d. | Clip Art |
|
|
|
|
|
|
14.
|
In the accompanying figure, item 4 points to a(n) ____.
a. | footnote | c. | reference mark | b. | endnote | d. | reference
pointer |
|
|
|
15.
|
In the accompanying figure, item 5 points to a(n) ____.
a. | footnote | c. | reference mark | b. | endnote | d. | reference
pointer |
|
|
|
16.
|
Page breaks inserted by pressing [Ctrl] [Enter] are called
____ page breaks.
a. | hard | c. | easy | b. | soft | d. | fixed |
|
|
|
17.
|
You apply a theme using the Themes button in the Themes group of the ____
tab.
a. | Format | c. | Page Layout | b. | Themes | d. | Styles |
|
|
|
18.
|
The intersection of a row and column is called a(n) ____.
a. | block | c. | data point | b. | object | d. | cell |
|
|
|
19.
|
In a worksheet, the cell with the dark border around it is the ____ cell.
a. | active | c. | preferred | b. | editing | d. | updating |
|
|
|
20.
|
You can refer to a cell by its ____, a column letter followed by a row
number.
a. | cell id | c. | placement | b. | cell address | d. | grid id |
|
|
|
21.
|
The ____ bar, located just above the column headings, shows the contents of the
selected cell.
a. | formula | c. | name | b. | data | d. | address |
|
|
|
|
|
|
22.
|
In the accompanying figure, item 1 points to the ____.
a. | Name box | c. | Formula bar | b. | View button | d. | Quick Access
toolbar |
|
|
|
23.
|
In the accompanying figure, item 2 points to the ____.
a. | Name box | c. | Formula bar | b. | Status bar | d. | Quick Access
toolbar |
|
|
|
24.
|
In the accompanying figure, item 4 points to the ____.
a. | View buttons | c. | Active cell | b. | Ribbon | d. | Active sheet |
|
|
|
25.
|
In the accompanying figure, item 10 points to the ____.
a. | View buttons | c. | Formula bar | b. | Zoom controls | d. | Quick Access
toolbar |
|
|
|
|
|
|
26.
|
In the accompanying figure, item 1 points to the ____.
a. | Insert Worksheet button | c. | Formula Select
button | b. | Select All button | d. | Sheet tab |
|
|
|
27.
|
In the accompanying figure, item 2 points to the ____.
a. | active cell | c. | inactive cell | b. | selected cell range | d. | row headings |
|
|
|
28.
|
In the accompanying figure, item 6 points to the ____.
a. | Insert Worksheet button | c. | Formula Select
button | b. | Select All button | d. | Sheet tab |
|
|
|
29.
|
In Excel, pressing ____ has the same effect as pressing the right arrow
key.
a. | [Num Lock] | c. | [Tab] | b. | [Space] | d. | [Enter] |
|
|
|
30.
|
In a worksheet, the boxes on the left containing numbers are known as ____
headings.
a. | data | c. | row | b. | sheet | d. | column |
|
|
|
31.
|
References to cell addresses, such as A1 and E42 are known as ____.
a. | cell ids | c. | referent addresses | b. | cell references | d. | referent ids |
|
|
|
32.
|
All formulas must begin with a(n) ____.
a. | equal sign (=) | c. | minus sign (-) | b. | plus sign (+) | d. | forward slash |
|
|
|
|
|
|
33.
|
In the accompanying figure, item 1 points to the ____.
a. | Insert Worksheet button | c. | Enter button | b. | Formula
bar | d. | active
cell |
|
|
|
34.
|
To enhance a worksheet, you can add headers and ____ containing information that
you want to include at the top or bottom of each page.
a. | footers | c. | bottoms | b. | footnotes | d. | tails |
|
|
|
35.
|
_____ referencing is when you copy a formula to a new cell and Excel
automatically replaces the original cell references with cell references that are in the same
relative position as those in the original formula.
a. | Relative cell | c. | Formula | b. | Absolute cell | d. | Relational |
|
|
|
36.
|
What are the four parts to every function?
a. | an equal sign, the function name, a set of parentheses, and
variables | b. | an equal sign, the function name, a set of brackets, and
arguments | c. | an equal sign, the function name, a set of parentheses, and
arguments | d. | a plus sign, the function name, a set of parentheses, and
arguments |
|
|
|
|
|
|
37.
|
In the accompanying figure, item 1 points to a(n) ____.
a. | function in the formula bar | c. | returned value of the
formula | b. | function in the cell | d. | argument |
|
|
|
38.
|
You can use ____ functions to calculate loan payments, appreciation and
depreciation.
a. | Math and Trig | c. | Logical | b. | Lookup and Reference | d. | Financial |
|
|
|
39.
|
You can use ____ functions for finding values in lists or tables or finding cell
references.
a. | Math and Trig | c. | Logical | b. | Lookup and Reference | d. | Financial |
|
|
|
40.
|
You can use ____ functions for calculations that display a value if a condition
is met.
a. | Math and Trig | c. | Logical | b. | Lookup and reference | d. | Financial |
|
|
|
41.
|
A ____ is a number in a sequential series of numbers.
a. | sequential value | c. | serial object | b. | sequential number | d. | serial value |
|
|
|
|
|
|
42.
|
In the accompanying figure, item 1 points to the ____ button.
a. | Date and Time | c. | Date | b. | Today | d. | Date Formula |
|
|
|
43.
|
In the accompanying figure, item 2 points to a ____.
a. | formula bar | c. | list of functions | b. | function bar | d. | list of
formulas |
|
|
|
44.
|
Excel includes many ____ functions that let you assemble, classify, and tabulate
numeric data.
a. | statistical | c. | classification | b. | assembly | d. | tabulation |
|
|
|
45.
|
The most popular statistical functions are ____.
a. | SUM, MIN, and MAX | c. | AVERAGE, MIN, and SUM | b. | AVERAGE, SUM, and
MAX | d. | AVERAGE, MIN, and
MAX |
|
|
|
|
|
|
46.
|
In the accompanying figure, item 1 points to a ____.
a. | cell | c. | cell range | b. | formula | d. | function |
|
|
|
47.
|
In the accompanying figure, item 2 points to a ____.
a. | cell range | c. | filter | b. | function | d. | dialog box |
|
|
|
48.
|
____ is formatting that Excel automatically applies to cells when specified
criteria are met.
a. | Conditional formatting | c. | Criteria formatting | b. | Critical formatting | d. | Data formatting |
|
|
|
|
|
|
49.
|
In the accompanying figure, item 1 points to the ____ button.
a. | AutoColor | c. | AutoFormatting | b. | Conditional Editing | d. | Conditional
Formatting |
|
|
|
50.
|
In the accompanying figure, item 3 points to the ____ Color Scales
option.
a. | Green-Yellow-Red | c. | Green-Red-Orange | b. | Green-Yellow-Blue | d. | Yellow-Orange-Red |
|
|
|
51.
|
In the accompanying figure, item 2 points to the ____ option.
a. | demo preview of Color Scales | c. | demo view | b. | live preview of
Color Scales | d. | live
demo |
|
|
|
52.
|
If your Excel table contains a large amount of data, you might want to ____ it
to display only the data you need.
a. | sort | c. | filter | b. | update | d. | organize |
|
|
|
53.
|
When you tell Excel which rows in a table you want to see, you are specifying
the ____ for your filter.
a. | objects | c. | data | b. | items | d. | criteria |
|
|
|
54.
|
The ____ is the horizontal line at the base of the chart that shows
categories.
a. | title axis | c. | x-axis | b. | z-axis | d. | y-axis |
|
|
|
55.
|
The ____ is the vertical line that defines the left edge of the chart and
provides values.
a. | title axis | c. | x-axis | b. | z-axis | d. | y-axis |
|
|
|
56.
|
____ are vertical and horizontal lines in a chart that help to identify the
value for each data series.
a. | Data lines | c. | Gridlines | b. | Data markers | d. | Grid markers |
|
|
|
|
|
|
57.
|
In the accompanying figure, item 1 points to the ____.
a. | x-axis | c. | axis titles | b. | data range | d. | data series |
|
|
|
58.
|
In the accompanying figure, item 3 points to the ____.
a. | chart gridlines | c. | data marker | b. | chart title | d. | data series |
|
|
|
59.
|
In the accompanying figure, item 4 points to the ____.
a. | x-axis | c. | vertical axis title | b. | y-axis | d. | data series |
|
|
|
60.
|
In the accompanying figure, item 7 points to the ____.
a. | x-axis | c. | axis titles | b. | y-axis | d. | legend |
|
|
|
61.
|
In the accompanying figure, item 9 points to the ____.
a. | x-axis | c. | axis titles | b. | y-axis | d. | data series |
|
|
|
62.
|
In the accompanying figure, item 10 points to the ____.
a. | plot area | c. | axis titles | b. | y-axis | d. | data series |
|
|
|
63.
|
In the accompanying figure, item 8 points to the ____.
a. | chart gridlines | c. | data marker | b. | chart title | d. | data series |
|
|
|
|
|
|
64.
|
In the accompanying figure, item 4 points to the ____.
a. | ScreenTip | c. | Insert tab | b. | Line button | d. | Line subtype |
|
|
|
65.
|
To resize a chart object, drag one of its ____.
a. | sizing handles | c. | resize boxes | b. | dragging handles | d. | resize buttons |
|
|
|
|
|
|
66.
|
In the accompanying figure, item 1 points to the ____.
a. | data series | c. | Switch Row/Column button | b. | legend | d. | Chart Tools Design tab |
|
|
|
67.
|
In the accompanying figure, a ____ chart is depicted.
a. | pie | c. | bubble | b. | bar | d. | stack |
|
|
|
68.
|
You can choose from a variety of commands and galleries on the ____ Format tab
to make enhancements and adjustments to a selected chart object.
a. | Chart | c. | Chart Tools | b. | Tools | d. | Graph Tools |
|
|
|
69.
|
A ____ chart is an effective tool for comparing the relative values of parts to
a whole.
a. | Pie | c. | Bubble | b. | Column | d. | Circle |
|
|
|
70.
|
____ are tiny charts that fit in one cell and illustrate trends in selected
cells.
a. | Firelines | c. | Sparklines | b. | Fireboxes | d. | Sparkboxes |
|
|
|
71.
|
You should place sparklines close to the ____ containing the data they
illustrate.
a. | graph | c. | cells | b. | icon | d. | sparkboxes |
|
|
|
72.
|
There are ____ types of sparklines you can add to a worksheet.
a. | one | c. | two | b. | three | d. | you can’t add sparklines to a
worksheet |
|
|
|
73.
|
A ____ is a miniature line chart that is ideal for showing a trend over a period
of time.
a. | Line sparkline | c. | Win/loss sparkline | b. | Column sparkline | d. | Box sparkline |
|
|
|
74.
|
To change the color of sparklines click the ____ list arrow.
a. | Style colors | c. | Set color | b. | Theme colors | d. | Sparkline color |
|
|
|
75.
|
A(n) ____-dimensional chart has a horizontal and vertical axis.
|