EXCEL PART2

MS Excel Lecture Part 2

AVERAGE Function

Step 1: Enter 50 in A1
Step 2: Enter 60 in A2
Step 3: Enter 70 in A3
Step 4: In A4 type =AVERAGE(A1:A3)
Step 5: Press Enter

Manual Calculation:
(50 + 60 + 70) ÷ 3 = 180 ÷ 3 = 60
Excel Result: 60

IF Function

Condition: Pass mark is 50

Step 1: Enter 45 in B1
Step 2: In B2 type =IF(B1>=50,"Pass","Fail")
Step 3: Press Enter

Since 45 is less than 50 → Result: Fail

Percentage Calculation

Step 1: Total Marks = 500 (C1)
Step 2: Student Score = 350 (C2)
Step 3: In C3 type =(C2/C1)*100
Step 4: Press Enter

Manual:
350 ÷ 500 = 0.7
0.7 × 100 = 70%
Excel Result: 70%