Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the quiz-maker domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/gyanchau/public_html/wp-includes/functions.php on line 6121 Calculate Ledger Sheet in Excel Total Percentage Result and Division - Education Hub Gyanchautari
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”]