-In the accompanying figure,why is the term FALSE chosen in item 4?
A) Because you wish to find an opposite match for the value in cell M1.
B) Because you wish to find a false match for the value in cell M1.
C) Because you wish to find an exact match for the value in cell M1.
D) Because you wish to find an exact match in the table array.
Correct Answer:
Verified
Q22: When performing an advanced filter,you specify _
Q23: Q24: Q25: To use advanced filtering,you must define a(n)_ Q26: Q28: The VLOOKUP function searches vertically down the Q29: Q30: When you define the criteria range and Q31: When specifying criteria in the Custom AutoFilter Q32: 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