Multiple Choice
Match each of the following functions to its descriptions:
i.SUM
II.MEDIAN
III.AVERAGE
IV.COUNTIF
v.COUNT
A) counts the number of cells in a range that meet the given condition
B) counts the number of cells in a range that contain numbers
C) adds a range of cells and divides by the number of values in the range
D) adds a range of cells
E) locates the middle value in a range of cells
Correct Answer:

Verified
Correct Answer:
Verified
Q66: Arguments are surrounded by brackets in a
Q67: The NOW function formats the result as
Q68: A filter icon displays next to column
Q69: A large + sign icon displays next
Q70: A(n)_ illustrates the value of a cell
Q72: The _ is the temporary storage location
Q73: The paste area is the target destination
Q74: By _ several sheets,you can view all
Q75: Match the following shortcut keys with the
Q76: SUM,AVERAGE,and MIN are formats.