Multiple Choice
Using a $ sign before a column label .
A) keeps the reference to both the row and column fixed
B) keeps the reference to the row fixed, but allows the column reference to change
C) keeps the reference to column fixed, but allows the row reference to change
D) allows both the row and column references to change
Correct Answer:

Verified
Correct Answer:
Verified
Q23: Which of the following Lookup functions returns
Q24: In a MATCH function, if match_type =
Q25: Use the data given below to
Q26: The Excel function of is used to
Q27: To find the number of orders with
Q29: In a MATCH function, if the match_type
Q30: Which of the following functions is a
Q31: Which of the following is a difference
Q32: Give the logical function for the following:
Q33: is a logical function that returns one