Multiple Choice

-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
Correct Answer:
Verified
Q10: When you generate subtotals,all levels of detail
Q11: The V in the VLOOKUP function stands
Q12: When using the Advanced Filter command,a criteria
Q13: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB7032/.jpg" alt=" -In the accompanying
Q14: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB7032/.jpg" alt=" -In the accompanying
Q16: When you specify a complicated set of
Q17: What happens if you insert invalid data
Q18: In a filtered table,the matching row numbers
Q19: Greater than and less than are logical
Q20: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB7032/.jpg" alt=" -In the accompanying