Excel Review
Authored by Laura Miley
Business
10th Grade
Used 23+ 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
45 sec • 1 pt
What is the formula to calculate the average of a set of numbers?
=MEAN
=AVERAGE
=AVG
=COUNTA
2.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
What is the formula to find the highest value in a set of cells?
=HIGH
=HIGHEST
=MAXIMUM
=MAX
3.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
What is the correct way to write cells A1 through C10?
A1-C10
A1:C10
A1,C10
A1;C10
4.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
What is the correct way to write cells A1 AND C10?
A1,C10
A1&C10
A1;C10
A1 and C10
5.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
Which tabs do you find the AutoSum (Σ) function on? PICK TWO
Home
Insert
Page Layout
Formulas
6.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
What is it called when an equation remains constant no matter where it is copied to?
Constant Cell Reference
Relative Cell Reference
Same Cell Reference
Absolute Cell Reference
7.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
You have a ranged table from B2:D8 named "Sales". How would you reference this range in an equation? (Pick 2)
=sum(B2:D8)
=sum(B2:D8,Sales)
=sum(Sales)
=sum(B2Sales)
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?
