Excel Formulas and Functions Quiz
Authored by Ryan Trainer
Information Technology (IT)
8th Grade
Used 7+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
24 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of the SUM formula in Excel?
To find the average of a range of cells
To add up all the numbers in a range of cells
To find the maximum value in a range of cells
To subtract one number from another
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you calculate the average of numbers in cells A1 to A5 in Excel?
`=SUM(A1:A5)`
`=AVERAGE(A1:A5)`
`=MIN(A1:A5)`
`=MAX(A1:A5)`
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula would you use to find the smallest number in a range of cells from B1 to B10?
`=SUM(B1:B10)`
`=AVERAGE(B1:B10)`
`=MIN(B1:B10)`
`=MAX(B1:B10)`
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the result of the formula `=5 + 3` in Excel?
2
8
15
53
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If cell C1 contains the number 10 and cell C2 contains the number 5, what is the result of `=C1 - C2`?
5
15
50
2
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula would you use to multiply the values in cells D1 and D2?
`=D1 + D2`
`=D1 - D2`
`=D1 * D2`
`=D1 / D2`
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the result of the formula `=20 / 4` in Excel?
5
24
80
16
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?
