Number formats (currency, percentage, date) in Excel - Practice Problems & Coding Challenges

Challenge - 5 Problems

📊 Formula Result

intermediate

What is the displayed value with currency format?

Cell A1 contains the number 1234.567. The cell is formatted as Currency with 2 decimal places and the dollar sign ($). What is the displayed value in A1?

A $1,234.57

B 1234.57

C $1234.567

D 1234.567

💡 Hint

Currency format rounds to 2 decimals and adds the currency symbol.

Currency format rounds the number to 2 decimal places and adds the dollar sign with comma separators.

📊 Formula Result

intermediate

What is the displayed value with percentage format?

Cell B2 contains the number 0.256. The cell is formatted as Percentage with 1 decimal place. What is the displayed value in B2?

A 0.3%

B 25.6%

C 0.256%

D 256%

💡 Hint

Percentage format multiplies the number by 100 and adds % sign.

0.256 as a percentage with 1 decimal place is 25.6%.

📊 Formula Result

advanced

What date is shown with custom date format?

Cell C3 contains the date value 44561 (Excel serial date number). The cell is formatted with the custom date format "dddd, mmmm dd, yyyy". What is the displayed value?

A 06/12/2021

B 12/06/2021

C Monday, December 06, 2021

D Monday, 12 06, 2021

💡 Hint

Excel date 44561 corresponds to December 6, 2021.

The custom format shows full weekday name, full month name, day with leading zero, and full year.

❓ Function Choice

advanced

Which formula converts a decimal to a percentage string with 2 decimals?

You want to convert the decimal number in cell D4 to a text string showing percentage with exactly 2 decimal places (e.g., 0.1234 → "12.34%"). Which formula will do this correctly?

A =TEXT(D4, "0.00%")

B =D4*100 & "%"

C =CONCATENATE(D4*100, "%")

D =ROUND(D4, 2) & "%"

💡 Hint

Use TEXT function with percentage format code.

TEXT with "0.00%" formats the number as percentage with 2 decimals and adds % sign.

🎯 Scenario

expert

You have a list of prices in column A and want to show them as currency in column B with a formula. Which formula in B2 correctly converts the number in A2 to a currency string with $ and 2 decimals?

Given prices in A2:A10 as numbers, you want column B to show prices as text with dollar sign, commas, and 2 decimals (e.g., 1234.5 → "$1,234.50"). Which formula should you enter in B2 and copy down?

A =FIXED(A2, 2)

B ="$" & ROUND(A2, 2)

C =CONCATENATE("$", A2)

D =TEXT(A2, "$#,##0.00")

💡 Hint

Use TEXT function with currency format code for proper commas and decimals.

TEXT with "$#,##0.00" formats number with dollar sign, commas, and 2 decimals as text.