stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Lesson 7 Excel Formulas Flashcards | StudBud
Explore
/
Lesson 7 Excel Formulas
Lesson 7 Excel Formulas
15 terms
·
StudBud Administration
·
648 plays
Quiz over Excel Formulas and Functions. #excel #formulas #functions
Flashcards
15 cards
F
Practice quiz
P
Host live
L
Questions
15
Answers
1
True or False? As you type a formula, it displays in the cell and in the formula bar?
True
False
2
What is the answer to the following Excel equation: =8+3*5
29
23
16
55
3
You must start each formula by typing what sign?
Equal Sign
No Dumping Sign
Peace Sign
Stop Sign
4
If a formula has multiple operators of same precedence level Excel performs the calculations:
Right to Left
Top to Bottom
Front to Back
Left to Right
5
The Mathematical Operation Symbol for Division:
*
+
/
-
6
What is the answer to the following Excel equation: =(8+3)*5
29
16
23
55
7
True or False: In the Order of Precedence, Excel calculates addition before division.
False
True
8
The Mathematical Operation Symbol for Addition:
*
/
-
+
9
What button do you push on the keyboard to use Absolute Reference?
F2
F4
F1
F3
10
Excel performs mathematical operations in a particular order called:
Order of the Arrow
Order of Precedence
Out of Order
Order of Preference
11
In the Order of Precedence, Excel calculates what first?
Addition & Subtraction
Exponentiation
Multiplication & Division
Operations in Parenthesis
12
A worksheet instruction that performs a calculation.
Formula
Exponentiation
Precedence
Excel
13
The Mathematical Operation Symbol for Subtraction:
*
+
-
/
14
You need to edit your formula if you see the following error message:
#DUH
#STOP
#NOPE
#NUM!
15
The Mathematical Operation Symbol for Multiplication:
*
/
+
-
