What does the term “filter” refer to in Excel?

Related Mcqs:

1. In Excel which key is used to open the excel formula window?

   A. Shift+F6
   B. Shift+F3
   C. Alt+Shift+F3
   D. Alt+Shift+F6

   Submitted by: Muhammad Danish

2. The term chart wizard data in MS is refer to_________?

   A. Vertical axis
   B. Horizontal axis 
   C. Bar data
   D. None of these

   Submitted by: Shoaib Shah

3. What are the small squares arranged in rows and columns called in Excel?

   A. Cells
   B. Columns
   C. Blocks
   D. Rows

   Submitted by: Areesha Khan

4. Which Excel feature allows you to freeze rows and columns so they remain visible while scrolling?

   A. Lock Cells
   B. Freeze Panes
   C. Hide Rows/Columns
   D. Split Window

   Submitted by: Areesha Khan

5. Which of the following is the latest version of MS Excel?

   A. Excel 2016
   B. Excel 2017
   C. Excel 2021
   D. Office 365

   Submitted by: Malik Asghar Hussain

6. In excel columns are labelled as____________?

   A. A, B, C, etc.
   B. 1, 2, 3, etc.
   C. A1, A2, A3, etc.
   D. $A$1, $A$2, etc.

   Submitted by: Anwar Haleem

7. Actual working area of Computer’s Microsoft Excel is ________ ?

   A. Workbook
   B. Worksheet
   C. Notesheet
   D. Notebook

   Submitted by: Rashid Mehmood

8. You can edit existing Excel data by pressing the:________ key?

   A. F1 Key
   B. F2 Key
   C. F3 Key
   D. F4 Key

   Submitted by: SYED AKASH BUKHARI NAQEEBI

9. In MS Excel, Conditional Formatting is in ______ tab?

   A. Home
   B. View
   C. Page Layout
   D. Insert

   Submitted by: Syed Nizakat Ali Shah

10. In Excel, Conditional formatting is in: ______________?

    A. Insert Tab
    B. Page layout
    C. View Tab
    D. Home Tab

    Submitted by: Farhan Rana