Multiple Choice
A relative cell reference:
A) indicates a cell's specific location and the reference does not change when you copy the formula to another cell or range.
B) contains both an absolute and a relative cell reference.
C) indicates a cell's relative location from the cell containing the formula;the reference changes when you copy the formula.
D) occurs when a formula directly refers to the cell containing the formula.
Correct Answer:
Verified
Correct Answer:
Verified
Q41: A function in Excel must begin with
Q42: The _ is the lowest value in
Q43: The _ key toggles between relative,absolute,and mixed
Q44: What are the rules for creating range
Q45: The TODAY and the NOW functions display
Q48: A(n)_ function occurs when one function is
Q49: The logical test<br>A) is the lowest value
Q49: The =_(serial_number)function displays the day within a
Q50: Match the descriptions with correct portions of
Q51: To simplify entering ranges in formulas you