Using functions in Excel
Authored by Stephen Langford
Information Technology (IT)
7th Grade
Used 7+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Any function in Excel begins with...
=
@
DO
#
2.
MATCH QUESTION
45 sec • 1 pt
Match each function with what it does
Finds the highest value
MIN
Finds the total of the values
ROUND
Finds the lowest value
MAX
Finds the mean of the values
SUM
Rounds the value (to decimal places)
AVERAGE
3.
MATH RESPONSE QUESTION
45 sec • 1 pt
What is the result of
= SUM(A1 : A3)
Mathematical Equivalence
ON
4.
MATH RESPONSE QUESTION
45 sec • 1 pt
What is the result of
= AVERAGE(A1 : A3)
Mathematical Equivalence
ON
5.
MATH RESPONSE QUESTION
30 sec • 1 pt
What is the result of
= MAX(B1 : B4)
Mathematical Equivalence
ON
6.
MATH RESPONSE QUESTION
30 sec • 1 pt
What is the result of
= MIN(B1 : C4)
Mathematical Equivalence
ON
7.
MATH RESPONSE QUESTION
30 sec • 1 pt
What is the result of
= ROUND(C3,1)
Mathematical Equivalence
ON
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?
