Skip to content

← Using a Computer, in Practice

Spreadsheets · 52 of 111

Find the average, highest and lowest

Expert guidance

Do this

With marks in B2 to B8, in LibreOffice Calc, Google Sheets or Excel:

  1. =AVERAGE(B2:B8) gives the mean.
  2. =MAX(B2:B8) gives the highest.
  3. =MIN(B2:B8) gives the lowest.
  4. =COUNT(B2:B8) counts how many cells hold numbers.

These read only numbers. Leave a cell empty for a student who was absent, and type 0 only if the mark really was zero.

Why this way

One formula pattern unlocks hundreds of functions. Type = and the first letters, and the program offers a list. Expert guidance.

Do it today

Find your best and worst subjects with MAX and MIN. Three minutes.

Where these facts come from

General information. Menus and apps change, so look for the idea if a button has moved. You use it at your own risk: see our terms. Spotted a mistake, or know something better? Tell us.

← All 111 things to do