stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Formulas Quiz Flashcards | StudBud
Explore
/
Formulas Quiz
Formulas Quiz
14 terms
·
StudBud Administration
·
22 plays
Imported from external platform
Flashcards
14 cards
F
Practice quiz
P
Host live
L
Questions
14
Answers
1
To add cells A4, B8, and C9 what formula would I use?
A4+B8+C9
=A4+B8+C9
2
B3+B5 What is wrong with this formula?
Nothing, it's correct
an equals sign at the beginning
B5 should come first since it is larger
an equals sign at the end
3
Using the names of a cell or the location of the cell is called a
order of operations
simple formula
cell reference
complex formula
4
Cell Reference and Cell Address mean the same thing
True
False
5
All formulas must begin with
cell address
+
=
cell reference
6
To ensure the spreadsheet does the math in the correct order, what should be considered?
complex formulas
cell references
equals sign
Order of operations (PEMDAS)
7
=D10*F6+S10. Which part will be done first?
Multiplication
Addition
8
=(B2+B3)*C9 is an example of a complex formula because there are two types of math taking place
False
True
9
=B2+B3 is an example of a simple formula
False
True
10
Both types of formulas must start with an equals sign
True
False
11
The purpose of using formulas and cell references in a spreadsheet program is
to avoid mathematical errors in your head
to make the formulas easy to update if data changes
all of these
faster and more efficient than typing it into a calculator
12
=(H10-H11)*V16 The multiplication will be done first since it comes first in PEMDAS
True
False
13
R16 is an example of a cell reference
True
False
14
A mathematical calculation with only one type of mathematical operator
cell reference
complex formula
simple formula
spreadsheet
