Microsoft Excel 2021365 - Beginner to Advanced - Applying Subtotals and Grand Totals

Microsoft Excel 2021365 - Beginner to Advanced - Applying Subtotals and Grand Totals

Assessment

Interactive Video

Information Technology (IT), Architecture

University

Hard

Created by

Quizizz Content

FREE Resource

The video tutorial explains how subtotals and grand totals are automatically added to data analysis and how users can customize their display. It covers the options available for showing or hiding these totals, adjusting their positions, and managing their presence in rows and columns. Additionally, the tutorial demonstrates how to rename labels for better clarity in data presentation.

Read more

5 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

What are the two types of totals mentioned in the text?

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

How can you control the display of subtotals and grand totals?

Evaluate responses using AI:

OFF

3.

OPEN ENDED QUESTION

3 mins • 1 pt

What happens when you move the product back to the columns area?

Evaluate responses using AI:

OFF

4.

OPEN ENDED QUESTION

3 mins • 1 pt

What is the default position for displaying subtotals?

Evaluate responses using AI:

OFF

5.

OPEN ENDED QUESTION

3 mins • 1 pt

How can you rename the labels in the data?

Evaluate responses using AI:

OFF