Spreadsheet Final Test
Authored by imam ibrahim
Information Technology (IT)
8th Grade
Used 1+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
29 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function is used to add numbers in a range?
=ADD(A1:A5)
=SUM(A1:A5)
=TOTAL(A1:A5)
=COUNT(A1:A5)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What will =AVERAGE(10, 20, 30) return?
20
30
15
25
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function returns the smallest number in a range?
=MAX(A1:A10)
=MIN(A1:A10)
=LOW(A1:A10)
=AVERAGE(A1:A10)
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If cells A1 to A5 contain 5, 8, 2, 10, 7, what is the result of =MAX(A1:A5)?
10
7
5
8
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function counts only numeric values in a range?
=COUNTA(A1:A10)
=COUNT(A1:A10)
=COUNTNUM(A1:A10)
=SUM(A1:A10)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If cells A1 to A3 contain: 4, 6, "Hello", what is the result of =COUNTA(A1:A3)?
2
3
4
Error
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the correct formula to find the average of cells B1 to B4?
=AVG(B1:B4)
=AVERAGE(B1:B4)
=MEAN(B1:B4)
=SUM(B1:B4)/COUNT(B1:B4)
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?
