Exam
Name___________________________________
MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question.
1)
A predefined formula is called a
1)
A)
function.
B)
filter.
C)
data bar.
D)
criteria.
Answer:
Explanation:
A)
B)
C)
D)
2)
The values that an Excel function uses to perform operations are called
2)
A)
criteria.
B)
tests.
C)
panes.
D)
arguments.
Answer:
Explanation:
A)
B)
C)
D)
3)
To ________ a table means to arrange all of the data in a specific order.
3)
A)
sort
B)
scale
C)
filter
D)
freeze
Answer:
Explanation:
A)
B)
C)
D)
4)
You would ________ a table if you wanted to display only data that matched specific criteria.
4)
A)
filter
B)
sort
C)
scale
D)
freeze
Answer:
Explanation:
A)
B)
C)
D)
5)
Excel’s ________ function finds the largest value in a selected range of cells.
5)
A)
MAX
B)
MIN
C)
COUNTIF
D)
MEDIAN
Answer:
Explanation:
A)
B)
C)
D)
1
6)
Using ________ searches the spreadsheet for one value and replaces it with another.
6)
A)
Find and Replace
B)
drag and drop
C)
detail sheets
D)
Scale to Fit
Answer:
Explanation:
A)
B)
C)
D)
7)
The Excel operator for less than is
7)
A)
<=
B)
<
C)
>
D)
>=
Answer:
Explanation:
A)
B)
C)
D)
8)
If a column of data holds the letter grades for a class, the ________ function could be used to
determine how many students had a grade of “A”.
8)
A)
SUM
B)
MEDIAN
C)
COUNTIF
D)
IF
Answer:
Explanation:
A)
B)
C)
D)
9)
A function such as NOW that is updated each time a workbook is opened is said to be
9)
A)
conditional.
B)
frozen.
C)
filtered.
D)
volatile.
Answer:
Explanation:
A)
B)
C)
D)
10)
The functions AVERAGE and MEDIAN are examples of ________ functions, which are useful
when the user needs to analyze a group of measurements.
10)
A)
conditional
B)
logical
C)
statistical
D)
navigation
Answer:
Explanation:
A)
B)
C)
D)
11)
If a cell‘s width is too narrow to properly display the numeric contents of the cell, Excel displays a
series of ________ symbols.
11)
A)
^
B)
?
C)
#
D)
*
Answer:
Explanation:
A)
B)
C)
D)
2
12)
The ________ function adds all of the numbers in a range of cells.
12)
A)
MIN
B)
SUM
C)
MAX
D)
MEDIAN
Answer:
Explanation:
A)
B)
C)
D)
13)
The ________ function returns one value if a condition is met and a different value if it is not.
13)
A)
COUNTIF
B)
MEDIAN
C)
IF
D)
MAX
Answer:
Explanation:
A)
B)
C)
D)
14)
Which Excel function would be used to calculate the total points a student earned on a series of
tests?
14)
A)
SUM
B)
AVERAGE
C)
MEDIAN
D)
MAX
Answer:
Explanation:
A)
B)
C)
D)
15)
Values are compared using ________ operators.
15)
A)
comparison
B)
arithmetic
C)
conditional
D)
navigation
Answer:
Explanation:
A)
B)
C)
D)
16)
The Excel operator for greater than or equal to is
16)
A)
<=
B)
>=
C)
<
D)
>
Answer:
Explanation:
A)
B)
C)
D)
17)
An Excel ________ is a series of rows and columns that contains related data that is managed
independently from other data in the worksheet.
17)
A)
sheet
B)
pane
C)
tab
D)
table
Answer:
Explanation:
A)
B)
C)
D)
3
18)
Excel’s ________ function finds the middle value in a range.
18)
A)
COUNTIF
B)
MIN
C)
MEDIAN
D)
MAX
Answer:
Explanation:
A)
B)
C)
D)
19)
Which of the following is an example of a logical test?
19)
A)
=NOW( )
B)
=SUM(B5:D5)
C)
6*8
D)
D5 > 45
Answer:
Explanation:
A)
B)
C)
D)
20)
By including worksheets in a ________, you can enter or edit data on them simultaneously.
20)
A)
collection
B)
group
C)
theme
D)
chart
Answer:
Explanation:
A)
B)
C)
D)
21)
The Excel operator for not equal to is
21)
A)
<=
B)
>=
C)
<>
D)
!=
Answer:
Explanation:
A)
B)
C)
D)
22)
The ________ function counts the number of cells within a range that meet a certain criteria.
22)
A)
COUNTIF
B)
IF
C)
SUM
D)
MEDIAN
Answer:
Explanation:
A)
B)
C)
D)
23)
A ________ provides a visual cue about the value of a cell relative to other cells.
23)
A)
data bar
B)
pane
C)
criteria
D)
sheet tab
Answer:
Explanation:
A)
B)
C)
D)
4
24)
Using ________ allows the user to select one or more rows or columns and lock them into place.
24)
A)
drag and drop
B)
conditional formatting
C)
Freeze Panes
D)
Find and Replace
Answer:
Explanation:
A)
B)
C)
D)
25)
Dates can be treated as other numbers because Excel assigns a ________ value to the date as it is
entered.
25)
A)
logical
B)
serial
C)
comparison
D)
navigation
Answer:
Explanation:
A)
B)
C)
D)
26)
Excel’s ________ function adds all of its arguments then divides the sum by the number of
arguments.
26)
A)
SUM
B)
COUNTIF
C)
MEDIAN
D)
AVERAGE
Answer:
Explanation:
A)
B)
C)
D)
27)
A value or expression that can be evaluated as true or false is called a
27)
A)
data bar.
B)
logical test.
C)
conditional format.
D)
comparison operator.
Answer:
Explanation:
A)
B)
C)
D)
28)
The Excel function ________ would be used to find the lowest score on a series of student test
scores.
28)
A)
MINIMUM
B)
SUM
C)
MEDIAN
D)
MIN
Answer:
Explanation:
A)
B)
C)
D)
5
29)
Using ________ allows the user to stretch or shrink the width, height, or both of printed output.
29)
A)
Freeze Panes
B)
Scale to Fit
C)
data bar
D)
the paste area
Answer:
Explanation:
A)
B)
C)
D)
30)
MIN and MAX are examples of ________ functions.
30)
A)
statistical
B)
logical
C)
conditional
D)
navigation
Answer:
Explanation:
A)
B)
C)
D)
31)
A ________ displays and summarizes totals from other worksheets.
31)
A)
data bar
B)
detail sheet
C)
sheet tab
D)
summary sheet
Answer:
Explanation:
A)
B)
C)
D)
32)
You can move from one worksheet to another by clicking the
32)
A)
freeze panes.
B)
sheet tabs.
C)
data bar.
D)
paste area.
Answer:
Explanation:
A)
B)
C)
D)
33)
Changes made to the ________ affect the overall totals on the Summary worksheet.
33)
A)
detail sheets
B)
data bars
C)
sheet tabs
D)
paste area
Answer:
Explanation:
A)
B)
C)
D)
34)
IF is an example of a ________ function.
34)
A)
statistical
B)
summary
C)
navigation
D)
logical
Answer:
Explanation:
A)
B)
C)
D)
6
35)
Using ________ allows a cell to change appearance based on a criteria.
35)
A)
filtering
B)
conditional formatting
C)
summary sheets
D)
detail sheets
Answer:
Explanation:
A)
B)
C)
D)
36)
A range of cells can be converted into an Excel ________ so that the data can be analyzed.
36)
A)
table
B)
tab
C)
pane
D)
sheet
Answer:
Explanation:
A)
B)
C)
D)
37)
Which Excel function would be used to find the middle value of a list of test scores?
37)
A)
MAX
B)
COUNTIF
C)
MEDIAN
D)
AVERAGE
Answer:
Explanation:
A)
B)
C)
D)
38)
The action of placing cell contents that have been copied to the Office Clipboard is
38)
A)
formatting.
B)
pasting.
C)
relocating.
D)
editing.
Answer:
Explanation:
A)
B)
C)
D)
39)
Functions that test for a specific condition are called ________ functions.
39)
A)
summary
B)
logical
C)
statistical
D)
navigation
Answer:
Explanation:
A)
B)
C)
D)
40)
The COUNTIF function takes two arguments:
40)
A)
the range of cells to check and the sheet tab.
B)
the range of cells to check and the criteria.
C)
the range of cells to check and the filter.
D)
the range of cells to check and the pane.
Answer:
Explanation:
A)
B)
C)
D)
7
41)
When pasting a range of cells you only need to point to or select the ________ of the paste area.
41)
A)
lower left corner
B)
upper left corner
C)
center
D)
upper right corner
Answer:
Explanation:
A)
B)
C)
D)
42)
A ________ is a portion of a worksheet window bounded by and separated from other portions by
vertical or horizontal bars.
42)
A)
pane
B)
range
C)
table
D)
tab
Answer:
Explanation:
A)
B)
C)
D)
43)
Excel‘s ________ function retrieves the date and time from the computer‘s calendar and clock.
43)
A)
CALENDAR
B)
NOW
C)
TIME
D)
CLOCK
Answer:
Explanation:
A)
B)
C)
D)
SHORT ANSWER. Write the word or phrase that best completes each statement or answers the question.
44)
Match the following terms to their meanings:
I. COUNTIF A. adds all of the values in a range
II. IF B. finds the middle value of a range of values
III. MEDIAN C. determines how many cells in a range meet a criteria
IV. AVERAGE D. returns one value if a condition is true, a different one if the
condition is false
V. SUM E. adds all values in a range and then divides by the number of
items in the range
44)
Answer:
C, D, B, E, A
Explanation:
45)
A(n) ________ changes the appearance of a cell based on a criteria.
45)
Answer:
conditional format
Explanation:
46)
The target destination for data that has been cut or copied is called the ________.
46)
Answer:
paste area
Explanation:
47)
A(n) ________ is a worksheet where totals from other worksheets are summarized and
displayed.
47)
Answer:
summary sheet
Explanation:
8