Menu
Coddy logo textTech
START LEARNING
flag En iconEnglishdown icon

Totals and Averages

Part of the Fundamentals section of Coddy's Excel journey. Lesson 40 of 42.

challenge icon

Challenge

Easy

Extend your grade book with two calculated columns:

  1. Headers: Total in E1 and Average in F1
  2. Column E: each student's total score using SUM, E2 for Maya, E3 for Liam, E4 for Ava
  3. Column F: each student's average using AVERAGE, F2, F3, F4

Use ranges that cover each student's own row of scores. The tests will change some scores, real formulas will follow along, typed-in numbers won't.

Try it yourself

Sheet1
ABCDEFG
1StudentTest 1Test 2Test 3
2Maya788592
3Liam625872
4Ava958893
5
6
7
8
9
10
11
12
13
14

All lessons in Fundamentals

1Meet the Spreadsheet

What Is a Spreadsheet?Cells and ReferencesYour First CellsRows, Columns and the GridRecap: Meet the Grid

4Cell References

Referencing Other CellsFormulas That UpdateChained FormulasRanges from A1 to A10Recap: Cell References

7Decisions with IF

The IF FunctionWriting an IFComparison OperatorsNested IFsRecap: Decisions with IF

2Entering Data

Text and NumbersBuilding a Small TableEditing and Clearing CellsNumbers That Mean SomethingRecap: Entering Data

5Basic Functions

What Is a FunctionThe SUM FunctionThe AVERAGE FunctionMIN and MAXCOUNT and COUNTACombining FunctionsRecap: Basic Functions

8Project: Grade Book

Grade Book SetupTotals and AveragesPass or Fail with IFFinishing the Grade Book

3Your First Formula

What Is a Formula?Writing a FormulaFormulas with CellsArithmetic OperatorsOrder of OperationsRecap: First Formulas

6Working with Text

Joining TextUPPER and LOWERMeasuring Text with LENLEFT, RIGHT and MIDRecap: Working with Text