Number formats (currency, percentage, date) in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the currency number format do in Google Sheets?

It displays numbers with a currency symbol (like $, €, £) and two decimal places, making it easy to show money values clearly.

beginner

How do you format a number as a percentage in Google Sheets?

You apply the percentage format, which multiplies the number by 100 and adds a % sign. For example, 0.25 becomes 25%.

beginner

What happens if you enter 12/31/2023 in a cell and apply a date format?

Google Sheets recognizes it as a date and displays it according to the chosen date format, like 12/31/2023 or Dec 31, 2023.

beginner

True or False: Changing a cell's number format changes the actual value stored in the cell.

False. Number formats only change how the value looks, not the actual number stored in the cell.

beginner

How can you quickly apply currency format to a cell in Google Sheets?

Select the cell, then click the '$' icon in the toolbar or go to Format > Number > Currency.

What symbol does Google Sheets add when you format a number as currency?

A A date format

B A percent sign (%)

C A currency symbol like $ or €

D No symbol is added

Currency format adds a currency symbol such as $ or € to show money values.

If you type 0.5 and format the cell as a percentage, what will you see?

A 0.5

B 50%

C 5%

D 500%

Percentage format multiplies the number by 100 and adds a % sign, so 0.5 becomes 50%.

Which menu path lets you change a cell to a date format in Google Sheets?

A Format > Number > Date

B Data > Date Format

C Insert > Date

D Tools > Date Settings

You change number formats including date by going to Format > Number > Date.

What does changing a number format affect?

A The actual value stored in the cell

B The cell color

C The formula in the cell

D Only how the value looks

Number formats only change the appearance, not the stored value or formula.

Which of these is NOT a number format option in Google Sheets?

A Text color

B Percentage

C Date

D Currency

Text color is a formatting style, not a number format.

Explain how to format a number as currency, percentage, and date in Google Sheets.

Think about the Format menu and what each format does to the number's appearance.

Describe the difference between changing a cell's number format and changing its actual value.

Consider what you see versus what is really inside the cell.