Essay
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
Q19: What describes a function's purpose?<br>A)Arguments<br>B)Name<br>C)Category<br>D)Variables
Q30: The test in an IF function must
Q41: Match the following terms with their description:<br>I.
Q44: Match the example with the function or
Q46: Match the following terms with their description:<br>I.
Q65: The ROUND function requires how many arguments?<br>A)2<br>B)3<br>C)4<br>D)1
Q68: All IF functions have three arguments.
Q77: You could use both A3>b9 or B9<A3
Q78: A good practice when entering function names
Q92: What keyboard shortcut will automatically update any