Microsoft Excel 2021365 - Beginner to Advanced - Adjusting Slicer Settings

Microsoft Excel 2021365 - Beginner to Advanced - Adjusting Slicer Settings

Assessment

Interactive Video

Information Technology (IT), Architecture

University

Hard

Created by

Quizizz Content

FREE Resource

This video tutorial explains how to use slicers in Excel to filter data in pivot tables and charts. It covers inserting slicers, customizing their appearance, and connecting them to multiple tables. The tutorial also discusses advanced slicer settings, such as sorting and hiding items without data, and emphasizes the importance of naming pivot tables for easier management.

Read more

4 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

How can you clear filters applied through slicers?

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

What is the significance of the 'Report Connections' feature in slicers?

Evaluate responses using AI:

OFF

3.

OPEN ENDED QUESTION

3 mins • 1 pt

Explain how to sort items in a slicer in ascending or descending order.

Evaluate responses using AI:

OFF

4.

OPEN ENDED QUESTION

3 mins • 1 pt

What customizations can be made to improve the appearance of slicers?

Evaluate responses using AI:

OFF