Excel - Pivot tables and Pivot charts

Excel - Pivot tables and Pivot charts

Assessment

Assessment

Created by

Joaquin Rico

Computers

9th - 12th Grade

115 plays

Medium

Student preview

quiz-placeholder

16 questions

Show answers

1.

Multiple Choice

1 min

1 pt

Media Image

What can you use to easily filter pivot tables interactively in a worksheet?

Slicer

Cutter

Division

Sliver

2.

Multiple Choice

1 min

1 pt

John wants to create a chart that shows trends of sales for four quarters. What type of chart should he create?

Pivot Chart

Line Chart

Embedded Chart

Linked Chart

3.

Multiple Choice

1 min

1 pt

Media Image

What is the purpose of the -/+ buttons that appear across the categories on a PivotTable?

Decrease/Increase

Collapse/Expand

Reduce/Add

Subtract/Add

4.

Multiple Choice

1 min

1 pt

John wants to add text effects to his PivotChart. Which PivotTable Chart Tools tab would he use?

Design

Format

Layout

Analyze

5.

Multiple Choice

1 min

1 pt

John has created a Pivot chart and would like to include a guide that would display the names of the series of data included on the chart. Which option would allow him to do this?

Report Filter

Legend Fields

Axis Fields

Values

Explore all questions with a free account

or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?

Find a similar activity

Create activity tailored to your needs using

Quizizz AI
Excel - Lesson 12: Charts

20 questions

Excel - Lesson 12: Charts

assessment

9th - 12th Grade

Excel Lesson 11

20 questions

Excel Lesson 11

assessment

9th - 12th Grade

Excel Lesson 12 Pt.3

11 questions

Excel Lesson 12 Pt.3

assessment

9th - 12th Grade

Excel (Week 6)

20 questions

Excel (Week 6)

assessment

7th - 9th Grade

Excel Lesson 12 Pt.1

11 questions

Excel Lesson 12 Pt.1

assessment

9th - 12th Grade

Excel Pivot Tables

16 questions

Excel Pivot Tables

assessment

9th - 12th Grade

Pivot Tables

16 questions

Pivot Tables

assessment

9th - 12th Grade

Excel Tables

16 questions

Excel Tables

assessment

9th - 12th Grade