How to Filter Records and Data in Excel


Choose an answer and hit 'next'. You will receive your score and answers at the end.

question 1 of 3

Under which menu and grouping of commands will you find the Filter tool?

Create Your Account To Take This Quiz

As a member, you'll also get unlimited access to over 75,000 lessons in math, English, science, history, and more. Plus, get practice tests, quizzes, and personalized coaching to help you succeed.

Try it risk-free
Try it risk-free for 30 days. Cancel anytime.
Already registered? Log in here for access

1. In order to perform a filter correctly, you must have titles for your columns. What is the row of titles called?

2. What happens to the header row when you click on the filter command?

Create your account to access this entire worksheet
A Premium account gives you access to all lesson, practice exams, quizzes & worksheets
Access to all video lessons
Quizzes, practice exams & worksheets
Certificate of Completion
Access to instructors
Create an account to get started Create Account

About This Quiz & Worksheet

This quiz and worksheet combination will examine your understanding of the Filter tool's location, functions and some of its necessary components.

Quiz & Worksheet Goals

The assessment will especially emphasize:

  • Clearing filters
  • The primary function of the Filter tool
  • What happens to the header row after clicking the filter command
  • What the title rows for columns are called
  • How to find the Filter tool

Skills Practiced

This quiz and worksheet will test your skills in the following areas:

  • Information recall - access any previous knowledge of Microsoft programs
  • Reading comprehension - ensure that you draw the most important information from the related lesson on filtering records and data
  • Interpreting information - verify that you can interpret information on how to correctly filter

Additional Learning

If you're interested in learning more about filtering in Excel, look at the related lesson on How to Filter Records and Data in Excel. The lesson will help you cover the following objectives:

  • The necessity of a header row
  • How to run a filter
  • Real-life uses of the Filter tool
  • Ways to plug in information