Multiple Choice
An absolute cell reference:
A) causes a potential error.
B) indicates a cell's specific location and the reference does not change when you copy the formula.
C) happens only when a formula indirectly refers to the cell containing the formula.
D) contains both an absolute and a relative cell reference.
Correct Answer:
Verified
Correct Answer:
Verified
Q48: A(n)_ function occurs when one function is
Q49: The =_(serial_number)function displays the day within a
Q49: The logical test<br>A) is the lowest value
Q50: Match the descriptions with correct portions of
Q51: To simplify entering ranges in formulas you
Q52: The breakpoint<br>A) looks up a value and
Q53: Excel provides three basic count functions: COUNT,COUNTA,and
Q55: Which of the following is NOT one
Q57: The PMT function uses _ required arguments
Q72: _ references usually cause inaccurate results.