Spreadsheet Functions Quiz

What does the *Sort* function do in a spreadsheet?

• Deletes duplicate data

• Changes all data to uppercase

• Rearranges data in a specific order

• Adds up all numbers in a column

If you wanted to only show rows with “Norfolk” in a column, which tool would you use?

• Conditional formatting

• Chart

• Filter

• SUM function

Which formula correctly finds the average of numbers in cells B2 to B10?

• =ADD(B2:B10)

• =AVERAGE(B2:B10)

• =TOTAL(B2 to B10)

• =COUNT(B2:B10)

What type of chart is best to show proportions or percentages?

• Bar chart

• Pie chart

• Line chart

• Scatter chart

Which of the following best describes *conditional formatting*?

• A formula to calculate percentages

• A way to sort data

• Changing the colour of a cell based on its value

• A function to change the font

Which formula would count how many times "England" appears in a column?

• =AVERAGE(England)

• =COUNTIF(A:A, "England")

• =FIND("England", A:A)

• =SUM(A:A, "England")

What would be the result of =COUNT(B2:B20)?

• Number of words in range

• Number of empty cells

• Number of cells with numbers

• Sum of all numbers

What happens if you sort a spreadsheet without selecting “My data has headers”?

• Nothing changes

• Header row is sorted like data

• All data gets deleted

• Formulas will be removed

What symbol is used to start a formula in a spreadsheet?

• @

• #

• =

• $

What does the formula =MAX(B2:B100) calculate?

• Smallest number

• Total of all numbers

• Average of the range

• Largest number