Microsoft Excel 2021365 - Beginner to Advanced - Formatting Cells, Rows, and Columns

Microsoft Excel 2021365 - Beginner to Advanced - Formatting Cells, Rows, and Columns

Assessment

Interactive Video

Information Technology (IT), Architecture

University

Hard

Created by

Quizizz Content

FREE Resource

The video tutorial covers various Excel formatting techniques to improve data readability and presentation. It begins with an introduction to the importance of formatting, followed by detailed instructions on adjusting row and column sizes using auto fit. The tutorial then explains how to apply number formatting to dates and currency. It also demonstrates enhancing data presentation through font and color changes, and concludes with using borders to make data more visually appealing and easier to interpret.

Read more

3 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

Explain how to apply currency formatting to a column of amounts in Excel.

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

What steps can be taken to make data in Excel more visually appealing?

Evaluate responses using AI:

OFF

3.

OPEN ENDED QUESTION

3 mins • 1 pt

What is the purpose of adding borders to cells in Excel?

Evaluate responses using AI:

OFF