Exam
Name___________________________________
MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question.
1)
In an Excel chart, a ________ is made up of related data points.
1)
A)
data marker
B)
pie slice
C)
column
D)
data series
Answer:
Explanation:
A)
B)
C)
D)
2)
For data to be more easily understood, it can be presented in a ________ instead of a table of
numbers.
2)
A)
data marker
B)
data point
C)
chart
D)
relative cell reference
Answer:
Explanation:
A)
B)
C)
D)
3)
The ________ allows the user to enter or edit the value or formula contained in the active cell.
3)
A)
Name Box
B)
status bar
C)
Formula Bar
D)
sheet tab
Answer:
Explanation:
A)
B)
C)
D)
4)
The ________ displays the name of the selected cell, table, chart, or object.
4)
A)
status bar
B)
Name Box
C)
active cell
D)
Formula Bar
Answer:
Explanation:
A)
B)
C)
D)
5)
The process of specifying the appearance of cells and the overall layout of a worksheet is called
5)
A)
expanding.
B)
labeling.
C)
AutoCompletion.
D)
formatting.
Answer:
Explanation:
A)
B)
C)
D)
1
6)
Excel’s ________ command creates one cell out of the selected cells and centers the contents within
the new cell.
6)
A)
Merge & Center
B)
AutoFit
C)
AutoComplete
D)
Join & Center
Answer:
Explanation:
A)
B)
C)
D)
7)
Two or more cells that Excel treats as a single unit is called a
7)
A)
worksheet.
B)
workbook.
C)
range.
D)
series.
Answer:
Explanation:
A)
B)
C)
D)
8)
A text value is also known as a
8)
A)
formula.
B)
label.
C)
row heading.
D)
number value.
Answer:
Explanation:
A)
B)
C)
D)
9)
Values that originate in a worksheet that are to be charted are called
9)
A)
data markers.
B)
labels.
C)
legends.
D)
data points.
Answer:
Explanation:
A)
B)
C)
D)
10)
Absolute cell references are indicated by using what symbol in the cell address?
10)
A)
$
B)
^
C)
&
D)
*
Answer:
Explanation:
A)
B)
C)
D)
11)
The Formula Bar displays the data known as the
11)
A)
underlying value.
B)
calculated value.
C)
displayed value.
D)
cell address.
Answer:
Explanation:
A)
B)
C)
D)
2
12)
Which is the Excel operator for division?
12)
A)
/
B)
$
C)
&
D)
*
Answer:
Explanation:
A)
B)
C)
D)
13)
The ________ inserts a thousand comma separator when appropriate, inserts a fixed U.S. dollar
sign aligned at the left edge of the cell, applies two decimal places, and provides space for negative
numbers to be displayed inside of parentheses.
13)
A)
Comma Style
B)
general format
C)
Accounting Number Format
D)
number format
Answer:
Explanation:
A)
B)
C)
D)
14)
The ________ feature fills in the remaining characters of a word if what is typed matches an
existing entry in the column.
14)
A)
AutoComplete
B)
Auto Fill
C)
AutoSum
D)
AutoFit
Answer:
Explanation:
A)
B)
C)
D)
15)
Labels that display along the bottom of a chart to identify the category of the data are called
15)
A)
category labels.
B)
picture elements.
C)
legends.
D)
data labels.
Answer:
Explanation:
A)
B)
C)
D)
16)
A ________ is created when a row and a column intersect.
16)
A)
data point
B)
data marker
C)
label
D)
cell
Answer:
Explanation:
A)
B)
C)
D)
3
17)
A prewritten formula known as a(n) ________ looks at one or more values, performs an operation,
and returns a value.
17)
A)
function
B)
label
C)
data point
D)
operator
Answer:
Explanation:
A)
B)
C)
D)
18)
A group of items that come one after another in succession is called
18)
A)
tabs.
B)
a data marker.
C)
a legend.
D)
a series.
Answer:
Explanation:
A)
B)
C)
D)
19)
A ________ is formatted as a pattern of uniformly spaced horizontal rows and vertical columns.
19)
A)
spreadsheet
B)
chart
C)
cell
D)
data marker
Answer:
Explanation:
A)
B)
C)
D)
20)
Which is the Excel operator for multiplication?
20)
A)
^
B)
*
C)
~
D)
$
Answer:
Explanation:
A)
B)
C)
D)
21)
An Excel document is called a
21)
A)
workbook.
B)
database.
C)
chart.
D)
presentation.
Answer:
Explanation:
A)
B)
C)
D)
22)
The result of a formula is displayed in the active cell, and the ________ is displayed in the Formula
Bar.
22)
A)
underlying value
B)
underlying formula
C)
displayed value
D)
cell address
Answer:
Explanation:
A)
B)
C)
D)
4
23)
All Excel formulas begin with which symbol?
23)
A)
*
B)
%
C)
=
D)
?
Answer:
Explanation:
A)
B)
C)
D)
24)
The ________ allow(s) the worksheet to be split into two vertical views of the same worksheet.
24)
A)
sheet tabs
B)
workbook–level buttons
C)
expand horizontal scroll bar button
D)
vertical window split box
Answer:
Explanation:
A)
B)
C)
D)
25)
The data that the user sees in a cell is called the
25)
A)
cell address.
B)
underlying formula.
C)
underlying value.
D)
displayed value.
Answer:
Explanation:
A)
B)
C)
D)
26)
On an Excel chart, the ________ identifies the patterns or colors that are assigned to all the
categories in the chart.
26)
A)
data marker
B)
label
C)
legend
D)
data point
Answer:
Explanation:
A)
B)
C)
D)
27)
________ generates and extends a series of values into adjacent cells based on the values of other
cells.
27)
A)
AutoFit
B)
Auto Fill
C)
AutoSum
D)
AutoComplete
Answer:
Explanation:
A)
B)
C)
D)
28)
Anything a user types into a cell is known as
28)
A)
a formula.
B)
a label.
C)
a number.
D)
cell content.
Answer:
Explanation:
A)
B)
C)
D)
5
29)
A data marker, such as a column, dot, or pie slice on a chart, represents a single
29)
A)
column.
B)
data point.
C)
series.
D)
row.
Answer:
Explanation:
A)
B)
C)
D)
30)
Excel uses ________ to perform basic mathematical operations.
30)
A)
arithmetic operators
B)
charts
C)
data markers
D)
data points
Answer:
Explanation:
A)
B)
C)
D)
31)
The current cell mode, the page number, and the view and zoom buttons are displayed on the
31)
A)
Formula Bar.
B)
Name Box.
C)
range finder.
D)
status bar.
Answer:
Explanation:
A)
B)
C)
D)
32)
The individual pages of an Excel document are called
32)
A)
charts.
B)
workbooks.
C)
worksheets.
D)
cells.
Answer:
Explanation:
A)
B)
C)
D)
33)
________ are defined as sets of formatting characteristics, such as font, font size, font color, cell
borders, and cell shading.
33)
A)
Cell addresses
B)
Cell styles
C)
Cell references
D)
Cell contents
Answer:
Explanation:
A)
B)
C)
D)
34)
To widen a column to fit the cell content of the widest cell in the column, the user should utilize
34)
A)
Auto Fill.
B)
AutoFit.
C)
AutoComplete.
D)
AutoSum.
Answer:
Explanation:
A)
B)
C)
D)
6
35)
The ________ is outlined in black and is ready to accept data.
35)
A)
active cell
B)
data point
C)
fill handle
D)
status bar
Answer:
Explanation:
A)
B)
C)
D)
36)
Tiny charts embedded in cells that show a visual trend alongside the data are called
36)
A)
legends.
B)
operators.
C)
labels.
D)
sparklines.
Answer:
Explanation:
A)
B)
C)
D)
37)
In ________, Excel maximizes the number of cells visible on the screen.
37)
A)
Chart styles
B)
Normal view
C)
Page Layout view
D)
Backstage view
Answer:
Explanation:
A)
B)
C)
D)
38)
The small black square in the lower right corner of a selected cell is called the
38)
A)
value axis.
B)
range finder.
C)
fill handle.
D)
Insert Worksheet button.
Answer:
Explanation:
A)
B)
C)
D)
39)
Each worksheet is identified by the ________ found along the lower border of the Excel window.
39)
A)
row headings
B)
sheet tabs
C)
value axis
D)
labels
Answer:
Explanation:
A)
B)
C)
D)
40)
The ________ visually indicates which workbook cells are included in a formula calculation.
40)
A)
data point
B)
range finder
C)
data marker
D)
status bar
Answer:
Explanation:
A)
B)
C)
D)
7
41)
Which is the Excel operator for exponentiation?
41)
A)
&
B)
$
C)
*
D)
^
Answer:
Explanation:
A)
B)
C)
D)
SHORT ANSWER. Write the word or phrase that best completes each statement or answers the question.
42)
If text is too long to fit in the current cell and the cell to the right contains data, the text will
be ________ or cut off on the display.
42)
Answer:
truncated
Explanation:
43)
Match the following terms to their meanings:
I. Data A. related data points
II. Data point B. a column, pie slice, bar, or other symbol
III. Data marker C. identifies patterns or colors assigned to categories in
a chart
IV. Data series D. text or numbers entered into a cell
V. Legend E. value that originates in a worksheet cell
43)
Answer:
D, E, B, A, C
Explanation:
44)
A(n) ________ is a built–in equation that performs mathematical calculations on the values
in a worksheet.
44)
Answer:
function
Explanation:
45)
Match the following terms to their meanings:
I. Workbook A. spreadsheet
II. Worksheet B. vertical group of cells
III. Cell C. Excel document that stores data
IV. Row D. intersection of a row and a column
V. Column E. horizontal group of cells
45)
Answer:
C, A, D, E, B
Explanation:
46)
Match the following terms to their meanings:
I. Cell style A. graphic representation of data
II. Chart B. tiny charts embedded in cells
III. Sparklines C. overall visual look of the chart in terms of colors and
graphic effects
IV. Value axis D. numerical scale on which charted data is based
V. Chart styles E. defined set of formatting characteristics
46)
Answer:
E, A, B, D, C
Explanation:
8