Computer Fundamentals and ApplicationsTU Board 2020
Prepare the following spreadsheet:Student Marks RecordABCDEFGHIJHGHSNNameCFALogicMathSo TechEnglishTotalPerResultGradeRankRemarks1Ram4556544445??????2Sham5045534545??????3Hari4644454645??????…
10Prepare the following spreadsheet:Student Marks RecordABCDEFGHIJHGHSNNameCFALogicMathSo TechEnglishTotalPerResultGradeRankRemarks1Ram4556544445??????2Sham5045534545??????3Hari4644454645?????? Conditions: a) Write an appropriate formula to find the total marks of each student. b) Write a formula to find out the percentage of each student. c) Result is "Passed" if the student scores at least 40% marks in each subject. d) Write a formula to calculate the grade of the student based on percentage:
- A for ≥90%
- B for ≥80%
- C for ≥70%
- D for ≥60%
- E for ≥40% e) Write a formula to find the rank of individual students who have passed. f) Write remarks based on the following conditions:
- "Excellent" for Grade A
- "Good" for Grade B
- "Fair" for Grade C
- "Moderate" for Grade D
- "Satisfactory" for Grade E
A worked answer is on its wayMeanwhile, read the Computer Fundamentals and Applications notes for this topic.
Discussion
Loading…
More Computer Fundamentals and Applications questions
Explain the fundamental components of a computer system and their functions.TU Board 20255Define computer memory. Explain memory hierarchy.TU Board 20255What is computer software? Differentiate between a program and software.TU Board 20255What is an Operating System (OS)? Explain different types of OS and give examples of Open Source OS.TU Board 20255What is a Database? Explain its main functions and types with examples.TU Board 20255What is browsing? What is meant by home page of a website? Explain any three Internet protocols.TU Board 20255