Year 7 Spreadsheets recap

Columns are identified with a ______

Rows are identified with...

• A Letter

• A Number

• A Letter followed by a Number

• A Number followed by a letter

Which of the following is an example of a cell reference

• A6

• 6A

• A_6

• A 6

What does the following tool do in Excel?

• Add Borders

• Merge and Center

• Make text bold

• Undo Changes

What do the following tools do in excel?

• Change the size of the cells

• Change the colour of cells

• Add text to cells

• Change the size of text within a cell.

A pre-built formula in excel is called a...

• Function

• Calculation

• Sum

• Mathematical Cell

Conditional formatting is what.

• Formatting cells based on their size

• Formatting cells based on a value

• Formatting cells based on a condition being True

• Formatting cells based on a condition being False

What is stored inside cell B3

• A Label

• A Value

• A Formula

What is the name of this Graph/Chart

• Line

• Bar / Column

• Pie

• Scatter

A ____ chart is used to show changes over time