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

Practice - 5 Tasks

1fill in blank

easy

Complete the code to format the number in cell A1 as currency in Excel.

Excel

Select cell A1 and apply the [1] format.

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

ADate

BPercentage

CCurrency

DText

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing Percentage or Date format instead of Currency.

Using Text format which does not format numbers.

To show a number as money, use the Currency format. It adds a dollar sign and two decimals.

2fill in blank

medium

Complete the formula to calculate 20% of the value in cell B2.

Excel

=B2 * [1]

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

A20

B200

C2

D0.2

Attempts:

3 left

💡 Hint

Common Mistakes

Using 20 instead of 0.2, which multiplies by 20 times.

Using 2 or 200 which are incorrect multipliers.

To calculate 20%, multiply by 0.2 (which is 20 divided by 100).

3fill in blank

hard

Fix the error in the formula to convert the text date in cell C3 to a proper date format.

Excel

=DATEVALUE([1])

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

AC3

B"C3"

CDATE(C3)

DTEXT(C3)

Attempts:

3 left

💡 Hint

Common Mistakes

Using "C3" which is a text string, not the cell value.

Using DATE or TEXT functions incorrectly here.

DATEVALUE needs a cell reference or text string representing a date. Using C3 (without quotes) passes the cell value.

4fill in blank

hard

Fill in the blank to create a formula that formats the value in D4 as a percentage with one decimal place.

Excel

=TEXT(D4, [1])

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

A"%"

B"0.0%"

C"0.0"

D"%0.0"

Attempts:

3 left

💡 Hint

Common Mistakes

Using "0.0" formats as decimal, not percent.

Using invalid formats like "%" or "%0.0".

The TEXT function uses "0.0%" to format as percentage with one decimal. The format code multiplies by 100 and adds the % sign.

5fill in blank

hard

Complete the formula to format the date in cell E1 as 'MM/DD/YYYY'.

Excel

=TEXT(E1, [1])

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

A"mm/dd/yyyy"

B"m/d/yy"

C"yyyy-mm-dd"

D"dd/mm/yyyy"

Attempts:

3 left

💡 Hint

Common Mistakes

Using "dd/mm/yyyy" (day/month order).

Using ISO "yyyy-mm-dd".

Using short formats like "m/d/yy".

Excel's TEXT function uses "mm/dd/yyyy": 'mm' for month, 'dd' for day, 'yyyy' for year.