Computer Fundamentals and Applications - Old Questions
Question Answer Details
Write the formula in a spreadsheet package to calculate the following based on given conditions:
- i) Calculate Total marks. [1]
- ii) Calculate Percentage. [1]
- iii) Mark the student with either "PASS" or "FAIL" (Pass Marks 35). [1.5]
- iv) 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"). [1.5]
Answer
AI Generated Answer
AI is thinking...