Calculate Ledger Sheet in Excel Total Percentage Result and Division
This question is TU asked in 2018 in the Computer Fundamental and Application subject of the first semester of BCA, Faculty of Humanities, Tribhuvan University, which we have solved Bellow. And you can also boost up your knowledge. The Question ( Calculate Ledger Sheet in Excel Total Percentage Result and Division ) and solution is provided by gyanchautari.com and for more education notes, notice and other education related contents you can follow our website gyanchautari.com as well as Facebook page and YouTube Channel. Thank you
SN
Name
Eng.
Nep.
Eco
Sociology
Computer
Total
Percentage
Result
Division
11
Gautam
56
56
76
75
68
331
66.2
PASS
First
12
Saru
67
54
64
64
76
325
65
PASS
First
13
Binod
87
65
54
59
66
331
66.2
PASS
First
14
Ritu
45
67
56
72
85
325
65
PASS
First
15
Kabita
89
34
63
59
52
297
59.4
FAIL
Second
Write the formula in spread sheet package to calculate following on basis on given conditions:
1. Calculate Total marks. [1]
2. Calculate Percentage. [1]
3. Mark the student with either “PASS” or “FAIL” [Pass Marks 35]. [1.5]
4. Calculate the division [if percentage >=60 then First, if percentage >=45 and percentage <60 then Second ,
if percentage>=35 and percentage<45 then Third otherwise “xxx”]
