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

Challenge - 5 Problems

📊 Formula Result

intermediate

What is the displayed value of a currency formatted cell?

Cell A1 contains the number 1234.567. The cell is formatted as currency with 2 decimal places and the dollar sign ($). What will the cell display?

A $1,234.57

B $1234.567

C 1234.57

D 1234.567

💡 Hint

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

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

📊 Formula Result

intermediate

How does percentage formatting affect a cell value?

Cell B2 contains the number 0.085. The cell is formatted as percentage with 1 decimal place. What is the displayed value?

A 0.085%

B 0.1%

C 8.5%

D 85%

💡 Hint

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

0.085 as a percentage is 8.5%. The format shows one decimal place.

❓ Function Choice

advanced

Which formula converts a date string to a date value in Google Sheets?

You have the text "2024-06-15" in cell C3. Which formula correctly converts it to a date value that Google Sheets recognizes?

A =VALUE("2024-06-15")

B =DATEVALUE(C3)

C =TO_PURE_NUMBER(C3)

D =TEXT(C3, "yyyy-mm-dd")

💡 Hint

DATEVALUE converts a date string to a date number.

DATEVALUE converts a date string to a serial number date value. TEXT returns text, TO_PURE_NUMBER expects a number, VALUE works but only if input is a number or date serial.

🎯 Scenario

advanced

You want to display 0.756 as a percentage with no decimals. Which number format should you apply?

Given the number 0.756 in a cell, you want it to show as "76%" (rounded, no decimals). What number format setting should you use?

A Percentage with 0 decimal places

B Currency with 0 decimal places

C Number with 2 decimal places

D Date format MM/DD/YYYY

💡 Hint

Percentage format multiplies by 100 and shows % sign.

Percentage format with 0 decimals rounds 0.756 to 76%.

❓ data_analysis

expert

Analyzing date format display differences

You enter the date 6/7/2024 in cell D4. The cell is formatted as "MM/DD/YYYY". What will the cell display if you change the format to "DD-MMM-YY"?

A 07-Jul-24

B 06-Jul-24

C 06-Jun-24

D 07-Jun-24

💡 Hint

MM is month, DD is day, MMM is short month name, YY is two-digit year.

The date 6/7/2024 with MM/DD/YYYY format is June 7, 2024 (month/day/year). Changing to DD-MMM-YY shows 07-Jun-24.