Font styling (bold, italic, color) in Excel - Practice Problems & Coding Challenges

Challenge - 5 Problems

📊 Formula Result

intermediate

What is the result of applying this font style formula?

You want to make the text in cell A1 bold and red using Excel conditional formatting formula. Which formula will correctly apply the red color and bold font when the value in A1 is greater than 100?

Excel

Use conditional formatting with formula: =A1>100

A Set font color to red and font style to bold in the conditional formatting rule

B Set font color to red only, font style bold is not possible with formulas

C Use formula =IF(A1>100, "bold and red", "normal") in conditional formatting

D Set font style to italic and color blue in conditional formatting

💡 Hint

Conditional formatting can change font style and color based on a formula.

Conditional formatting rules can change font color and style like bold when the formula condition is true. Setting font color red and bold font style together is possible.

❓ Function Choice

intermediate

Which Excel function can change font color directly in a cell?

You want to change the font color of text inside a cell using an Excel formula. Which function can do this?

A FONT.COLOR()

B TEXTCOLOR()

C No Excel function can change font color directly in a cell formula

D COLORFONT()

💡 Hint

Think about whether Excel formulas can change font appearance directly.

Excel formulas cannot change font color or style directly inside a cell. Font styling is done via cell formatting or conditional formatting.

🎯 Scenario

advanced

You want to highlight cells with italic blue font based on a condition

You want to apply italic font style and blue font color to cells in column B where the value is less than 50. How do you do this using Excel features?

A Use VBA macro only, conditional formatting cannot change font style

B Use a formula =IF(B1<50, "italic blue", "normal") in the cell

C Manually select cells and change font style and color, no formula needed

D Use conditional formatting with formula =B1<50 and set font to italic and color blue

💡 Hint

Conditional formatting can change font style and color based on formulas.

Conditional formatting allows setting font style (italic) and color (blue) when the formula condition is true.

📊 Formula Result

advanced

What happens if you apply this conditional formatting formula?

You apply conditional formatting with formula =AND(A1>10, A1<20) and set font to bold and red color. What will be the font style and color of cell A1 if its value is 15?

A Font will be bold and red

B Font will be normal and black

C Conditional formatting will cause an error

D Font will be italic and blue

💡 Hint

Check if the value 15 satisfies the formula condition.

Value 15 is greater than 10 and less than 20, so the condition is true. The font style and color set in conditional formatting will apply.

❓ data_analysis

expert

Analyze font styling impact on readability in a large dataset

You have a large Excel sheet with thousands of rows. You want to highlight all negative numbers in column C with red italic font to improve readability. Which approach is best for performance and clarity?

A Use a VBA macro to loop through each cell and change font style and color

B Apply conditional formatting with formula =C1<0 and set font color red and italic style

C Manually format each negative cell in column C with red italic font

D Add a new column with text "Negative" and filter instead of changing font style

💡 Hint

Think about automatic and efficient ways to format many cells.

Conditional formatting automatically applies font style and color based on the formula and is efficient for large datasets.

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