Thinkabara

📗 Excel for Beginners · Lesson 4 of 10

SUM and AVERAGE

Google Classroom

The SUM and AVERAGE functions in Excel: the total and the average of a range of cells.

The tasks in this lesson

1. The sum of the scores

  1. B8: type =SUM(
  2. Drag from B2 to B7, close the ) and press Enter

💡 B2:B7 means "from B2 to B7".

2. The average

  1. B9: =AVERAGE(B2:B7)

💡 AVERAGE ignores empty cells, so a student who skipped the test does not pull the average down.

3. Everything updates

  1. Maya appealed and got 90: change B4 to 90
  2. Watch the sum and the average change by themselves

💡 This is the power of Excel: change one number and everything is recalculated.

All lessons

  1. ✍️ 1. Typing in cellsCells, typing, fixing and deleting
  2. 🎨 2. Format a tableSelect a range, bold and dollar format
  3. 🧮 3. Your first formulaMultiply, add and subtract between cells
  4. ➕ 4. SUM and AVERAGEThe total and the average of a column
  5. ⬇️ 5. Drag and fillThe fill handle, and $ to lock a cell
  6. 🔢 6. MAX, MIN and COUNTThe most, the least, and how many filled in
  7. 🔀 7. IF: if... then...Pass or fail, and COUNTIF
  8. ↕️ 8. Sort a tableHigh to low, and alphabetical
  9. 📊 9. Your first chartA bar chart and a pie chart
  10. 🏠 10. Project: a family budgetEverything we learned in one sheet