Excel Lesson 4: Using Basic Formulas
Authored by Rebecca Moss
Computers
11th Grade
Used 3+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is not an arithmetic operator?
+
−
*
]
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In Excel, what is the result of =1 + 3 * 2 / 2 - 1?
2
3
4
6
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Per the order of operations, which of the following is calculated first?
.
Addition (+) and subtraction (−) (left to right)
Exponentiation (ˆ)
Percent (%)
Negative number (−)
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following refers to an unnamed range in the current worksheet?
=SUM(C2:E12)
=Q3Expenses!A19
=[Media.xlsx]MasterList!$D$10
=SUM(budget.summary)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following shows a formula for a reference to another worksheet in the same workbook?
=SUM(C2:E12)
=Q3Expenses!A19
=[Media.xlsx]MasterList!$D$10
=SUM(budget.summary)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following shows a formula for a reference to another workbook?
=SUM(C2:E12)
=Q3Expenses!A19
=[Media.xlsx]MasterList!$D$10
=SUM(budget.summary)
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is an acceptable name for a named range?
C7
subtotal_west
subtotal west
subtotal/west
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?
