Bright Tutorials Bright Tutorials
CBSE Class 9 Computer Applications Question 2 of 39

Microsoft Excel 2010 - I — Question 2

Back to all questions
2
Question

Question 2

Mayur could not complete the assignment given by his teacher which is shown below. Help him to fill the blank cells marked with yellow colour.

Mayur could not complete the assignment given by his teacher which is shown below. Help him to fill the blank cells marked with yellow colour. Computer Applications Code 165 Kips Cyber Beans Solutions Class 9 CBSE.
Answer

Mayur can use formulas to calculate the values of the blank cells. Let us assume that "R. No." has the cell reference A1 and write the formulas accordingly.

  1. To calculate Total, he can write the formula = C2 + D2 in cell E2. This formula will calculate the sum of cells C2 and D2 in cell E2. The formula can be copied in range E3 : E6 to fill the Total column.

  2. To calculate Percentage, he can write the formula = (E2 / 100) * 100 in cell F2. This formula will calculate the percentage of marks in cell F2. The formula can be copied in range F3 : F6 to fill the Percentage column.

  3. To fill the Remarks column, Mayur can write the formula = IF (F2 >= 40, "Pass", "Fail") in cell G2. This formula will return "Pass" if the percentage is greater than or equal to 40, else return "Fail". The formula can be copied in range G3 : G6 to fill the Remarks column.