Multiple Choice
Match the following terms with their description:
i. Absolute cell references
II. Relative cell references
III. Mixed cell references
IV. Argument
v. Function
A) Part of it changes when you copy and paste a formula
B) Changes when you copy and paste a formula
C) Simplifies complex calculations
D) Does not change when you copy and paste a formula
E) Required input in a function
Correct Answer:
Verified
Correct Answer:
Verified
Q16: What does the AVERAGE function not ignore?<br>A)Text<br>B)Empty
Q27: If you wanted to reference a cell
Q35: What function computes the value in which
Q54: The _ function finds the largest value
Q68: All IF functions have three arguments.
Q69: If you wanted to count the number
Q77: You could use both A3>b9 or B9<A3
Q83: What does Excel use to indicate optional
Q86: The PMT function uses three required arguments
Q93: The TODAY()and NOW()functions are updated every time