
Excel Functions Quiz

Quiz
•
Computers
•
10th Grade
•
Hard

Tak Cheung
Used 2+ times
FREE Resource
21 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
What is the primary purpose of the `SUMIF` function in Excel?
To count cells that meet a criterion
To sum values based on a single criterion
To calculate the average of a range
To apply formatting to cells
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is the correct syntax for the `SUMIF` function?
=SUMIF(range, criteria, sum_range)
=SUMIF(criteria, sum_range, range)
=SUMIF(range, sum_range, criteria)
=SUMIF(sum_range, range, criteria)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In the formula `=SUMIF(A2:A10, ">50", B2:B10)`, what does `A2:A10` represent?
The range of values to sum
The range where the criteria will be applied
The sum range
The result cell
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of these functions is used to sum values based on multiple criteria?
SUM
SUMIF
COUNTIF
SUMIFS
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In the `SUMIFS` function, the order of criteria ranges and criteria must:
Be in any order
Match exactly
Be reversed
Have only one criteria
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The formula `=SUMIF(B2:B20, "East", C2:C20)` will do what?
Sum values in `B2:B20`
Sum values in `C2:C20` where values in `B2:B20` equal "East"
Count cells in `B2:B20`
Return an error
7.
OPEN ENDED QUESTION
3 mins • 1 pt
Which of these formulas calculates the total sales for “Product A” in the “North” region?
Evaluate responses using AI:
OFF
Create a free account and access millions of resources
Similar Resources on Wayground
20 questions
Quiz Spreadsheet (November 2023)

Quiz
•
10th Grade
20 questions
Spreadsheet Formulas and Functions

Quiz
•
9th - 12th Grade
20 questions
Quiz Informatika Kelas VIII

Quiz
•
8th Grade - University
23 questions
ÔN TẬP GIỮA KÌ 2 TIN 9 24-25

Quiz
•
9th Grade - University
25 questions
LATIHAN FUNGSI PROGRAM PENGOLAH ANGKA

Quiz
•
10th Grade
25 questions
Aplikasi Spread Sheet

Quiz
•
10th Grade
20 questions
Visualisasi data

Quiz
•
8th Grade - University
18 questions
Regular Expressions

Quiz
•
8th Grade - Professio...
Popular Resources on Wayground
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
10 questions
Nouns, nouns, nouns

Quiz
•
3rd Grade
10 questions
9/11 Experience and Reflections

Interactive video
•
10th - 12th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
11 questions
All about me

Quiz
•
Professional Development
22 questions
Adding Integers

Quiz
•
6th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
9 questions
Tips & Tricks

Lesson
•
6th - 8th Grade
Discover more resources for Computers
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade
10 questions
1.2 OSI & TCP IP Models Quiz

Quiz
•
10th Grade
20 questions
Digital Citizenship

Quiz
•
8th - 12th Grade
35 questions
Computer Baseline Examination 2025-26

Quiz
•
9th - 12th Grade
13 questions
Problem Solving Process

Quiz
•
9th - 12th Grade
20 questions
Hardware vs. Software Quiz

Quiz
•
7th - 10th Grade
10 questions
Understanding Algorithms with Pseudocode and Flowcharts

Interactive video
•
9th - 12th Grade
19 questions
AP CSP Unit 1 Review (code.org)

Quiz
•
10th - 12th Grade