
Excel - Pivot Tables
Quiz
•
Computers
•
10th - 12th Grade
•
Practice Problem
•
Medium
Amanda Ringwald
Used 158+ times
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
A ____ is an interactive view of worksheet data.
PivotChart report
PivotTable report
2-D column chart
trendline
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
A ____ report is an interactive chart that allows users to change the groupings that graphically present data.
SlicerChart
PivotChart
TrendChart
2-D Column chart
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
In PivotTables, ____ fields correspond to columns in the original data.
row
index
summary
category
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
In a PivotTable, ____ fields correspond to summary values of original data across categories.
category
index
data
summary
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Viewing a PivotTable report only for a subset that meets a selection criterion is known as ____.
organizing
implementing
sorting
filtering
6.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
The summary function that calculates the number of data values in a PivotTable report is ____.
Count
Product
Var
Count Nums
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
The summary function that calculates the smallest data value in a PivotTable report is ____.
Varp
Min
Max
Average
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
15 questions
KD 3.1_Aplikasi Pengolah Angka / Spreadsheet
Quiz
•
10th Grade
14 questions
Input, output and storage de
Quiz
•
8th Grade - Professio...
12 questions
ULANGAN HARIAN Semester 2
Quiz
•
10th Grade
10 questions
Network
Quiz
•
10th - 11th Grade
15 questions
Latihan soal
Quiz
•
9th - 12th Grade
10 questions
7. Quiz Berpikir Komputasional
Quiz
•
7th Grade - University
15 questions
Quis Grade 5
Quiz
•
9th - 12th Grade
10 questions
EMPTECH L4 Q3
Quiz
•
12th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
