2. A Spreadsheet has been given below. Find the following:
a) Calculate total with formula
c) Calculate Division as given condition
b) Calculate Percentage with formula
% Greater than 60 div. = first, % Greater than 45 div. = Second, % Greater than 33 div. = Third
Otherwise fail.
А
Roll.
No
1 1
2
3
4
5
B
Name
Anil
Anmol
Manish
Rakha
Rohit
с
Max.
Mark
90
90
90
90
90
D
Hindi
65
56
45
56
68
E
English
54
67
65
76
67
F
Maths
54
43
23
45
56
G
Science
45
34
54
65
67
H
St
67
43
21
34
56
I.T.
23
45
67
45
87
J
Total
K
Per
%
L
Div.
1 1
2
3
4
5
6
Answers
Answered by
0
Answer:
ms excel spreadsheet in computer
Similar questions