Search Header Logo
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 08 - adding interaction

Microsoft Excel 2021365 - Beginner to Advanced - Exercise 08 - adding interaction

Assessment

Interactive Video

Information Technology (IT), Architecture

University

Practice Problem

Hard

Created by

Wayground Content

FREE Resource

This video tutorial guides you through adding interaction to pivot tables and charts using slicers and timeline slicers in Excel. It covers customizing slicer settings, applying styles, and updating data sources to refresh pivot tables and charts. The tutorial provides step-by-step instructions to enhance data analysis and visualization.

Read more

7 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

What is the first step to add a slicer to filter by manager?

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

What steps are involved in changing the slicer layout from A1 to A2 column layout?

Evaluate responses using AI:

OFF

3.

OPEN ENDED QUESTION

3 mins • 1 pt

What style should be applied to the slicer as per the instructions?

Evaluate responses using AI:

OFF

4.

OPEN ENDED QUESTION

3 mins • 1 pt

How do you customize the slicer to remove the border?

Evaluate responses using AI:

OFF

5.

OPEN ENDED QUESTION

3 mins • 1 pt

What is the purpose of adding a timeline slicer?

Evaluate responses using AI:

OFF

6.

OPEN ENDED QUESTION

3 mins • 1 pt

What should you do after adding data from the July_data tab?

Evaluate responses using AI:

OFF

7.

OPEN ENDED QUESTION

3 mins • 1 pt

Describe the process to update the pivot table after adding new data.

Evaluate responses using AI:

OFF

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?