Yr 7 Spreadsheets

Which of these is used to visualise information as a picture?

• Pie Chart

• Pizza chart

• Apple chart

• Circle chart

Which of these would you use to add up a range of numbers?

• TOTAL

• ADD

• PLUS

• SUM

You use the MAX function to find:

• The largest value

• The total

• The smallest value

• The first value

What function would you use to find the smallest value?

• MAX

• MIN

• LEAST

• COUNTA

What does the COUNTA function tell you?

• The average

• The largest value

• The number of non-blank cells

• The number of A's

What symbol must you use at the beginning of a cell when you want to use a function or a formula in that cell?

What would be the cell range for the first ten cells of column B: