Number formats (currency, percentage, date) in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to format cell A1 as currency in Google Sheets.

Google Sheets

Format cell A1 using the number format: [1]

Drag options to blanks, or click blank then click option'

A"$#,##0.00"

B"0.00%"

C"mm/dd/yyyy"

D"@"

Attempts:

3 left

💡 Hint

Common Mistakes

Using percentage format instead of currency.

Using date format for numbers.

To format a cell as currency, use the format string "$#,##0.00" which shows the dollar sign and two decimals.

2fill in blank

medium

Complete the formula to convert the value in B2 to a percentage format in Google Sheets.

Google Sheets

=TEXT(B2, [1])

Drag options to blanks, or click blank then click option'

A"$#,##0.00"

B"0.00%"

C"mm/dd/yyyy"

D"@"

Attempts:

3 left

💡 Hint

Common Mistakes

Using currency format instead of percentage.

Using date format for numbers.

The format string "0.00%" converts a decimal number to a percentage with two decimal places.

3fill in blank

hard

Fix the error in the formula to display the date in cell C3 as "Month Day, Year" format.

Google Sheets

=TEXT(C3, [1])

Drag options to blanks, or click blank then click option'

A"mmmm d, yyyy"

B"dd-mm-yyyy"

C"mm/dd/yyyy"

D"0.00%"

Attempts:

3 left

💡 Hint

Common Mistakes

Using numeric date formats instead of spelled-out month.

Using percentage format for dates.

The format string "mmmm d, yyyy" shows the full month name, day without leading zero, and four-digit year.

4fill in blank

hard

Fill both blanks to create a formula that formats the value in D4 as currency with two decimals and a comma separator.

Google Sheets

=TEXT(D4, [1] & [2])

Drag options to blanks, or click blank then click option'

A"$"

B"#,##0"

C"0.00"

D"%"

Attempts:

3 left

💡 Hint

Common Mistakes

Using percentage sign instead of dollar sign.

Missing decimal places in format.

Combining "$" and "0.00" formats the number as currency with two decimals. The comma separator is included in the number format part.

5fill in blank

hard

Fill all three blanks to create a formula that formats E5 as a percentage with one decimal place and adds a space before the percent sign.

Google Sheets

=TEXT(E5, [1] & [2] & [3])

Drag options to blanks, or click blank then click option'

A"0.0"

B"%"

C" "

D"#,##0"

Attempts:

3 left

💡 Hint

Common Mistakes

Not adding space before percent sign.

Using wrong decimal places.

"0.0" formats one decimal place, " " adds a space, and "%" adds the percent sign with a space before it.