Excel Functions for Students
Authored by Sedat Dinc
Computers
9th Grade
Used 3+ 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
30 sec • 1 pt
What does the COUNTA function do in Excel?
Calculates the average of a range of cells.
Counts only empty cells in a range.
Counts non-empty cells in a range.
Finds the maximum value in a range of cells.
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How would you use COUNTIF to count students with marks above 75?
COUNTIF(A1:A10, ">75")
COUNTIF(A1:A10, "<75")
COUNTIF(A1:A10, ">=75")
COUNTIF(A1:A10, "=75")
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of the SUMIF function in Excel?
To calculate the average of a range of values.
To sum values based on a specified condition.
To count the number of cells that meet a condition.
To find the maximum value in a dataset.
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If a student scored 85, how would you use COUNTIF to check how many scored above that?
COUNTIF(range, "85")
COUNTIF(range, "<85")
COUNTIF(range, ">85")
COUNTIF(range, ">=85")
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What type of data can COUNTA count in a range?
COUNTA can only count numeric values.
COUNTA can count non-empty cells, including text, numbers, logical values, and errors.
COUNTA counts only empty cells.
COUNTA can count only text values.
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you use SUMIF to calculate total marks for students who passed?
=SUMIF(B:B, ">=50")
=SUMIF(B:B, "<=50")
=SUMIF(B:B, "=50")
=SUMIF(B:B, "<50")
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the difference between COUNTIF and COUNTA?
COUNTIF counts based on criteria; COUNTA counts non-empty cells.
COUNTIF counts text cells; COUNTA counts only numeric cells.
COUNTIF counts unique values; COUNTA counts duplicates.
COUNTIF counts all cells; COUNTA counts only empty cells.
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?
Similar Resources on Wayground
20 questions
แบบทดสอบการค้นหาข้อมูล
Quiz
•
6th Grade - University
20 questions
Loans
Quiz
•
8th - 12th Grade
20 questions
Excel Vocabulary and Screen Parts
Quiz
•
8th - 12th Grade
20 questions
dasar komputer
Quiz
•
1st - 10th Grade
18 questions
2.3 Game Documentation
Quiz
•
9th - 12th Grade
11 questions
Microsoft Word
Quiz
•
2nd - 10th Grade
20 questions
UID uCertify Chapter 9 Test
Quiz
•
8th - 12th Grade
20 questions
Intro to coding arduino unit
Quiz
•
9th - 12th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
10 questions
Probability Practice
Quiz
•
4th Grade
15 questions
Probability on Number LIne
Quiz
•
4th Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
6 questions
Appropriate Chromebook Usage
Lesson
•
7th Grade
10 questions
Greek Bases tele and phon
Quiz
•
6th - 8th Grade
Discover more resources for Computers
10 questions
Exploring Digital Citizenship Essentials
Interactive video
•
6th - 10th Grade
14 questions
[AP CSP] JavaScript Programming Quiz
Quiz
•
9th - 12th Grade
10 questions
Understanding Computers and Computer Engineering
Interactive video
•
7th - 12th Grade
37 questions
Python - Tuples, Lists, and List Methods
Quiz
•
9th - 12th Grade
60 questions
MOS Word Home, Insert, Reference Ribbon Basics
Quiz
•
9th Grade