PREMIUM
Join our WhatsApp Channel
Daily MCQs, Past Papers & Jobs for PPSC, FPSC, CSS
Daily MCQs • Past Papers • Jobs for PPSC, FPSC, CSS
Join Channel

How do you add a filter in MS-Excel?

A. File< data
B. Tool> Filter
C. Data>Filter
D. File
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.

0 comments

Leave a Reply

Join Our WhatsApp Channel ×