Menu
Coddy logo textTech
START LEARNING
flag En iconEnglishdown icon

Grade Book Setup

Part of the Fundamentals section of Coddy's Excel journey — lesson 39 of 42.

challenge icon

Challenge

Beginner

Set up the grade book grid. A1 already says Student, complete the rest:

  1. Headers in row 1: Test 1 in B1, Test 2 in C1, Test 3 in D1
  2. Row 2: Maya in A2, scores 78, 85, 92 in B2, C2, D2
  3. Row 3: Liam in A3, scores 62, 58, 72 in B3, C3, D3
  4. Row 4: Ava in A4, scores 95, 88, 93 in B4, C4, D4

Type the names and headers exactly as shown, the next three lessons build on this grid.

Try it yourself

Sheet1
ABCDEFG
1Student
2
3
4
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