The Complete Excel Guide: Beginners to Advanced - Borders and Shading

This video tutorial covers the use of borders and shading in worksheets. It explains how to apply and customize borders around cells, including options for different styles and colors. The tutorial also demonstrates how to use shading to enhance the appearance of workbooks, with options for fill effects and patterns. Additionally, it shows how to draw custom borders and erase them if needed.

What is the difference between gridlines and borders in a worksheet?

• Borders are automatically applied to all cells.

• Gridlines are thicker than borders.

• Borders are applied to selected cells, gridlines are not.

• Gridlines are visible on printouts, borders are not.

Which option would you choose to remove a border you don't like?

• All borders

• No border

• Thick outside border

• Bottom double border

How can you apply a light blue background to selected cells?

• Use the font color option

• Apply a thick border and change its color

• Use the gridline color option

• Select the shading bucket and choose blue

What must you do after selecting a border style and color to apply it?

• Click on the borders in the preview

• Click OK immediately

• Select the cells again

• Restart the application

What feature allows you to mix two colors in a cell's background?

• Fill effects

• Pattern fill

• Color mixer

• Gradient tool

How can you draw a custom border around cells?

• Use the eraser tool

• Apply a thick outside border

• Use the shading bucket

• Select the draw border option

What tool would you use to erase a drawn border?

• Line color tool

• Eraser border tool

• No border option

• Shading bucket