Menu
Coddy logo textTech
START LEARNING
flag En iconEnglishdown icon

Recap: Basic Functions

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

challenge icon

Challenge

Easy

Sales figures sit in A2:A5. Next to them, a stats panel is half-built: labels in column B, answers missing in column C.

  1. C2, the Total of the sales
  2. C3, the Average
  3. C4, the Lowest figure
  4. C5, the Highest figure

All four formulas work on the same range, A2:A5. A second dataset will be tested.

Try it yourself

Sheet1
ABCDEFG
1Sales
240Total
325Average
455Lowest
530Highest
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