Borders and background colors in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the purpose of borders in Google Sheets?

Borders help separate and organize cells visually, making data easier to read and understand.

beginner

How do you add a background color to a cell in Google Sheets?

Select the cell(s), click the paint bucket icon in the toolbar, then choose the color you want.

intermediate

Can you apply different border styles to different sides of a cell?

Yes, you can add borders to the top, bottom, left, or right sides individually with different styles and colors.

intermediate

What is the difference between 'All borders' and 'Outer borders' in Google Sheets?

'All borders' adds lines between every cell in the selection, while 'Outer borders' only adds a border around the outside edges.

beginner

Why might you use background colors in a spreadsheet?

Background colors can highlight important data, group related cells, or make the sheet easier to scan quickly.

Which icon do you click to change a cell's background color in Google Sheets?

A Paint bucket

B Border style

C Font color

D Fill pattern

The paint bucket icon is used to fill cells with background colors.

What does the 'Outer borders' option do?

A Changes the background color

B Adds borders between every cell inside the selection

C Removes all borders

D Adds borders only around the outside edges of selected cells

'Outer borders' adds a border around the outside edges only.

Can you apply different border colors to different sides of the same cell?

A Yes

B No

C Only for background colors

D Only in Excel, not Google Sheets

Google Sheets allows different border colors and styles on each side of a cell.

What is a common use for background colors in spreadsheets?

A Change font size

B Highlight important data

C Add formulas

D Sort data

Background colors help highlight or group important data visually.

How do you remove borders from selected cells?

A Delete the cells

B Change background color to white

C Choose 'None' in the border style menu

D Use the paint bucket icon

Selecting 'None' in the border style menu removes borders from cells.

Explain how to add and customize borders around cells in Google Sheets.

Think about the border icon and the options it offers.

Describe why and how you would use background colors in a spreadsheet.

Background colors help make data easier to see and understand.