TEXT function for formatting in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to format the date in cell A1 as "MM/DD/YYYY" using the TEXT function.

Excel

=TEXT(A1, [1])

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

A"MM/DD/YYYY"

BMM/DD/YYYY

C"YYYY/MM/DD"

D"DD-MM-YYYY"

Attempts:

3 left

💡 Hint

Common Mistakes

Forgetting to put the format code in quotes.

Using the wrong format code like MM-DD-YYYY.

The TEXT function requires the format code as a text string, so it must be enclosed in quotes.

2fill in blank

medium

Complete the formula to format the number in cell B2 as currency with two decimal places.

Excel

=TEXT(B2, [1])

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

A"#,##0"

B"0.00"

C"$0.00"

D"0%"

Attempts:

3 left

💡 Hint

Common Mistakes

Using "0.00" which shows decimals but no dollar sign.

Using "0%" which formats as percentage.

The format code "$0.00" formats the number as currency with a dollar sign and two decimals.

3fill in blank

hard

Fix the error in the formula to format the time in cell C3 as hours and minutes (HH:MM).

Excel

=TEXT(C3, [1])

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

A"HH:mm"

B"hh:MM"

C"HH:MM"

D"hh:mm"

Attempts:

3 left

💡 Hint

Common Mistakes

Using "HH:MM" which shows months instead of minutes.

Using "hh:MM" which mixes lowercase hours with uppercase months.

In Excel time format codes, lowercase "h" or uppercase "H" is for hours, lowercase "m" is for minutes. "MM" means months, so use "hh:mm".

4fill in blank

hard

Fill both blanks to format the number in D4 as a percentage with one decimal place.

Excel

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

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

A"0.0"

B"%"

C"0.0%"

D"0"

Attempts:

3 left

💡 Hint

Common Mistakes

Using "0" without decimals.

Using "0.0%" as a single string without concatenation.

To format as percentage with one decimal, combine "0.0" and "%" as text strings.

5fill in blank

hard

Fill all three blanks to format the date in cell E1 as full month name followed by year, e.g., "January 2024".

Excel

= [1](E1, [2]) & " " & [1](E1, [3])

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

ATEXT

B"MMMM"

C"YYYY"

DFORMAT

Attempts:

3 left

💡 Hint

Common Mistakes

Using a non-existent FORMAT function.

Forgetting to repeat TEXT in both places.

Using "MMM" for abbreviated month.

The TEXT function is used twice: TEXT(E1, "MMMM") for the full month name and TEXT(E1, "YYYY") for the year, joined by a space.