Spreadsheet Functions: SUM, AVERAGE & More!

• newEditor
• Computing
• Lower Secondary (Key Stage 3)

Spreadsheet Functions: SUM, AVERAGE & More!

What do you already know about spreadsheet functions?

Learning Objective

At the end of the lesson you will know what spreadsheet functions are, how to use SUM, AVERAGE, MIN and MAX, and how to check if your data type is right for calculations.

What Is a Function in a Spreadsheet?

A function is a built-in instruction that helps you do quick calculations or find information in your data. Some common spreadsheet functions are: =SUM(A1:A5) adds up numbers. =AVERAGE(A1:A5) finds the average. =MIN(A1:A5) finds the smallest number. =MAX(A1:A5) finds the biggest number.

Fill in the Blanks

A spreadsheet function is a built‑in ________. The SUM function adds a ________ of numbers. The AVERAGE function finds the ________ value. The MIN function finds the ________ number. The MAX function finds the ________ number. Word bank: highest • instruction • list • lowest • average

Match Each Function

Adds all numbers Finds the mean value Lowest number Highest number

Functions

Meanings

SUM = ? AVERAGE = ? MIN = ? MAX = ?

Quiz: Which Formula Is Correct?

Which formula correctly finds the total of values in cells B2 to B6? A. =TOTAL(B2:B6) B. =ADD(B2:B6) C. =SUM(B2:B6) D. =B2+B3+B4

Sort Data Types for Calculations

5 12.5 £3.50 0

Incorrect

"Banana" "Ten"

Correct

Mini-Challenge!

A student changed a number in their data set but their AVERAGE didn't update. What might have gone wrong? Think about errors with ranges, typing text instead of numbers, or mistakes in the formula.

Exit Ticket

Which function would you use to find the lowest score in a test and why?

Write down 3 things you learned in this lesson.

Write down 2 things you want to know more about.

Ask 1 question about something you haven't quite understood yet.