Question

St. Thomas School is storing students result in Spreadsheet. Here is a sample :- A B C D E F 1 NAME MARKS (40) Practicals TOTAL PERCENTAGE PASS OR FAIL 2 Mohan Kumar 32 18 3 Rahul Bajaj 20 14 4 Saba Khan 40 15 5 Juhi Singh 29 17 6 Vicky Anand 33 19 i. Write down the formula to calculate Percentage at E2. ii. What should be done to enter the formula for all other students? iii. Which formatting property will be used to depict the result as PASS or FAIL? iv. Give the formula to write the MAX marks out of 40. v. Give formula to find the total marks of Juhi Singh

Answer 1

Explanation:

Thomas School is storing students result in Spreadsheet. Here is a sample :- A B C D E F 1 NAME MARKS (40) Practicals TOTAL PERCENTAGE PASS OR FAIL 2 Mohan Kumar 32 18 3 Rahul Bajaj 20 14 4 Saba Khan 40 15 5 Juhi Singh 29 17 6 Vicky Anand 33 19 i. Write down the formula to calculate Percentage at E2. ii. What should be done to enter the formula for all other students? iii. Which formatting property will be used to depict the result as PASS or FAIL? iv. Give the formula to write the MAX marks out of 40. v. Give

•••••Thank you •••••