📘 LEVEL 2: BASIC CALCULATIONS & FORMULAS


1️⃣ What is a Formula?

📌 Definition

A formula is an instruction given to Excel to calculate something.

👉 Every formula in Excel starts with =

❌ Wrong

A1 + B1

✅ Correct

= A1 + B1


2️⃣ Basic Operators in Excel

Operator Meaning Example Result
+ Addition =5+3 8
- Subtraction =10-4 6
* Multiplication =4*5 20
/ Division =20/4 5

3️⃣ Step-by-Step Example: Simple Calculation

Step 1: Enter Data

Type this in Excel:

Cell Value
A1 10
A2 20

Step 2: Add Numbers