Borders and shading in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to add a border around the selected cells.

Excel

Selection.Borders.LineStyle = [1]

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

AxlContinuous

BxlNone

CxlDash

DxlDot

Attempts:

3 left

💡 Hint

Common Mistakes

Using xlNone removes borders instead of adding them.

Choosing xlDash or xlDot creates dashed or dotted borders, not solid.

The xlContinuous style adds a solid border around the selected cells.

2fill in blank

medium

Complete the code to shade the selected cells with a yellow background color.

Excel

Selection.Interior.Color = [1]

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

ARGB(255, 255, 0)

BRGB(255, 0, 0)

CRGB(0, 255, 0)

DRGB(0, 0, 255)

Attempts:

3 left

💡 Hint

Common Mistakes

Using red or blue RGB values instead of yellow.

Confusing the order of RGB parameters.

The RGB(255, 255, 0) function sets the color to yellow for shading.

3fill in blank

hard

Fix the error in the code to apply a thick border to the bottom edge of the selected cells.

Excel

Selection.Borders(xlEdgeBottom).Weight = [1]

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

AxlMedium

BxlThick

CxlThin

DxlHairline

Attempts:

3 left

💡 Hint

Common Mistakes

Using xlThin or xlMedium which are thinner than thick.

Using xlHairline which is very thin.

The xlThick constant applies a thick border weight to the bottom edge.

4fill in blank

hard

Fill both blanks to set the font color to red and apply a dashed border style to the selected cells.

Excel

Selection.Font.Color = [1]
Selection.Borders.LineStyle = [2]

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

ARGB(255, 0, 0)

BxlContinuous

CxlDash

DRGB(0, 0, 255)

Attempts:

3 left

💡 Hint

Common Mistakes

Using continuous border style instead of dashed.

Using wrong RGB values for red.

Use RGB(255, 0, 0) for red font color and xlDash for dashed borders.

5fill in blank

hard

Fill all three blanks to apply a green fill color, set the border color to blue, and use a dotted border style.

Excel

Selection.Interior.Color = [1]
Selection.Borders.Color = [2]
Selection.Borders.LineStyle = [3]

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

ARGB(0, 255, 0)

BRGB(0, 0, 255)

CxlDot

DxlContinuous

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up RGB values for green and blue.

Using continuous border style instead of dotted.

Green fill uses RGB(0, 255, 0), blue border color uses RGB(0, 0, 255), and dotted border style is xlDot.