Microsoft Excel 2021365 - Beginner to Advanced - Exercise 07 - working with pivot charts

Microsoft Excel 2021365 - Beginner to Advanced - Exercise 07 - working with pivot charts

Assessment

Interactive Video

Information Technology (IT), Architecture, Social Studies

University

Hard

Created by

Quizizz Content

FREE Resource

This video tutorial guides viewers through an exercise on creating and formatting pivot charts. It begins with filtering data for specific categories, followed by creating a bar chart. The tutorial then covers formatting aspects such as hiding field labels, moving the legend, adding data labels, and adjusting font colors. Finally, it instructs on setting a chart title and changing the chart's color palette.

Read more

2 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

How do you change the font color of the data labels to white?

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

What title should be given to the chart and how do you change its color?

Evaluate responses using AI:

OFF