Year 8 - Spreadsheets - L6

Why might we add shapes and images to a spreadsheet?

• To use more memory.

• To distract the user.

• To keep the spreadsheet interesting.

• To waste time.

How could we add data validation to a spreadsheet in Microsoft Excel/Google Sheets?

• From the home tab/formatting menu.

• From the data tab/menu.

• From the view tab/menu.

• From the formulas tab/menu.

How do we add conditional formatting to a spreadsheet in Microsoft Excel/Google Sheets?

• From the home tab or formatting menu.

• From the data tab/menu.

• From the insert tab/menu.

• From the formulas tab/menu.

Which of these refer to a collection of cells?

• A workbook

• An Excel

• A worksheet

• A formula

Which of these refer to a collection of worksheets?

• A workbook

• An Excel

• A worksheet

• A formula

To change a cell's formatting based on it's value is known as?

• Data Validation

• Formula

• Formatting Cells

• Conditional Formatting

To restrict the values entered into a cell to a selection from a list is known as?

• Data Validation

• Formula

• List Selection

• Conditional Formatting

What formula must be written in cell G6 to divide cell C3 by C6?

• =C3/C6

• ="C3"/"C6"

• C3/C6

• "C3"/"C6"

What symbol can we use to make a cell reference absolute?

• £

• %

• $

• ^

When a cell reference is locked so that it does not move with the formula it is known as?

• An absolute reference

• A relative reference

• A locked reference

• A non moving reference