Free |Excel 2003 quiz - Test Your Skills!

Filters

The aim of this quiz is to check your knowledge of Filters in |Excel 2003.

We've detected that you don't have Javascript enabled in your browser - you can still try the Quiz, but clickable 'image map' questions won't work. Please enable Javascript and refresh this page. If you can't, you can follow this link for a version which converts image questions to multiple-choice. You may also prefer to use the multiple-choice version if you use screen reading software, like JAWS, to browse.

Please ensure that you read all questions carefully and spell all answers correctly! Once you have completed the quiz, please click the 'score my answers!' button to find out how you did.

If you like this quiz, there are plenty more where it came from! You can see the full list of subjects here.

You can learn more about our classroom, online and soft skills courses at our Happy websites.

Questions

How would you switch on AutoFilter in a list?

Please select an answer...
- Click on the Insert menu, click the Filter submenu, click AutoFilter
- Click on the Data menu, click the Filter submenu, click AutoFilter
- Click on the Insert menu, click AutoFilter
- Click on the Data menu, click AutoFilter
If you have used an AutoFilter, how would you display all of the records again? Click in the image below:

Please select an answer...
What is the first thing you need to do if you want to create an advanced filter?

Please select an answer...
- Click on the Insert menu, click Advanced filter
- Select the row where you wish to place the filter
- Insert three rows above the list, and copy the header row into row 1
- Right click over the cells you wish to filter
The image below shows the criteria range for an advanced filter. What information will this filter produce?

Please select an answer...
- Everyone over 25 who earns more than £15,000
- Everyone over 25 who earns less than £15,000
- Everyone under 25 who earns more than £15,000
- Everyone under 25 who earns less than £15,000
In the example above, suppose you only wanted to include everyone whose name is Smith. How would you do this?

Please select an answer...
- Type Smith into the cell under Start Date
- Create an AutoFilter to show the Smith entries, then do the Advanced Filter
- Type Smith into the cell under Name
- Remove Advanced Filter, then create an AutoFilter to do the whole thing

Top