47)
Match the following terms to their meanings:
I. Underlying formula A. data displayed in the cell
II. Displayed value B. formula displayed in the Formula Bar
III. Underlying value C. constant displayed in the Formula Bar
IV. Number format D. visually indicates which cells are used in a calculation
V. Range finder E. a specific way Excel displays numbers
47)
Answer:
B, A, C, E, D
Explanation:
48)
Excel’s ________ identify the worksheets in a workbook.
48)
Answer:
sheet tabs
Explanation:
49)
On a chart, a value that originates in a worksheet cell is known as a(n) ________.
49)
Answer:
data point
Explanation:
50)
A(n) ________ is a vertical group of cells in a worksheet.
50)
Answer:
column
Explanation:
51)
An Excel ________ is made up of one or more worksheets.
51)
Answer:
workbook
Explanation:
52)
A(n) ________ is a defined set of formatting characteristics such as font, font size, font
color, cell borders, and cell shading.
52)
Answer:
cell style
Explanation:
53)
The symbols used to perform basic mathematical operations are called ________ operators.
53)
Answer:
arithmetic
Explanation:
54)
A(n) ________ is a graphic representation of data in a worksheet.
54)
Answer:
chart
Explanation:
55)
On a chart, the ________ identifies the patterns or colors that are assigned to the categories
in the chart.
55)
Answer:
legend
Explanation:
9
56)
Match the following terms to their meanings:
I. $A. exponentiation operator
II. ^B. multiplication operator
III. / C. subtraction and negation operator
IV. * D. division operator
V. –E. absolute addressing
56)
Answer:
E, A, D, B, C
Explanation:
57)
The view and zoom buttons are located on the ________.
57)
Answer:
status bar
Explanation:
58)
Match the following terms to their meanings:
I. Cell address A. refers to a cell by its fixed position
II. Active cell B. cell that is ready to accept data
III. Range C. group of cells treated as a single unit
IV. Relative cell reference D. cell reference
V. Absolute cell reference E. when copied, it is adjusted according to its new
location
58)
Answer:
D, B, C, E ,A
Explanation:
59)
Tiny charts that are embedded in cells are called ________.
59)
Answer:
sparklines
Explanation:
60)
The ________ displays the name of the selected cell, table, chart, or object.
60)
Answer:
Name Box
Explanation:
61)
A(n) ________ is a horizontal group of cells in a worksheet.
61)
Answer:
row
Explanation:
62)
Contents of a cell can be displayed on multiple lines by using the ________ command.
62)
Answer:
Wrap Text
Explanation:
63)
Column charts, pie charts, and line charts are examples of common ________.
63)
Answer:
chart types
Explanation:
64)
Excel‘s formulas ________ whenever a value is changed that is referenced in the formula.
64)
Answer:
re–calculate
Explanation:
10
65)
The procedure known as ________ determines which digit at the right of the number will
be the last digit displayed and increases it by one if the next digit is 5 ,6, 7, 8, or 9.
65)
Answer:
rounding
Explanation:
66)
The ________ displays the value or formula located in the active cell.
66)
Answer:
Formula Bar
Explanation:
67)
Match the following terms to their meanings:
I. AutoComplete A. adjusts the width of a column to the widest content
within the column
II. Auto Fill B. button for accessing the SUM function
III. AutoFit C. a prewritten formula for adding values
IV. AutoSum D. fills in remaining letters if entry matches other content
within the column
V. SUM function E. generates and extends a series of values into adjacent cells
67)
Answer:
D, E, A, B, C
Explanation:
68)
On a chart, each data point is represented by a(n) ________.
68)
Answer:
data marker
Explanation:
69)
Excel’s ________ visually indicates which workbook cells are included in a formula
calculation.
69)
Answer:
range finder
Explanation:
70)
To prepare a workbook for printing, the user should use the ________ view.
70)
Answer:
Page Layout
Explanation:
71)
Match the following terms to their meanings:
I. Formula Bar A. displays the name of the selected object
II. Status bar B. displays the contents of the active cell
III. Name Box C. displays the current cell mode
IV. Sheet tabs D. a page from a workbook
V. Worksheet E. identify the worksheets in a workbook
71)
Answer:
B, C, A, E, D
Explanation:
72)
A(n) ________ uses one, two, or three letters to uniquely identify a column.
72)
Answer:
column heading
Explanation:
73)
The Excel feature known as ________ fills in remaining characters if a cell in the column
matches what you have already typed.
73)
Answer:
AutoComplete
Explanation:
11
74)
A text value, or ________, usually provides information about the number values found in
other cells within the worksheet.
74)
Answer:
label
Explanation:
75)
A(n) ________ is a selection of cells that Excel treats as a single unit.
75)
Answer:
range
Explanation:
76)
On a chart, related data points form a(n) ________.
76)
Answer:
data series
Explanation:
77)
The ________ allows the user to fill adjacent cells with values based on the contents of the
first cell.
77)
Answer:
fill handle
Explanation:
78)
A(n) ________ is formed when a row and a column intersect.
78)
Answer:
cell
Explanation:
79)
Match the following terms to their meanings:
I. Column heading A. anything typed into a cell
II. Row heading B. one, two, or three letters
III. Cell content C. a unique number
IV. Value D. a constant
V. Formula E. an equation that performs a calculation
79)
Answer:
B, C, A, D, E
Explanation:
80)
Match the following terms to their meanings:
I. x–axis A. identify the category of data
II. y–axis B. column charts, pie charts, line charts
III. Category labels C. category axis
IV. Chart types D. a combination of chart elements
V. Chart layout E. value axis
80)
Answer:
C, E, A, B, D
Explanation:
TRUE/FALSE. Write ‘T’ if the statement is true and ‘F’ if the statement is false.
81)
Excel’s Formula Bar displays the underlying value of the active cell.
Answer:
True
False
Explanation:
82)
By default, text values entered into a cell are right justified.
Answer:
True
False
Explanation:
12
83)
The only kinds of values that can be entered into a cell are text values and number values.
Answer:
True
False
Explanation:
84)
Workbook–level buttons allow the user to minimize, close, or restore the displayed workbook to its
previous size.
Answer:
True
False
Explanation:
85)
The first step in entering data by range is to select the desired range.
Answer:
True
False
Explanation:
86)
A range can be made up two or more nonadjacent areas on a worksheet.
Answer:
True
False
Explanation:
87)
Scaling adjusts the width of a column to fit the widest cell contents found in the column.
Answer:
True
False
Explanation:
88)
A negative number that is displayed using the Accounting Number Format is shown with a
negative sign, such as –5 or –6.
Answer:
True
False
Explanation:
89)
All Excel formulas begin with the equal sign (=).
Answer:
True
False
Explanation:
90)
AutoComplete generates and extends a series of values based on the values of other cells.
Answer:
True
False
Explanation:
91)
When the user changes a value in a cell, Excel automatically recalculates.
Answer:
True
False
Explanation:
92)
Workbook–level buttons are found along the lower border of the Excel window and identify each
worksheet.
Answer:
True
False
Explanation:
93)
The cell of the worksheet that is ready to accept data is known as the active cell.
Answer:
True
False
Explanation:
13
94)
Text values usually are used to provide information about the numbers displayed in worksheet
cells.
Answer:
True
False
Explanation:
95)
Absolute cell references are indicated by the $ symbol.
Answer:
True
False
Explanation:
96)
The word pixel is short for picture element.
Answer:
True
False
Explanation:
97)
Using Comma Style causes a negative number to be displayed inside parentheses.
Answer:
True
False
Explanation:
98)
One way a user can enter a formula is to use the point and click method.
Answer:
True
False
Explanation:
99)
An Excel worksheet is made up of one or more workbooks.
Answer:
True
False
Explanation:
100)
In Excel, column headings are made up of a letter and a digit, such as A2.
100)
Answer:
True
False
Explanation:
101)
A relative cell reference refers to a cell by its fixed position within the worksheet and is not adjusted
when the formula is copied.
101)
Answer:
True
False
Explanation:
102)
The box where a row and a column intersect is called a cell.
102)
Answer:
True
False
Explanation:
103)
Excel’s Name Box identifies the worksheets in a workbook.
103)
Answer:
True
False
Explanation:
104)
A group of cells that Excel treats as a single unit is called a range.
104)
Answer:
True
False
Explanation:
105)
Excel does not provide a spelling checker.
105)
Answer:
True
False
Explanation:
14
106)
Number values are often called labels.
106)
Answer:
True
False
Explanation:
107)
Data that is displayed in a cell is called the underlying value.
107)
Answer:
True
False
Explanation:
108)
When you add or delete rows or columns in a worksheet, Excel automatically adjusts all of the
formulas.
108)
Answer:
True
False
Explanation:
109)
In Excel, numbers are used as column headings.
109)
Answer:
True
False
Explanation:
110)
Each data point is represented in a chart by a legend.
110)
Answer:
True
False
Explanation:
111)
You must delete the current value in a cell before you can begin entering a new value.
111)
Answer:
True
False
Explanation:
112)
Cell contents are either values or formulas.
112)
Answer:
True
False
Explanation:
113)
You can format multiple rows or columns simultaneously.
113)
Answer:
True
False
Explanation:
114)
The terms worksheet and spreadsheet are interchangeable.
114)
Answer:
True
False
Explanation:
115)
A chart layout may include a number of chart elements such as title, legend, and labels for the
columns.
115)
Answer:
True
False
Explanation:
116)
The result of a function is displayed in a cell, and the underlying formula is displayed in the
Formula Bar.
116)
Answer:
True
False
Explanation:
15
117)
When printing a worksheet, the orientation can be changed either on the Page Layout tab or in
Print Preview.
117)
Answer:
True
False
Explanation:
118)
Arithmetic operators are used to perform basic mathematical operations in Excel.
118)
Answer:
True
False
Explanation:
119)
A menu that is context sensitive displays options related to the current task.
119)
Answer:
True
False
Explanation:
120)
Scaling allows the user to indicate the maximum number of pages to be used when printing a
worksheet.
120)
Answer:
True
False
Explanation:
16