Spreadsheet Functions and Charts Quiz

Which function is used to find the highest number in a list of values? (1 mark)

• SUM

• AVERAGE

• MAX

• COUNT

What will the formula =AVERAGE(10, 20, 30, 40, 50) return? (1 mark)

• 30

• 50

• 40

• 10

If a spreadsheet has numbers in A1:A10, which formula counts how many cells contain numbers? (1 mark)

• =COUNT(A1:A10)

• =SUM(A1:A10)

• =MAX(A1:A10)

• =AVERAGE(A1:A10)

What does the SUM function do in spreadsheets? (1 mark)

• Finds the largest number

• Adds up all numbers in a range

• Counts the number of cells

• Finds the smallest number

What does the function =MIN(A1:A20) return? (1 mark)

• The smallest number in A1:A20

• The total of all numbers in A1:A20

• The largest number in A1:A20

• The number of non-empty cells in A1:A20

Which function should you use to count all non-empty cells in a range (numbers and text)? (1 mark)

• COUNT

• COUNTA

• SUM

• AVERAGE

Which type of chart is best for showing trends over time? (1 mark)

• Pie chart

• Bar chart

• Line graph

• Scatter plot

True or False: A pie chart is useful for showing proportions of a whole. (1 mark)

• True

• False

Fill in the blank: A ________ chart is best for comparing different categories. (1 mark)

What does the X-axis usually represent in a bar chart? (1 mark)

• Values

• Categories

• Total sum

• Data points