Calculate Ledger Sheet in Excel Total Percentage Result and Division

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”]

YouTube Video of This Question

You may also visit on this link