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.

Practice

1. What does applying the Percentage number format to a cell do in Google Sheets?

easy

A. It changes the number into a date format.

B. It converts the number into currency with a $ sign.

C. It shows the number as a part of 100 with a % sign.

D. It rounds the number to the nearest whole number.

Solution

1. Step 1: Understand Percentage Format

   The percentage format multiplies the number by 100 and adds a % sign to show parts of 100.

2. Step 2: Compare with Other Formats

   Currency adds a $ sign, date changes to calendar format, rounding changes number value, so these are incorrect.

3. Final Answer:

   It shows the number as a part of 100 with a % sign. -> Option C

4. Quick Check:

   Percentage format = parts of 100 [OK]

Hint: Percentage format shows numbers as % of 100 [OK]

Common Mistakes:

• Thinking percentage changes the number value
• Confusing percentage with currency format
• Assuming percentage rounds numbers

2. Which of the following is the correct way to format a cell as currency in Google Sheets?

easy

A. Select the cell, then click Format > Number > Currency.

B. Type a $ sign before the number in the cell.

C. Use the formula =CURRENCY(A1).

D. Change the cell font color to green.

Solution

1. Step 1: Identify Currency Formatting Method

   In Google Sheets, currency format is applied via the menu: Format > Number > Currency.

2. Step 2: Evaluate Other Options

   Typing $ manually does not format the cell; no =CURRENCY formula exists; font color change does not affect number format.

3. Final Answer:

   Select the cell, then click Format > Number > Currency. -> Option A

4. Quick Check:

   Currency format applied via Format menu [OK]

Hint: Use Format > Number > Currency to format money [OK]

Common Mistakes:

• Typing $ manually instead of formatting
• Trying to use a non-existent formula
• Changing font color instead of number format

3. If cell A1 contains the number 0.25 and you apply the Percentage format, what will the cell display?

medium

A. 25%

B. 1/4/1900

C. $0.25

D. 0.25

Solution

1. Step 1: Understand Percentage Formatting

   Applying percentage format multiplies the number by 100 and adds a % sign. So 0.25 becomes 25%.

2. Step 2: Check Other Formats

   0.25 is the raw number, $0.25 is currency, and 1/4/1900 is a date format interpretation, so these are incorrect.

3. Final Answer:

   25% -> Option A

4. Quick Check:

   0.25 as percentage = 25% [OK]

Hint: Percentage format multiplies by 100 and adds % [OK]

Common Mistakes:

• Expecting the number to stay the same
• Confusing currency and percentage formats
• Thinking date format applies automatically

4. You entered the date 12/31/2023 in a cell, but it shows as 44926. What should you do to fix this?

medium

A. Increase the font size to make the date visible.

B. Re-enter the date with dashes instead of slashes.

C. Use the formula =DATE(2023,12,31) instead.

D. Change the cell format to Date via Format > Number > Date.

Solution

1. Step 1: Understand Date Storage

   Google Sheets stores dates as numbers (days since 12/30/1899). 44926 is the number for 12/31/2023.

2. Step 2: Apply Date Format

   To see the date instead of the number, change the cell format to Date via Format > Number > Date.

3. Final Answer:

   Change the cell format to Date via Format > Number > Date. -> Option D

4. Quick Check:

   Date format shows calendar date, not serial number [OK]

Hint: Change format to Date to see calendar dates, not numbers [OK]

Common Mistakes:

• Re-entering date instead of formatting
• Using formulas unnecessarily
• Changing font size instead of format

5. You have a list of prices in column A as numbers (e.g., 12.5, 7.99). You want to show them as US dollars with two decimals and a $ sign. Which steps will achieve this correctly?

hard

A. Use the formula =TEXT(A1, "$0.00") in a new column.

B. Select column A, then Format > Number > Currency, and set decimal places to 2.

C. Type $ before each number manually and round to 2 decimals.

D. Change the cell format to Percentage and multiply by 100.

Solution

1. Step 1: Apply Currency Format

   Select the cells and use Format > Number > Currency to add $ sign and currency style.

2. Step 2: Set Decimal Places

   Adjust decimal places to 2 to show cents properly.

3. Final Answer:

   Select column A, then Format > Number > Currency, and set decimal places to 2. -> Option B

4. Quick Check:

   Currency format + 2 decimals = correct money display [OK]

Hint: Use Format > Number > Currency and set decimals to 2 [OK]

Common Mistakes:

• Typing $ manually instead of formatting
• Using percentage format by mistake
• Using TEXT formula unnecessarily