Borders and shading in Excel - Practice Problems & Coding Challenges

Challenge - 5 Problems

📊 Formula Result

intermediate

What is the effect of applying a thick border to a cell range?

You select cells A1 to C3 and apply a thick border around the entire range using the Borders tool. What will you see?

A A thick border appears only around the outer edge of the selected range.

B A thin border appears around the outer edge, and thick borders inside each cell.

C No border appears because thick borders cannot be applied to multiple cells.

D A thick border appears around each individual cell inside the range.

💡 Hint

Think about how Excel applies borders to multiple cells at once.

When you apply a thick border to a range, Excel places the thick border only around the outside edges of the entire selection, not between individual cells.

🎯 Scenario

intermediate

How to shade alternate rows for readability?

You want to shade every other row in a table to make it easier to read. Which method is best?

A Use Conditional Formatting with a formula like =ISEVEN(ROW()) to apply shading.

B Manually select each alternate row and apply a fill color.

C Apply a thick border to every other row.

D Use the Font Color tool to change text color on alternate rows.

💡 Hint

Think about a way to automate shading based on row numbers.

Conditional Formatting with a formula like =ISEVEN(ROW()) automatically shades every even row, making the table easier to read without manual work.

❓ Function Choice

advanced

Which formula helps to apply shading based on cell value?

You want to shade cells in column B that have values greater than 100. Which Conditional Formatting formula should you use?

A =SUM(B1)>100

B =IF(B1>100, TRUE, FALSE)

C =B1>100

D =B1>=100

💡 Hint

Conditional Formatting formulas must return TRUE or FALSE directly.

The formula =B1>100 returns TRUE when the cell value is greater than 100, which triggers the shading. Using IF or SUM is unnecessary and may cause errors.

❓ data_analysis

advanced

Identifying border styles in a formatted table

You open a spreadsheet where some cells have different border styles. Which border style indicates a cell is part of a header row?

A Cells with a dotted border on all sides.

B Cells with a double bottom border.

C Cells with no borders but shaded background.

D Cells with a thin top border only.

💡 Hint

Headers often have a distinct border style to separate them from data.

A double bottom border is commonly used to separate header rows from the rest of the table, making it visually distinct.

🧠 Conceptual

expert

What happens when you apply shading and borders to merged cells?

You merge cells A1 to C1, then apply a fill color and a border around the merged cell. What is the result?

A Neither fill color nor borders apply to merged cells.

B The fill color applies only to the first cell, and borders appear around each original cell.

C Borders disappear but fill color applies to all merged cells.

D The fill color and border apply to the entire merged cell as one unit.

💡 Hint

Think about how Excel treats merged cells as a single cell.

When cells are merged, Excel treats them as one cell. Applying fill color and borders affects the entire merged area uniformly.