EX_Class(Sum,SumIF,Max,Min,Average)
Authored by Yousra Abdelhamed
Computers
12th Grade
Used 13+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
To find the total marks for Ahmed we need to apply
SUM()
SUMIF()
MAX()
AVERAGE()
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
To find the HIGHEST mark Ahmed scored we need to apply
SUM()
SUMIF()
MAX()
AVERAGE()
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
To find who scored the lowest mark in Arabic we need to apply
SUM()
SUMIF()
MIN()
AVERAGE()
4.
MULTIPLE SELECT QUESTION
1 min • 1 pt
which is same as = A2+A5+A1 (ALL apply)
=25+21+10
=SUM(A1:A5)
=SUM(A1,A2,A5)
NOTMENTIONED
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Find the total for numbers bigger than 15
=SUMIF(A1:A6,"<15")
=SUMIF(A1:A6,"<=15")
=SUMIF(A1:A6,">15")
=sum(A1:A6,15)
6.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Find the total for numbers bigger than 15
=SUMIF(A1:A6,"<15")
=SUMIF(A1:A6,"<=15")
=SUMIF(A1:A6,">15")
=sum(A1:A6,15)
=SUMIF(A1:A6,>15)
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which describe this formula best
=Sumif(E2:E7,">80")
Find the total marks
find the total marks in case of less than 80
find the total marks of Alex in case he scored over than 80
find the total marks of Alex
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
