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

Hard

Created by

Quizizz 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