Multiple Choice
When you copy and paste a formula one cell below its current spreadsheet location,the cells referenced in the formula change to reflect its new location.This is an example of a(n) ____.
A) function
B) absolute reference
C) link
D) relative reference
Correct Answer:
Verified
Correct Answer:
Verified
Q25: When creating a VLOOKUP formula,the table range
Q36: A formula in cell Z10 references values
Q37: The _ tab contains an entire group
Q38: A function is a pre-made formula that
Q39: To access the PMT function,click the Formulas
Q40: The VLOOKUP function looks up values in
Q42: Given the formula =IF(X4="NO","CHARGE","FREE"),when the value of
Q43: You are reviewing the screen results after
Q44: Excel provides five different counting functions.
Q45: The result of the PMT function returns