EXCEL FORMULAS POP QUIZ
Authored by Chelsey Gilmore
Business
9th - 12th Grade
Used 2+ 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
If the parenthesis is removed, what will 9.5% be multiplied by?
D2 +D3+D4+D5
D5
D2
None
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which response best completes the following statement: A formula is used to
perform calculations or other actions.
find averages.
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Excel follows the ___________________ and first adds the values inside the parentheses.
Order of Operations
Formula Guidelines
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
___________ are often the best way to define which calculations will be performed first in Excel.
Parentheses
Forumlas
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Unlike _________ references, _________ references do not change when copied or filled.
Absolute, Relative
Relative, Absolute
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
An absolute reference is designated in a formula by the addition of a _______ sign.
%
$
&
#
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If you don't want a cell reference to change when copied to other cells, use _________ references
Absolute
relative
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?
