NEW
Font size
WorksheetsGr. 6 Final Revision of the 1st Sem. of (2021-2022)
Total questions: 22
Worksheet time: 29mins
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)
To display the month of (B3), which formula should be used?
a) =MONTH(B4)
b) =MONTH(B3)
To display the year of (B5), which formula should be used?
a) =YEAR(B5)
b) =YEAR(2023)
The number of cells that contain value could be calculated as follows:
a) =C3+C4+C7+C8
b) =COUNT(C3:C8)
The number of cells that don't contain any values could be calculated as follows:
a) =COUNTBLANK(C3:C8)
b) =COUNT(C3:C8)
The homeroom teacher of grade 5 wants to classify the students to "Excellent" and "Good" by using their final total, so he set a condition that if the total is greater than 70, then the student's status is "Excellent" but if the total is less than 70, then the student's status is "Good".
Which formula present the mentioned case?
a) =IF(M3>=70, "Excellent", "Good")
b) =IF(M3>70, "Excellent", "Good")
The homeroom teacher of grade 5 wants to classify the students to "Excellent" and "Good" by using their final total, so he set a condition that if the total is greater than or equals to 70, then the student's status is "Excellent" but if the total is less than 70, then the student's status is "Good".
Which formula present the mentioned case?
a) =IF(M3>=70, "Excellent", "Good")
b) =IF(M3>70, "Excellent", "Good")
The homeroom teacher of grade 5 wants to classify the students to "Passed" and "Failed" by using their English marks, so he set a condition that if the total is greater than 5, then the student's status is "Passed" but if the total is less than 5, then the student's status is "Failed".
Which formula present the mentioned case?
a) =IF(C3>5, "Passed", "Failed")
b) =IF(C3<5, "Excellent", "Good")
Select the correct condition:
a) =IF(C4>5, "True", "False")
b) =IF("True", "False",C3>5)
True or False:
By using this formula:
=IF(C6>5, "Passed", "Failed")
The status here is Failed
True.
False.
True or False:
SUM and AVERAGE are the same.
True.
False.
True or False:
“Paint” is a program that enables you to draw.
True.
False.
True or False:
You cannot name the “Untitled” file in “Paint” program.
True.
False.
