Multiple Choice
In the VLOOKUP function below,which of the following statements is NOT true?
=VLOOKUP(A6,Shifts,5,FALSE)
A) The content of A6 is compared to the contents of first column of the table array.
B) Shifts is the name assigned to the table array being used by the function.
C) The number in the third argument stands for how many columns exist in the table array.
D) The contents of the fourth argument requires an exact match with the first argument.
Correct Answer:

Verified
Correct Answer:
Verified
Q78: All of the following statements are TRUE
Q79: The _ function can change a text
Q80: A pair of _ is needed around
Q81: The _ function allows for multiple criteria
Q82: _ is code that uses the structure
Q84: The ability to use MATCH and INDEX
Q85: All of the following statements are TRUE
Q86: Which of the following is the correct
Q87: The following function is an example of
Q88: A(n)_ is the strategic advantage that a