Bird
Raised Fist0
Google Sheetsspreadsheet~5 mins

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

Choose your learning style10 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
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".
Click to reveal answer
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.
Click to reveal answer
beginner
What does the UPPER function do?
It changes all letters in a text string to uppercase. For example, =UPPER("hello") becomes "HELLO".
Click to reveal answer
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.
Click to reveal answer
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.
Click to reveal answer
Which function formats a number as text with a specific pattern in Google Sheets?
ATEXT
BUPPER
CLOWER
DCONCATENATE
How do you quickly italicize text in a cell?
APress Ctrl + I (Cmd + I on Mac)
BPress Ctrl + B (Cmd + B on Mac)
CUse the TEXT function
DChange the font color
What happens if you use =UPPER("Google Sheets") in a cell?
AIt shows "google sheets"
BIt causes an error
CIt shows "Google Sheets"
DIt shows "GOOGLE SHEETS"
Which toolbar button changes the font color of selected text?
APaint bucket icon
BA with a color bar underneath
CBold (B) button
DUnderline (U) button
If you want to show the number 1234 as "$1,234.00", which function helps?
ALOWER(1234)
BUPPER(1234)
CTEXT(1234, "$#,##0.00")
DCONCATENATE("$", 1234)
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.
You got /3 concepts.
    Describe a real-life example where you would use the TEXT function to style data in a spreadsheet.
    Consider invoices, reports, or budgets.
    You got /3 concepts.

      Practice

      (1/5)
      1. Which toolbar button in Google Sheets would you use to make text bold?
      easy
      A. The button with a paint bucket icon
      B. The button with an I icon
      C. The button with a B icon
      D. The button with a U icon

      Solution

      1. Step 1: Identify the bold icon in the toolbar

        The bold button is represented by a capital letter B in bold style.

      2. Step 2: Match the icon to the correct function

        Clicking the B icon makes selected text bold.

      3. Final Answer:

        The button with a B icon -> Option C

      4. Quick Check:

        Bold text = B icon [OK]
      Hint: Bold text uses the B icon on the toolbar [OK]
      Common Mistakes:
      • Confusing italic (I) with bold (B)
      • Choosing underline (U) instead of bold
      • Selecting paint bucket which changes background color
      2. Which of these is the correct way to change the font color of a cell's text in Google Sheets using the toolbar?
      easy
      A. Right-click the cell and select 'Font Color'
      B. Click the paint bucket icon and select a color
      C. Click the bold button and choose a color
      D. Click the letter A with a color bar underneath and pick a color

      Solution

      1. Step 1: Identify the font color button on the toolbar

        The font color button shows a letter A with a colored bar below it.

      2. Step 2: Understand the paint bucket icon function

        The paint bucket changes the cell background color, not text color.

      3. Final Answer:

        Click the letter A with a color bar underneath and pick a color -> Option D

      4. Quick Check:

        Font color = A with color bar [OK]
      Hint: Font color uses the A icon with a color bar [OK]
      Common Mistakes:
      • Choosing paint bucket which changes background color
      • Thinking bold button changes color
      • Right-click menu does not have 'Font Color' option
      3. If cell A1 contains the text "Hello" and you apply the formula =UPPER(A1) in cell B1, what will be the font style and text in B1?
      medium
      A. "HELLO" in uppercase letters, font style unchanged
      B. "hello" in lowercase letters, font style bold
      C. "Hello" unchanged, font style italic
      D. Error because UPPER changes font style

      Solution

      1. Step 1: Understand the UPPER function effect on text

        The UPPER function converts all letters to uppercase but does not change font style.

      2. Step 2: Check the output in cell B1

        Cell B1 will show "HELLO" in uppercase with the default font style (no bold or italic applied).

      3. Final Answer:

        "HELLO" in uppercase letters, font style unchanged -> Option A

      4. Quick Check:

        UPPER changes text case only [OK]
      Hint: UPPER changes text case, not font style [OK]
      Common Mistakes:
      • Thinking UPPER makes text bold or italic
      • Confusing UPPER with formatting tools
      • Expecting an error from UPPER function
      4. You want to automatically make text red in cells with values less than 50. Which step fixes this conditional formatting rule that is not working?

      Rule set: Format cells if "Less than" 50, but text color stays black.
      medium
      A. Change the rule to "Greater than" 50
      B. Set the text color in formatting style to red
      C. Remove the conditional formatting rule
      D. Change the cell format to bold instead of color

      Solution

      1. Step 1: Check the conditional formatting rule setup

        The rule "Less than 50" is correct to target cells with values under 50.

      2. Step 2: Verify the formatting style applied

        If text color stays black, the formatting style likely does not have text color set to red.

      3. Final Answer:

        Set the text color in formatting style to red -> Option B

      4. Quick Check:

        Conditional formatting needs style set [OK]
      Hint: Set text color in conditional formatting style [OK]
      Common Mistakes:
      • Changing rule condition instead of style
      • Removing rule instead of fixing style
      • Changing format to bold does not fix color issue
      5. You want to highlight all cells in column B that contain the word "urgent" (case insensitive) by making the text bold and red automatically. Which conditional formatting custom formula should you use?
      hard
      A. =SEARCH("urgent", B1)
      B. =EXACT(B1, "urgent")
      C. =REGEXMATCH(B1, "urgent")
      D. =LOWER(B1) = "urgent"

      Solution

      1. Step 1: Understand the need for case-insensitive substring matching

        SEARCH("urgent", B1) finds "urgent" anywhere in the cell ignoring case, returns a number if found (truthy in conditional formatting), or #VALUE! if not (falsy).

      2. Step 2: Compare other formulas

        REGEXMATCH is case-sensitive by default; EXACT is case-sensitive exact match; LOWER(B1) = "urgent" requires the entire cell to match exactly after lowering.

      3. Final Answer:

        =SEARCH("urgent", B1) -> Option A

      4. Quick Check:

        SEARCH for case-insensitive substring [OK]
      Hint: SEARCH for case-insensitive substring search [OK]
      Common Mistakes:
      • Using REGEXMATCH which is case-sensitive
      • Using EXACT which is case-sensitive exact match
      • Using LOWER(B1) = "urgent" which matches exact cell content only
      Recommended

      Ready to prove it?

      Pass the test and this pattern moves unknown strong while earning +1 Grip toward your certificate.

      10 questions~5 mineasy hard