Spreadsheet Homework 2

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 can you use to help you see only what you want to see by hiding everything else.

• Filters

• Functions

• Sorts

• Charts

What can you use to organise your data by changing the order it appears in.

• Filters

• Functions

• Sorts

• Charts

What is the superpower of the AVERAGE Function

• Counts the number of non blank cells

• calculate averages in an instant

• have a cell show different things depending on a criteria

• count how many cells meet your criteria

What is the superpower of the COUNTIF Function

• Counts the number of non blank cells

• calculate averages in an instant

• have a cell show different things depending on a criteria

• count how many cells meet your criteria

What is the superpower of the IF Function

• Counts the number of non blank cells

• have a cell show different things depending on a criteria

• calculate averages in an instant

• count how many cells meet your criteria