If you leave a blank row in the criteria range, Excel filters nothing and shows all records.
Correct Answer:
Verified
Q16: And and Or are logical conditions.
Q43: The link to an Internet address is
Q52: To switch between viewing the main document
Q63: Icon sets let you visually communicate relative
Q64: When specifying criteria in the Custom AutoFilter
Q65: Excel's VLOOKUP function searches vertically down the
Q81: The DCOUNTA function counts the cells that
Q83: One advantage of the Advanced Filter is
Q88: You cannot use a function to conditionally
Q89: The Transpose function is a TEXT function
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