Making spreadsheet cells square

Name:

Date:

Class:

Quick Questions

Shade in the A or B circle for each question.

1. Which setting makes spreadsheet cells look square?

A Column width and row height set to the same size

B Column width and row height set to different sizes

2. By default, spreadsheet cells are wide and short. What must you do to make them square?

A Change the column width and row height so they match

B Type a square shape into each cell

3. Which one will make every column the same width in one go?

A Select all the columns, then set one column width

B Set the width of just column A and hope the rest copy it

4. A spreadsheet has columns that are 64 pixels wide and rows that are 20 pixels tall. Are the cells square?

A Yes, they are both small numbers

B No, the width and the height are different

5. Why do we make the cells square when making pixel art in a spreadsheet?

A So the cells can hold more text

B So a block of cells looks like a pixel grid

Match the Pairs

Draw a line connecting each item on the left to its match on the right.

Left column		Right column
1Column width = 3		ASets how tall the rows are, so every cell in the block is the same height
2Row height = 3		BOnly column A was selected, so just that one column changed. The other columns stay wide and the grid looks uneven.
3To make cells square, the width and height must be the same size		CSelect columns A to T, then set Column width = 3
4Select all the columns first so one width change applies to every column at once		DColumn width = 3, Row height = 3
5Column width = 3, Row height = 10		ESets how wide the columns are, so every cell in the block is the same width
6Select column A, then set Column width = 3		FThe width and height are different sizes, so the cells are rectangles, not squares and the picture looks stretched.

Definitions

column width = row height

Fill in the Blanks

Complete each line of code by filling in the missing parts.

select all _______ set column width = 20 set row height = 20

select all columns set column _____ = 20 set row height = 20

select all rows set column width = 20 set row ______ = 20

set column width = 20 set row height = __

square cell: column width _ row height

Spot the Error

Shade in the letter of the line that contains an error.

Question 1

A Select all the columns

B Set column width to 25

C Set row height to 50

Question 2

A Click the select-all box

B Right-click a column letter

C Set column width to 20

D Set row width to 20

Question 3

A Select all the columns

B Set column height to 30

C Set row height to 30

Question 4

A Click the select-all box

B Right-click a column letter

C Choose Resize rows

D Type 20 as the height

Question 5

A Click the select-all box

B Right-click a column letter

C Choose Resize columns

D Type 20 as the height

Answer Key

Making spreadsheet cells square

Section A: Quick Questions

A — Column width and row height set to the same size

A — Change the column width and row height so they match

A — Select all the columns, then set one column width

B — No, the width and the height are different

B — So a block of cells looks like a pixel grid

Section B: Match the Pairs

Column width = 3 → Sets how wide the columns are, so every cell in the block is the same width

Row height = 3 → Sets how tall the rows are, so every cell in the block is the same height

To make cells square, the width and height must be the same size → Column width = 3, Row height = 3

Select all the columns first so one width change applies to every column at once → Select columns A to T, then set Column width = 3

Column width = 3, Row height = 10 → The width and height are different sizes, so the cells are rectangles, not squares and the picture looks stretched.

Select column A, then set Column width = 3 → Only column A was selected, so just that one column changed. The other columns stay wide and the grid looks uneven.

Section C: Definitions

column width = row height — Set the column width and row height to the same size so each cell is a square. A block of square cells then looks like a pixel grid.

Section D: Fill in the Blanks

select all columns
set column width = 20
set row height = 20

select all columns
set column width = 20
set row height = 20

select all rows
set column width = 20
set row height = 20

set column width = 20
set row height = 20

square cell: column width = row height

Section E: Spot the Error

C — The row height must match the column width (25) so the cells are square. A height of 50 makes tall rectangles.

D — Rows have a height, not a width. The line should be 'Set row height to 20' so it matches the column width.

B — Columns have a width, not a height. The line should be 'Set column width to 30'.

B — To change the row height you right-click a row number, not a column letter. Column letters are for changing the width.

D — Resizing columns sets the width. The line should be 'Type 20 as the width'.