Simple Spreadsheet Functions

Write a function to find the average of the cells A1, A2 and A3

(a)  

Which symbol means divide

• +

• -

• *

• /

Which of these functions could be used to add values together?

• AVG()

• +

• *

• SUM()

What is the name of a location that stores a single item of data?

• Row

• Function

• Cell

• Column

Louis wants to calculate his average income over 4 weeks. Which of these functions could he use?

• AVG()

• +

• COUNT()

• SUM()

Look at this screenshot. What is the cell reference of the yellow cell?

(a)  

In a spreadsheet, what is labelled using letters?

• Rows

• Columns

• Cells

• Calculations

What does the * symbol mean?

• Add

• Subtract

• Multiply

• Divide

Which function can tell us how many cells have been filled in

• COUNT()

• AVG()

• SUM()

• *

Write a function that can divide the value of cell C5 by 2.

(a)