Excel Functions and Formulas
Authored by ADITYA KALUA
Other
University
Used 20+ 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
What is the formula to add two numbers in Excel?
=PLUS(number1, number2)
=ADD(number1, number2)
=SUM(number1, number2)
=number1 + number2
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you subtract one number from another in Excel?
=A1+B1
=A1*B1
=A1/B1
=A1-B1
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the formula to multiply two numbers in Excel?
=A1^B1
=A1*B1
=A1/B1
=A1+B1
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you divide one number by another in Excel?
You can divide one number by another in Excel by using the subtraction operator (-)
You can divide one number by another in Excel by using the addition operator (+)
You can divide one number by another in Excel by using the division operator (/) or the DIVIDE function.
You can divide one number by another in Excel by using the multiplication operator (*)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the formula to calculate the average of a range of cells in Excel?
=MODE(range)
=MEDIAN(range)
=AVERAGE(range)
=SUM(range)/COUNT(range)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you find the maximum value in a range of cells in Excel?
MAX function
MIN function
AVERAGE function
SUM function
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the formula to find the minimum value in a range of cells in Excel?
=SUM(range)
=MAX(range)
=MIN(range)
=AVERAGE(range)
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
Already have an account?
