Calculate and duplicate

Computing

Spreadsheets

Calculations can be used on any data type in a spreadsheet

Data can be calculated using different operations within the spreadsheet

When using formulas with cell references; changing one cell can change another

Which of these statements are true about spreadsheets? (Tick all that apply)

Using the  spreadsheet, which formula is the correct formula to calculate the subtotal for bananas?

3) What does this SUM function calculate?=SUM(A1:A4)

What does this operator mean in a spreadsheet  /  ?

What does this operator mean in a spreadsheet  *  ?

Give the cell reference of the colored cell

The Subtotal column in the spreadsheet section below has been calculated using a formula. Which cell could be changed to change the value shown in D2?

Calculate and duplicate

Lesson outcome