ข้อสอบวิชา Excel
Authored by Tawatchai Adithapsathit
English
University
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
5 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which formula is used to find the sum of the range A1 to A10?
=AVERAGE(A1:A10)
=COUNT(A1:A10)
=SUM(A1:A10)
=MAX(A1:A10)
2.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which function is used to find the average of the range B1 to B5?
=SUM(B1:B5)
=AVERAGE(B1:B5)
=COUNT(B1:B5)
=MIN(B1:B5)
3.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
What function should be used to count the number of cells with numbers in the range C1 to C10?
=SUM(C1:C10)
=AVERAGE(C1:C10)
=COUNT(C1:C10)
=COUNTA(C1:C10)
4.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
What function should be used to find the maximum value in the range D1 to D5?
=MIN(D1:D5)
=MAX(D1:D5)
=AVERAGE(D1:D5)
=COUNT(D1:D5)
5.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
What function should be used to find the minimum value in the range E1 to E10?
=MAX(E1:E10)
=MIN(E1:E10)
=AVERAGE(E1:E10)
=SUM(E1:E10)
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?
