CLASS 2 Excel

Chapter 2: Introduction to Formulas and Functions

Aim

Learn to use basic formulas and functions.

Content

What are formulas and functions?

Difference between formulas and functions.
How to use them in Excel.
How to write basic formulas

Sum:=A1 + B1
Subtraction:=A1 - B1
Multiplication:=A1 * B1
Division:=A1 / B1
Using basic functions

SUM: =SUM(A1:A10)
AVERAGE: =AVERAGE(A1:A10)
MIN: =MIN(A1:A10)
MAX: =MAX(A1:A10)
Relative and absolute references

Explanation of relative (A1) and absolute references ($A$1).
Examples of use in formulas.
Practical exercise

Create a spreadsheet with basic formulas and functions.