If the lookup_value is less than the smallest value in the lookup_vector, LOOKUP displays ____.
A) an error symbol
B) the LOOKUP wizard
C) the number 0
D) the number 100
Correct Answer:
Verified
Q72: As with the VLOOKUP and HLOOKUP functions
Q73: You can only use a LOOKUP function
Q74: If the values you want to look
Q75: In a(n) _ table, Excel can search
Q76: You can use VLOOKUP and HLOOKUP to
Q78: The LOOKUP function has the _ lookup
Q79: In an INDEX function, the argument _
Q80: In a(n) _ table, Excel searches one
Q81: When using the CHOOSE function, if the
Q82: Excel provides nine functions, called the _
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