Excel II
Authored by Anastasia Frecautan
Other
Professional Development
Used 2+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
14 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function is case sensitive?
SEARCH
FIND
LEFT
SUM
2.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
What function to use to get this ->55555 from the initial value -> 55555-End
LEFT
MID
RIGHT
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function uses delimiter as a parameter in its syntaxis?
&
CONCATENATE
CONCAT
TEXTJOIN
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In this image, which formula could you use to subtract the inventory costs from the monthly budget?
=B3-B2
=B3/B2
=SUM(B2:B3)
=B2-B3
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What formula would you use to find the average of the values in cell range A1 to A10?
=AVG(A1:A10)
=AVERAGE(A1:A10)
=TOTAL/A10
=MEAN(A1:A10)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function would you use to add several numeric values?
COUNTA
TOTAL
SUM
AVERAGE
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function can find the highest value in a cell range?
HIGHEST
MAX
MAXVALUE
TOP
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 Microsoft
or continue with
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
