MS Excel Filter Function Tutorial

BeneficiaryNobelium avatar
BeneficiaryNobelium
·
·
Download

Start Quiz

Study Flashcards

Questions and Answers

What is the purpose of clicking the arrow next to 'Country' in the Filter feature?

To filter the data to show only a specific country

What happens when you click 'OK' after selecting a country in the Filter feature?

The data is filtered to show only the selected country

How do you remove the filter in Excel?

By clicking 'Clear' in the Data tab

What is the result of filtering the data by country and quarter?

<p>The data is filtered to show only the sales in the selected country and quarter</p> Signup and view all the answers

What is the purpose of clicking 'Filter' in the Data tab?

<p>To apply the filter</p> Signup and view all the answers

What is the alternative method to filter the data?

<p>By right-clicking and selecting 'Filter by Selected Cell's Value'</p> Signup and view all the answers

What is the result of clicking 'Select All' in the Filter feature?

<p>It clears all the check boxes</p> Signup and view all the answers

What happens when you filter the data by country and then by quarter?

<p>The data is filtered to show only the sales in the selected country and quarter</p> Signup and view all the answers

What is the purpose of clicking the arrow next to 'Quarter' in the Filter feature?

<p>To filter the data by quarter</p> Signup and view all the answers

What is the result of clicking 'Clear' in the Data tab?

<p>The filter is removed</p> Signup and view all the answers

More Quizzes Like This

Excel Lookup Formulas and Functions Quiz
3 questions
Excel Shortcuts and Functions Quiz
5 questions
Fórmulas en Excel
10 questions
Use Quizgecko on...
Browser
Browser