Font styling (bold, italic, color) in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to make the text in cell A1 bold.

Excel

Range("A1").Font.[1] = True

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

ABold

BItalic

CColor

DUnderline

Attempts:

3 left

💡 Hint

Common Mistakes

Using Italic instead of Bold

Trying to set Color property to True

Using incorrect property names

Setting Font.Bold = True makes the text bold.

2fill in blank

medium

Complete the code to make the text in cell B2 italic.

Excel

Range("B2").Font.[1] = True

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

AUnderline

BBold

CItalic

DColor

Attempts:

3 left

💡 Hint

Common Mistakes

Using Bold instead of Italic

Trying to set Color property to True

Misspelling the property name

Setting Font.Italic = True makes the text italic.

3fill in blank

hard

Fix the error in the code to change the font color of cell C3 to red.

Excel

Range("C3").Font.[1] = RGB(255, 0, 0)

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

ABold

BColor

CItalic

DUnderline

Attempts:

3 left

💡 Hint

Common Mistakes

Using Bold or Italic property to set color

Misspelling Color as Colour

Not using RGB function correctly

The Font.Color property sets the font color. Using RGB(255, 0, 0) sets it to red.

4fill in blank

hard

Fill both blanks to make the text in cell D4 bold and italic.

Excel

With Range("D4").Font
  .[1] = True
  .[2] = True
End With

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

ABold

BColor

CItalic

DUnderline

Attempts:

3 left

💡 Hint

Common Mistakes

Using Color or Underline instead of Italic

Setting only one property instead of both

Mixing up the order of properties

Setting both Bold and Italic properties to True makes the text bold and italic.

5fill in blank

hard

Fill all three blanks to make the text in cell E5 bold, italic, and red color.

Excel

With Range("E5").Font
  .[1] = True
  .[2] = True
  .[3] = RGB(255, 0, 0)
End With

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

ABold

BItalic

CColor

DUnderline

Attempts:

3 left

💡 Hint

Common Mistakes

Using Underline instead of Color

Setting Color to True instead of RGB value

Mixing up the order of properties

Set Bold and Italic to True, and Color to red using RGB(255, 0, 0).

Practice

1. Which of the following font styles will make the text thicker and stand out more in Excel?

easy

A. Italic

B. Bold

C. Underline

D. Strikethrough

Solution

1. Step 1: Understand font style effects

   Bold makes text thicker and more visible, while Italic slants text, Underline adds a line below, and Strikethrough draws a line through text.

2. Step 2: Identify the style that makes text thicker

   Only Bold increases the thickness and makes text stand out more.

3. Final Answer:

   Bold -> Option B

4. Quick Check:

   Bold = thicker text [OK]

Hint: Bold makes text thicker and easier to spot [OK]

Common Mistakes:

• Confusing Italic with Bold
• Thinking Underline makes text thicker
• Mixing Strikethrough with Bold

2. Which keyboard shortcut applies italic style to selected text in Excel?

easy

A. Ctrl + B

B. Ctrl + C

C. Ctrl + U

D. Ctrl + I

Solution

1. Step 1: Recall common Excel shortcuts

   Ctrl + B applies Bold, Ctrl + I applies Italic, Ctrl + U applies Underline, and Ctrl + C copies content.

2. Step 2: Match shortcut to Italic

   Ctrl + I is the standard shortcut for Italic style.

3. Final Answer:

   Ctrl + I -> Option D

4. Quick Check:

   Italic shortcut = Ctrl + I [OK]

Hint: Italic shortcut is Ctrl + I, like the letter I for Italic [OK]

Common Mistakes:

• Using Ctrl + B for Italic
• Confusing Ctrl + U with Italic
• Thinking Ctrl + C changes style

3. If cell A1 contains the text "Report" and you apply the font color red and bold style, what will be the visible appearance of the text?

medium

A. Text is red and bold

B. Text is red and italic

C. Text is black and bold

D. Text is black and italic

Solution

1. Step 1: Understand applied styles

   Applying font color red changes text color to red. Applying bold makes text thicker.

2. Step 2: Combine effects on text

   Text will appear in red color and bold style simultaneously.

3. Final Answer:

   Text is red and bold -> Option A

4. Quick Check:

   Red color + Bold = red bold text [OK]

Hint: Color and bold combine visually as red thick text [OK]

Common Mistakes:

• Assuming italic instead of bold
• Ignoring color change
• Thinking text stays black

4. You tried to make text in cell B2 italic by pressing Ctrl + B. Why did it not work?

medium

A. Ctrl + B applies bold, not italic

B. Cell B2 is locked and cannot be formatted

C. You need to double-click the cell first

D. Italic is only available from the menu, not shortcuts

Solution

1. Step 1: Identify shortcut functions

   Ctrl + B applies bold style, not italic. Italic uses Ctrl + I.

2. Step 2: Explain why Ctrl + B failed for italic

   Pressing Ctrl + B changes bold state, so italic was not applied.

3. Final Answer:

   Ctrl + B applies bold, not italic -> Option A

4. Quick Check:

   Ctrl + B = Bold, not Italic [OK]

Hint: Remember Ctrl + I for Italic, Ctrl + B for Bold [OK]

Common Mistakes:

• Thinking Ctrl + B makes Italic
• Believing cell lock blocks styling
• Assuming shortcuts don't work

5. You want to highlight all cells in column C that contain the word "Urgent" by making the text bold, italic, and red color. Which method is best to apply this formatting quickly?

hard

A. Manually select each cell and apply styles one by one

B. Change the entire column font to bold, italic, and red

C. Use Conditional Formatting with a formula and set font styles

D. Copy formatting from one cell and paste to others without condition

Solution

1. Step 1: Understand the goal

   Only cells containing "Urgent" in column C should be styled bold, italic, and red.

2. Step 2: Identify efficient method

   Conditional Formatting with a formula lets Excel apply styles automatically to matching cells.

3. Step 3: Why other options are less suitable

   Manual selection is slow, changing entire column affects unwanted cells, and copying formatting lacks condition.

4. Final Answer:

   Use Conditional Formatting with a formula and set font styles -> Option C

5. Quick Check:

   Conditional Formatting = targeted style [OK]

Hint: Use Conditional Formatting for automatic style by condition [OK]

Common Mistakes:

• Applying styles manually to many cells
• Changing whole column unnecessarily
• Copy-pasting without filtering