Gr. 6 Final Revision of the 1st Sem. of (2021-2022)

Calculate the sum:

7 + 11 + 5 + 25 + 30 =

• a) 78

• b) 15.6

Calculate the average:

50 + 50 + 50 + 50 =

• a) 50

• b) 200

Select the correct answer for the following equation:

(50 + 50 + 50 + 50) / 10

• a) 155

• b) 20

Select the correct answer for the following equation:

50 + 50 + 50 + 50 / 10

• a) 155

• b) 20

To calculate the total marks of Quiz (3), which formula or formulas could be used?

• a) =SUM(E3:E5)

• b) =SUM(E3,E4,E5)

• c) =E3+E4+E5

• d) All of the above.

To calculate the average of Math marks, which formula or formulas couldn't be used?

• a) =AVERAGE(C4:E4)

• b) =AVERAGE(C4,D4,E4)

• c) =(C4+D4+E4)/3

• d) =C4+D4+E4

To calculate the worst score of the English, which formula or formulas could be used?

• a) =MIN(C3:E3)

• b) =MAX(C3:E3)

To calculate the highest score of Math, which formula or formulas could be used?

• a) =MIN(C4:E4)

• b) =MAX(C4:E4)

To display the date in (B3), which formula should be used?

• a) =TODAY()

• b) =DATE()

To display the day of (B4), which formula should be used?

• a) =DAY()

• b) =DAY(B4)