Why formatting communicates data meaning in Google Sheets - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to apply bold formatting to cell A1 in Google Sheets using Apps Script.

Google Sheets

SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getRange('A1').setFontWeight([1]);

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

A"bold"

B"italic"

C"underline"

D"normal"

Attempts:

3 left

💡 Hint

Common Mistakes

Using "italic" or "underline" instead of "bold".

Forgetting to use quotes around the style.

To make text bold in Google Sheets using Apps Script, use setFontWeight("bold").

2fill in blank

medium

Complete the formula to format the number in cell B2 as currency in Google Sheets.

Google Sheets

=TEXT(B2, [1])

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

A"$#,##0.00"

B"0%"

C"#,##0"

D"0.00"

Attempts:

3 left

💡 Hint

Common Mistakes

Using "0.00" which shows decimals but no currency symbol.

Using "0%" which formats as percentage.

The format string "$#,##0.00" formats numbers as currency with dollar sign and two decimals.

3fill in blank

hard

Fix the error in the formula to display the date in cell C3 as "Month Day, Year" format.

Google Sheets

=TEXT(C3, [1])

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

A"DD/MM/YYYY"

B"MM-DD-YYYY"

C"MMM DD, YY"

D"MMMM DD, YYYY"

Attempts:

3 left

💡 Hint

Common Mistakes

Using "MM-DD-YYYY" which shows numeric month.

Using "MMM DD, YY" which shows abbreviated month and two-digit year.

The format string "MMMM DD, YYYY" shows the full month name, day, and four-digit year.

4fill in blank

hard

Fill the blank to create a conditional formatting rule that colors cells red if their value is less than 50.

Google Sheets

Format > Conditional formatting > Format cells if [1] 50

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

A"Equal to"

B"Greater than"

C"Less than"

D"Not equal to"

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing "Greater than" which colors cells above 50.

Using "Equal to" which only colors cells exactly 50.

To color cells red if less than 50, choose the condition "Less than" and enter 50.

5fill in blank

hard

Fill both blanks to create a formula that formats the number in D4 as a percentage with one decimal place.

Google Sheets

=TEXT([1], [2])

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

AD4

B"0.0%"

C"0%"

D"0.00%"

Attempts:

3 left

💡 Hint

Common Mistakes

Using "0%" which shows no decimals.

Using "0.00%" which shows two decimals.

The formula =TEXT(D4, "0.0%") formats the number in D4 as a percentage with one decimal place.