excel functions part 1
Authored by Zha Nabor
Computers
9th Grade
Used 11+ 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
which of the following computer task can be best done with MS EXCEL?
edit photos
edit videos
write letters
mathematical computation
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
which formula is used to get the average of certain numbers in excel?
=AVERAGE(1,2,3)
=AVE(CELL RANGE)
=AVERAGE(CELL RANGE)
AVERAGE(CELL RANGE)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does this formula mean?
=SUM(B1:B12)
Get the sum of the cells B1 and B12
Get the sum of the cells from B1 to B12
Get the sum of the cells in B1 plus B12
Get the sum of all the cells except B1 and B12
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which is the correct formula to get the total sum of numbers listed in B2 and B7?
=SUM(B2,B7)
=SUM(B2:B7)
=SUM(B2,B7
=SUM/B2,B7/
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which is the symbol for "divide" in excel?
(
%
/
:
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which is the symbol of "times" (multiplication) in excel?
$
*
@
x
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
To get the proper value for this math equation, what must you type?
5x5=
=5x5
=5/5
5x5=
=5*5
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?
