Microsoft Excel 2021365 - Beginner to Advanced - Applying Multiple Filters to Data

Interactive Video
•
Information Technology (IT), Architecture
•
University
•
Hard
Quizizz Content
FREE Resource
Read more
7 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Why is it important to name pivot tables and worksheets?
To make them compatible with other software
To easily identify and organize them later
To make them look professional
To increase the file size
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What prefix might be used when naming a pivot table?
PTB
PIV
PVT
TAB
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What happens when you apply a second filter to a field in a pivot table without enabling multiple filters?
The second filter is ignored
An error message is displayed
The first filter is removed
Both filters are applied
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Where can you find the option to allow multiple filters per field in a pivot table?
In the Data tab
In the Pivot Table Analyze ribbon
In the Home tab
In the Insert tab
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which tab in the Pivot Table Options allows you to enable multiple filters per field?
Totals and Filters tab
Data tab
Layout tab
Display tab
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the result of enabling multiple filters per field and applying a value filter greater than 1,000,000?
Only the first product is displayed
Only products with profits over 1,000,000 are displayed
All products are displayed
No products are displayed
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you further refine your filter to show products ending with 'TON'?
Use a label filter
Use a text filter
Use a value filter
Use a date filter
Similar Resources on Wayground
6 questions
The Complete Excel Guide: Beginners to Advanced - Advanced Filters

Interactive video
•
University
6 questions
Microsoft Excel 2021365 - Beginner to Advanced - Sorting Using Custom Lists

Interactive video
•
University
3 questions
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 06 - working with PivotTables

Interactive video
•
University
6 questions
Microsoft Excel 2021365 - Beginner to Advanced - PivotTables Explained

Interactive video
•
University
6 questions
Microsoft Excel 2021365 - Beginner to Advanced - Updating PivotTable Data

Interactive video
•
University
6 questions
Microsoft Project 2021 From Beginners to Advanced - Exercise 05-1

Interactive video
•
University
8 questions
Microsoft Excel 2021365 - Beginner to Advanced - Formatting a Pivot Chart - Part 1

Interactive video
•
University
2 questions
Microsoft Excel 2021365 - Beginner to Advanced - Applying Multiple Filters to Data

Interactive video
•
University
Popular Resources on Wayground
50 questions
Trivia 7/25

Quiz
•
12th Grade
11 questions
Standard Response Protocol

Quiz
•
6th - 8th Grade
11 questions
Negative Exponents

Quiz
•
7th - 8th Grade
12 questions
Exponent Expressions

Quiz
•
6th Grade
4 questions
Exit Ticket 7/29

Quiz
•
8th Grade
20 questions
Subject-Verb Agreement

Quiz
•
9th Grade
20 questions
One Step Equations All Operations

Quiz
•
6th - 7th Grade
18 questions
"A Quilt of a Country"

Quiz
•
9th Grade