Font and text styling in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the purpose of the TEXT function in Google Sheets?

The TEXT function changes how numbers or dates look by applying a format you choose, like showing a date as "Jan 1, 2024" or a number as "$1,000.00".

beginner

How do you make text bold in Google Sheets?

Select the cell or text, then click the B button on the toolbar or press Ctrl + B (Windows) / Cmd + B (Mac) to make the text bold.

beginner

What does the UPPER function do?

It changes all letters in a text string to uppercase. For example, =UPPER("hello") becomes "HELLO".

beginner

How can you change the font color of a cell in Google Sheets?

Select the cell, then click the text color button (looks like an A with a color bar) on the toolbar and pick the color you want.

intermediate

What is the difference between changing font style and using the TEXT function?

Changing font style changes how the text looks visually (like bold or color). The TEXT function changes how numbers or dates appear as text, controlling their format.

Which function formats a number as text with a specific pattern in Google Sheets?

A TEXT

B UPPER

C LOWER

D CONCATENATE

The TEXT function formats numbers or dates into text with the pattern you specify.

How do you quickly italicize text in a cell?

A Press Ctrl + I (Cmd + I on Mac)

B Press Ctrl + B (Cmd + B on Mac)

C Use the TEXT function

D Change the font color

Ctrl + I (Cmd + I) is the shortcut to italicize text.

What happens if you use =UPPER("Google Sheets") in a cell?

A It shows "google sheets"

B It causes an error

C It shows "Google Sheets"

D It shows "GOOGLE SHEETS"

The UPPER function converts all letters to uppercase.

Which toolbar button changes the font color of selected text?

A Paint bucket icon

B A with a color bar underneath

C Bold (B) button

D Underline (U) button

The 'A' with a color bar is the font color button.

If you want to show the number 1234 as "$1,234.00", which function helps?

A LOWER(1234)

B UPPER(1234)

C TEXT(1234, "$#,##0.00")

D CONCATENATE("$", 1234)

The TEXT function formats the number with dollar sign, commas, and decimals.

Explain how to change the appearance of text in Google Sheets using both toolbar options and formulas.

Think about visual changes vs. formula-based text changes.

Describe a real-life example where you would use the TEXT function to style data in a spreadsheet.

Consider invoices, reports, or budgets.