Which of the following is the best choice to lookup values when VLOOKUP and HLOOKUP are not possible?
A) LOOKUP
B) DGET
C) MATCH and INDEX
D) SUM
Correct Answer:
Verified
Q27: Which of the following functions returns a
Q28: When using Advanced Filtering < > is
Q29: The first argument of the INDEX function
Q30: In the FV function,the rate argument refers
Q31: Which of the following functions has the
Q33: In the function =IF(E5<J7,F5*K7,IF(E5<=J8,F5*K8,F5*K9)),F5*K7 is the:
A)Value_if_true.
B)Value_if_false.
C)Logical_test.
D)Modifier.
Q34: Which of the following functions returns the
Q35: Which of the following is not a
Q36: When using Advanced Filtering,the criteria range must
Q37: When the DAVERAGE function returns #DIV/0:
A)there are
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents