Challenge - 5 Problems
TEXT Function Mastery
Get all challenges correct to earn this badge!
Test your skills under time pressure!
📊 Formula Result
intermediate2:00remaining
What is the output of this TEXT formula?
Given the date in cell A1 as 2024-06-15, what will be the result of the formula
=TEXT(A1, "dddd, mmmm dd, yyyy")?Excel
=TEXT(A1, "dddd, mmmm dd, yyyy")Attempts:
2 left
💡 Hint
The format code "dddd" shows the full weekday name, and "mmmm" shows the full month name.
✗ Incorrect
The TEXT function formats the date in A1 using the pattern: full weekday name (dddd), full month name (mmmm), day with two digits (dd), and four-digit year (yyyy). So it outputs "Saturday, June 15, 2024".
📊 Formula Result
intermediate2:00remaining
What does this TEXT formula output for a number?
If cell B1 contains the number 1234.567, what is the result of
=TEXT(B1, "#,##0.00")?Excel
=TEXT(B1, "#,##0.00")Attempts:
2 left
💡 Hint
The format uses commas for thousands and rounds to two decimals.
✗ Incorrect
The format "#,##0.00" adds commas as thousand separators and rounds the number to two decimal places, so 1234.567 becomes "1,234.57".
❓ Function Choice
advanced2:00remaining
Which TEXT format code will display time as 2:05 PM?
You have a time value in cell C1. Which format code in
=TEXT(C1, "format_code") will show the time as 2:05 PM?Attempts:
2 left
💡 Hint
Use 'h' for hours without leading zero and uppercase 'AM/PM' for uppercase meridian indicator.
✗ Incorrect
The correct format is "h:mm AM/PM" to show the time as "2:05 PM" (no leading zero on hour, uppercase PM). "hh:mm AM/PM" would show "02:05 PM". Lowercase "am/pm" displays as "pm".
🎯 Scenario
advanced2:00remaining
Formatting a number as currency with TEXT
You want to display the value in cell D1 as US dollars with a dollar sign, commas, and two decimals, like "$1,234.50". Which formula will do this correctly?
Attempts:
2 left
💡 Hint
In Excel format codes, the dollar sign does not need escaping.
✗ Incorrect
The correct format is "$#,##0.00". B lacks dollar sign (shows "1,234.50"), C incorrectly escapes dollar (shows "$\1,234.50"), D lacks thousands separator (shows "$1234.50").
❓ data_analysis
expert2:00remaining
How many unique formatted outputs are produced?
Given the values in cells E1:E4 as {0.5, 1, 1.5, 2} and the formula
=TEXT(E1, "0.0") copied down to E4, how many unique text outputs will appear?Excel
=TEXT(E1, "0.0")Attempts:
2 left
💡 Hint
The format "0.0" shows one decimal place, so each value rounds to one decimal.
✗ Incorrect
Each value rounds to one decimal place: 0.5 → "0.5", 1 → "1.0", 1.5 → "1.5", 2 → "2.0". All four are unique text outputs.