Microsoft Excel 2021365 - Beginner to Advanced - Choosing a Report Layout

Microsoft Excel 2021365 - Beginner to Advanced - Choosing a Report Layout

Assessment

Interactive Video

Information Technology (IT), Architecture

University

Hard

Created by

Quizizz Content

FREE Resource

This video tutorial covers the design and layout options for pivot table reports. It begins with an introduction to different report layouts, including compact form, outline view, and tabular form. The tutorial explains how each layout affects the display of data, such as the arrangement of columns and the space used on the page. It also discusses how to adjust column widths and the impact of moving columns. Additional layout options, like repeating item labels and inserting blank rows, are explored to enhance report design. The video concludes with practical tips for maintaining specific column widths.

Read more

2 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

What option can you deselect to keep specific column widths in a pivot table?

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

What is the purpose of adding blank rows in a pivot table?

Evaluate responses using AI:

OFF