Font and text styling in Google Sheets - Practice Problems & Coding Challenges

Challenge - 5 Problems

📊 Formula Result

intermediate

What is the output of this formula with text styling?

In Google Sheets, you use the formula =TEXT(A1, "@") where cell A1 contains the text "Hello". What will be the output in the cell with this formula?

Google Sheets

=TEXT(A1, "@")

A Hello

B HELLO (all uppercase)

C Error: Invalid format

D "Hello" (including quotes)

💡 Hint

The TEXT function formats numbers or text according to the format string. "@" means text as is.

The TEXT function with format "@" returns the text exactly as it is in the referenced cell without adding quotes or changing case.

❓ Function Choice

intermediate

Which function changes text to bold in Google Sheets?

You want to make the text in a cell bold using a formula in Google Sheets. Which of these options will achieve that?

A None of these; text styling like bold is done via cell formatting, not formulas

B Use the formula =TEXT(A1, "bold")

C Use the formula =ARRAYFORMULA(BOLD(A1))

D Use the formula =BOLD(A1)

💡 Hint

Think about whether formulas can change font style in Google Sheets.

Google Sheets formulas cannot change font styles like bold or italic. These styles are applied using cell formatting options, not formulas.

🎯 Scenario

advanced

You want to highlight cells with red font if the value is negative. How to do this?

You have numbers in column A. You want the font color to turn red automatically if the number is less than zero. Which method should you use?

A Use the formula =IF(A1<0, "red", "black") in another cell

B Apply conditional formatting with the rule 'Format cells if less than 0' and set font color to red

C Use the formula =TEXT(A1, "red")

D Change the font color manually for each negative number

💡 Hint

Think about automatic font color changes based on cell values.

Conditional formatting allows automatic font color changes based on rules like 'less than 0'. Formulas cannot change font color directly.

📊 Formula Result

advanced

What does this formula output with mixed text and numbers?

Given cell A1 contains the number 123, what is the output of the formula =TEXT(A1, "00000")?

Google Sheets

=TEXT(A1, "00000")

A 123

B Error: Invalid format

C 00123

D 00000

💡 Hint

The format "00000" means show 5 digits, adding leading zeros if needed.

The TEXT function formats the number 123 as a 5-digit number with leading zeros, so it outputs 00123.

❓ data_analysis

expert

How many cells in range B1:B10 have bold font applied?

You have a range B1:B10 with some cells manually set to bold font and others normal. Using Google Sheets formulas only, how many cells are bold?

A Use =COUNTIF(B1:B10, "*")

B Use =SUMPRODUCT(--(GET.CELL(20, INDIRECT("B"&ROW(B1:B10)))=1)) with named range

C Use =COUNTIF(B1:B10, "bold")

D It is not possible to count bold cells using formulas alone

💡 Hint

Think about whether formulas can detect font styles in Google Sheets.

Google Sheets formulas cannot detect font styles like bold. This requires Apps Script or manual counting.