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 does a COUNTIF function do in excel?

• Counts every value and outputs the result

• Counts each value that meets a criteria and outputs the result

• Counts how many times your spreadsheet has been viewed

• None of the above

Which of the following is a correct example of an IF function.

• IF(A3>A6, "Yes", "no")

• IF A3>A6, "Yes", "no"

• IF(A3>A6) "Yes" "no"

• IF A3>A6("Yes", "No")