EX_Class(Sum,SumIF,Max,Min,Average)
12th Grade
•15 Qs
Similar activities
ÔN TẬP BÀI 3
7th - 12th Grade
•16 Qs
Spreadsheet
8th Grade - University
•20 Qs
Nintendo Wii
3rd Grade - Professional Development
•20 Qs
Unpuzzled ASCII
7th - 12th Grade
•15 Qs
Symbols & Num. Keypad
1st - 12th Grade
•10 Qs
Bài thực hành 2 Viết chương trình để tính toán
1st - 12th Grade
•12 Qs
Microsoft Excel
KG - Professional Development
•20 Qs
Herramientas de Google
12th Grade - University
•15 Qs
EX_Class(Sum,SumIF,Max,Min,Average)
Quiz
•
Computers
•
12th Grade
•
Practice Problem
•
Hard
Yousra Abdelhamed
Used 13+ times
FREE Resource
Enhance your content in a minute
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
Create a free account and access millions of resources
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?
Similar Resources on Wayground
14 questions
C++ - Loops and Random Numbers
Quiz
•
9th - 12th Grade
16 questions
Introduction to Programming Vocabulary
Quiz
•
9th - 12th Grade
10 questions
กลุ่มงานบริหารงานบุคคล
Quiz
•
7th - 12th Grade
20 questions
Himpunan Data Terstruktur Kelas 7
Quiz
•
12th Grade
20 questions
Excel Spreadsheet Fun (2nd)
Quiz
•
10th - 12th Grade
14 questions
BÀI 14- THUẬT TOÁN TÌM KIẾM TUẦN TỰ
Quiz
•
6th Grade - University
20 questions
Python básico
Quiz
•
9th - 12th Grade
20 questions
Bài 9 - Báo cáo
Quiz
•
12th Grade
Popular Resources on Wayground
5 questions
This is not a...winter edition (Drawing game)
Quiz
•
1st - 5th Grade
15 questions
4:3 Model Multiplication of Decimals by Whole Numbers
Quiz
•
5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
The Best Christmas Pageant Ever Chapters 1 & 2
Quiz
•
4th Grade
12 questions
Unit 4 Review Day
Quiz
•
3rd Grade
10 questions
Identify Iconic Christmas Movie Scenes
Interactive video
•
6th - 10th Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
Discover more resources for Computers
15 questions
Internet Vocabulary Notebook Check #2 - CTEA(2024)
Quiz
•
12th Grade
11 questions
Internet Terms Vocabulary- Notebook Check #1- CTEA
Quiz
•
12th Grade
50 questions
Money Matters Fall 2025 Final Exam — Worksheet Questions
Quiz
•
12th Grade
47 questions
CSF Final Exam Practice
Quiz
•
9th - 12th Grade