Case Notes of class 9th

Excel case study
Class-9th
A B C D E F G
1 PID PNAME QTY PRICE T. AMOUNT DISCOUNT LESS AMOUNT
2 101 HDD 100 3000
3 102 SDD 150 2500
4 103 MOUSE 300 300
5 104 PEN DRIVE 150 350
6 105 KEYBOARD 100 400
7




Q1. Find the number of product in A7 cell. Write formula and output.

Ans: =count(A2:A6) Output= 5

Q2. Find total QTY in C7 cell. Write formula and output.

Ans: Sum(C2:c6) output= 800

Q3. Find total Amount in E column. Formula for total amount is QTY*PRICE. Write output.

Ans- =C2*D2

Output: E
T. AMOUNT
30000
375000
90000
52500
40000



Q4. Find discount of 5% on T.AMOUNT in F column. Write output.

Ans: = E2*5%

Output F
DICOUNT
1500
18750
4500
2625
2000



Q5. Find highest price in cell C8. Write formula and output.

Ans. =MAX(D2:D6) output: 3000

Q6. Find average of QTY in C8 Cell. Write formula and output.

Ans: =Average(C2:C6) output:160

Q7. Find less amount in G column. Formula for amount is T. AMOUNT-DISCOUNT.