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]
10 marks
Asked in 2018

Answer

AI Generated Answer

AI is thinking...