Correct Answer:
C. Data>Filter
Correct answer: Data > Filter. In Excel, click the Data tab and then Filter to add drop-down arrows that filter a table.
Background: Filters let you show only chosen rows, for example only students with marks above 80.
- File< data: The File tab does not hold the Filter command.
- Tool> Filter: There is no Tools menu with Filter in modern Excel.
- File<Filter: Filter is not found under the File tab.
Did you know? The keyboard shortcut Ctrl + Shift + L also turns filters on and off in Excel.
Memory trick: Filter lives on the Data tab - Data, then Filter.
Leave a Reply
You must be logged in to post a comment.