Excel - Pivot tables and Pivot charts | 115 plays

Excel - Pivot tables and Pivot charts

Assessment

•

Joaquin Rico

•

Computers

•

9th - 12th Grade

•

115 plays

•

Medium

Student preview

16 questions

Show answers

1.

Multiple Choice

1 min

1 pt

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

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

11 questions

Excel Lesson 12 Pt.1

•

9th - 12th Grade

16 questions

Excel Pivot Tables

•

9th - 12th Grade

16 questions

Pivot Tables

•

9th - 12th Grade

16 questions

Excel Tables

•

9th - 12th Grade

20 questions

Excel - Lesson 12: Charts

•

9th - 12th Grade

20 questions

Excel Lesson 11

•

9th - 12th Grade

11 questions

Excel Lesson 12 Pt.3

•

9th - 12th Grade

20 questions

Excel (Week 6)

•

7th - 9th Grade