Microsoft Excel 2021365 - Beginner to Advanced - Applying Number Formats

Microsoft Excel 2021365 - Beginner to Advanced - Applying Number Formats

Assessment

Interactive Video

Information Technology (IT), Architecture

University

Hard

Created by

Quizizz Content

FREE Resource

This video tutorial explains the concept of number formatting in spreadsheets, covering general, currency, accounting, and percentage formats. It demonstrates how to apply and customize these formats, emphasizing that formatting changes the display, not the underlying value. The tutorial also addresses common issues with percentage formatting and introduces additional formatting options, including custom formats.

Read more

4 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

Describe how to use the increase and decrease decimal buttons in number formatting.

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

How does the formula bar display the actual value of a cell with number formatting applied?

Evaluate responses using AI:

OFF

3.

OPEN ENDED QUESTION

3 mins • 1 pt

What should you do if you want to apply percentage formatting to numbers written as whole numbers?

Evaluate responses using AI:

OFF

4.

OPEN ENDED QUESTION

3 mins • 1 pt

What are some other number formats available in a spreadsheet aside from currency and percentage?

Evaluate responses using AI:

OFF