48)
Bold type, fill color, and font color are examples of ________ that can be applied to the
contents of a cell.
48)
Answer:
formats
Explanation:
49)
Match the following terms to their meanings:
I. Drag and drop A. locate values and substitute them with another value
II. Find and Replace B. move cell contents by dragging them with the mouse
III. Navigate C. allows for designation of rows and columns to be
printed on each page
IV. Scale to Fit D. move from worksheet to worksheet
V. Print Titles E. stretch or shrink so printed output will fit on a maximum
number of pages
49)
Answer:
B, A, D, E, C
Explanation:
50)
Functions that test for specific conditions are called ________ functions.
50)
Answer:
logical
Explanation:
51)
An Excel ________ is a series of rows and columns that contains related data that is
managed independently from the other data in the worksheet.
51)
Answer:
table
Explanation:
52)
The default name of the first worksheet in an Excel workbook is ________.
52)
Answer:
Sheet1
Explanation:
53)
Excel’s ________ function finds the middle value from a range of values.
53)
Answer:
MEDIAN
Explanation:
54)
Worksheets that have been ________ together can be formatted at the same time.
54)
Answer:
grouped
Explanation:
55)
Match the following terms to their meanings:
I. SUM A. finds the smallest value in a list
II. AVERAGE B. adds the items in a list
III. MEDIAN C. finds the largest value in a list
IV MIN D. finds the middle value in a list
V. MAX E. adds the items in a list then divides by the number of items
in the list
55)
Answer:
B, E, D, A, C
Explanation:
9
56)
To ________ from one worksheet to another you click the sheet tab of the desired
worksheet.
56)
Answer:
navigate
Explanation:
57)
The ________ function counts the number of cells in a range that meet a certain criteria.
57)
Answer:
COUNTIF
Explanation:
58)
The ________ function finds the largest value within a chosen range of values.
58)
Answer:
MAX
Explanation:
59)
Match the following terms to their meanings:
I. Criteria A. value a function uses in calculations
II. Comparison operator B. condition tested by logical functions
III. Conditional format C. used to compare values
IV. Argument D. value or expression that can be evaluated as true
or false
V. Logical test E. changes the appearance of a cell based on a condition
59)
Answer:
B, C, E, A, D
Explanation:
60)
The ________ feature searches cells, replacing each match it finds with a provided
replacement value.
60)
Answer:
Find and Replace
Explanation:
61)
A(n) ________ function is updated each time the workbook is opened.
61)
Answer:
volatile
Explanation:
62)
Excel’s ________ function adds together all of the values found in a specified range.
62)
Answer:
SUM
Explanation:
63)
< >, =, <, <=, >, and >= are Excel’s ________.
63)
Answer:
comparison operators
Explanation:
64)
After a worksheet has been displayed in Page Layout view, page breaks are indicated by
________ in Normal view.
64)
Answer:
dotted lines
Explanation:
10
65)
Match the following terms to their meanings:
I. Data bar A. value a function uses for calculations
II. Argument B. a portion of a worksheet bounded by vertical and horizontal
bars
III. Pane C. used to identify each worksheet in a workbook
IV. Excel table D. shows the value of a cell relative to other cells
V. Sheet tab E. series of data that can be managed independently from
other data
65)
Answer:
D, A, B, E, C
Explanation:
66)
A value or expression that can be evaluated as true or false is called a(n) ________.
66)
Answer:
logical test
Explanation:
67)
To ________ a table means to arrange the data in a specific order.
67)
Answer:
sort
Explanation:
68)
Excel’s ________ feature allows the user to move data from place to place by clicking on the
data and holding down the left mouse button as the mouse is moved.
68)
Answer:
drag and drop
Explanation:
69)
The sheets that supply the data that a summary sheet totals and displays are called
________.
69)
Answer:
detail sheets
Explanation:
70)
To ________ a table causes only the portion of the table that matches a specific value to
display.
70)
Answer:
filter
Explanation:
71)
A(n) ________ provides a visual cue about the value of a cell relative to other cells.
71)
Answer:
data bar
Explanation:
72)
The ________ function determines the smallest value within a chosen range of values.
72)
Answer:
MIN
Explanation:
73)
Using Excel’s ________ allows the user to lock rows and columns into place.
73)
Answer:
Freeze Panes
Explanation:
74)
Logical functions typically use conditional tests to determine if specified conditions called
________ are true or false.
74)
Answer:
criteria
Explanation:
11
75)
A value or formula stored in a cell is called the cell’s ________.
75)
Answer:
contents
Explanation:
76)
Match the following terms to their meanings:
I. Sort A. move among worksheets
II. Filter B. a predefined formula
III. Navigate C. arrange data in a specific order
IV. Function D. a value that is updated each time the workbook is opened
V. Volatile E. display data that matches a specific value
76)
Answer:
C, E, A, B, D
Explanation:
77)
Match the following terms to their meanings:
I. Summary sheet A. used to identify a worksheet
II. Detail sheet B. a portion of a worksheet bounded by vertical and horizontal
bars
III. Sheet tab C. evaluated as either true or false
IV. Pane D. contains the details of the information to be analyzed
V. Logical test E. displays and summarizes totals from other worksheets
77)
Answer:
E, D, A, B, C
Explanation:
78)
Excel’s ________ command allows you to specify rows and columns that will appear on
each printed page.
78)
Answer:
Print Titles
Explanation:
79)
A formula that‘s built in to Excel is called a(n) ________.
79)
Answer:
function
Explanation:
80)
The ________ function adds a series of values and then divides by how many values there
are.
80)
Answer:
AVERAGE
Explanation:
81)
When a date is entered into Excel, it is assigned a(n) ________ value.
81)
Answer:
serial
Explanation:
82)
Match the following terms to their meanings:
I. Statistical functions A. SUM, AVERAGE, MEDIAN
II. Logical function B. a built–in formula
III. Function C. <., <=, >, >=, = , < >
IV. Arguments D. the values a function uses for calculations
V. Comparison operators E. IF
82)
Answer:
A, E, B, D, C
Explanation:
12
TRUE/FALSE. Write ‘T’ if the statement is true and ‘F’ if the statement is false.
83)
The IF function returns one value if a logical test is false and a different value if the logical test is
true.
Answer:
True
False
Explanation:
84)
Excel’s Print Titles command allows the user to specify rows and columns that will repeat on each
printed page.
Answer:
True
False
Explanation:
85)
Excel’s NOW function returns the date and time, which it retrieves from the computer’s clock and
calendar.
Answer:
True
False
Explanation:
86)
AVERAGE, SUM, and MEDIAN are examples of logical functions.
Answer:
True
False
Explanation:
87)
>, >=, and = are examples of conditional operators.
Answer:
True
False
Explanation:
88)
Entering the year portion of a date as 40 will be interpreted as the year 2040.
Answer:
True
False
Explanation:
89)
Worksheets must be formatted one at a time.
Answer:
True
False
Explanation:
90)
The data in an Excel table can only be sorted into ascending order.
Answer:
True
False
Explanation:
91)
The MEDIAN function finds the middle value from a group of values.
Answer:
True
False
Explanation:
92)
Excel provides only one technique for changing the name of a worksheet.
Answer:
True
False
Explanation:
93)
A value or expression that can be evaluated as true or false is called a logical test.
Answer:
True
False
Explanation:
13
94)
Logical functions are used to test for specific conditions.
Answer:
True
False
Explanation:
95)
The data in an Excel table is managed independently from the other data in the worksheet.
Answer:
True
False
Explanation:
96)
Each worksheet in a workbook must have the same headers and footers.
Answer:
True
False
Explanation:
97)
A summary sheet is used to provide a visual cue about the value of a cell in relationship to other
cells.
Answer:
True
False
Explanation:
98)
The Excel comparison operator for not equal to is < >.
Answer:
True
False
Explanation:
99)
Using conditional formatting allows the user to have a cell formatted in different ways depending
on the value stored in that cell.
Answer:
True
False
Explanation:
100)
The COUNTIF function takes three arguments.
100)
Answer:
True
False
Explanation:
101)
MIN and MAX are examples of statistical functions.
101)
Answer:
True
False
Explanation:
102)
The MEDIAN function adds a group of values and then divides the sum by the number of items in
the group.
102)
Answer:
True
False
Explanation:
103)
Data within a cell can be displayed rotated to draw attention to the data.
103)
Answer:
True
False
Explanation:
104)
The target destination for data that has been cut or copied using the Office Clipboard is called the
paste area.
104)
Answer:
True
False
Explanation:
14
105)
COUNTIF is an example of a logical function.
105)
Answer:
True
False
Explanation:
106)
Detail sheets display and summarize totals from other worksheets.
106)
Answer:
True
False
Explanation:
107)
Excel‘s Shrink to Fit command allows the user to stretch or shrink the width, height, or both of
printed output for the output to fit on a specific number of pages.
107)
Answer:
True
False
Explanation:
108)
Excel assigns a serial number to each date entered, which allows dates to be treated the same as
other numbers in the worksheet.
108)
Answer:
True
False
Explanation:
109)
A function is a predefined formula.
109)
Answer:
True
False
Explanation:
110)
Excel’s Paste Options gallery does not include Live Preview.
110)
Answer:
True
False
Explanation:
111)
Excel allows the user to delete the formatting of a cell without deleting the contents of the cell.
111)
Answer:
True
False
Explanation:
112)
The Excel user can move from one worksheet to another by clicking the data bar.
112)
Answer:
True
False
Explanation:
113)
In Excel, data can be moved from one area to another using the mouse and a technique called drag
and drop.
113)
Answer:
True
False
Explanation:
114)
IF is an example of a statistical function.
114)
Answer:
True
False
Explanation:
15