stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Google Sheets Basic Formula Review Flashcards | StudBud
Explore
/
Google Sheets Basic Formula Review
Google Sheets Basic Formula Review
20 terms
·
StudBud Administration
·
212 plays
Imported from external platform
Flashcards
20 cards
F
Practice quiz
P
Host live
L
Questions
20
Answers
1
What is the Math Operator for a subtraction problem?
+
/
-
*
2
Which formula is written correctly to Divide the contents of B43 by B55?
=B43\B55
=B55xB43
=B 43 / B 55
=B43/B55
3
Columns run ____________________________ in a spreadsheet.
Sideways
Vertically
Horizontally
Backwards
4
Besides the cell, where is the formula displayed?
Name Box
Formula Bar
Formula Box
Name Bar
5
Which formula is written correctly to Divide the contents of B43 by B55?
=B43\B55
=B 43 / B 55
=B55xB43
=B43/B55
6
What is the Math Operator for a division problem?
+
*
\
/
7
Which formula is written correctly to subtract the contents of B43 from B55?
B43+B55
= B 43 - B 55
=B55-B43
=B43-B55
8
What is the Math Operator for an addition problem?
*
-
+
/
9
Premade Formulas are called ___________________ in Google Sheets.
Functions
None of the answers are true
Math Operators
Formulas
10
Math symbols in Google Sheets are know as what?
Math Symbols
Math Operators
Operations
Mathematical Signs
11
A1, B3, C12, & D42 are all examples of a _______________.
Math Operators
Address
Cells
Cell Reference
12
Selecting cells with your mouse is using what method?
Point & Click
Point
Click & Point
Click
13
What is the Math Operator for a multiplication problem?
*
x
/
+
14
Rows run ____________________________ in a spreadsheet.
Backwards
Sideways
Horizontally
Vertically
15
Every formula starts with a __________________.
#
*
=
-
16
To see the answer to a formula after you type it into a cell, click the ____________ key.
Shift
Control
Enter
Space Bar
17
What is the benefit to using cell reference instead of numerical data within the cell?
None of these answers are true
If contents of cell changes, it will automatically update the formula
Both of these answers are true
Less room for error
18
Which formula is written correctly to Multiply the contents of B43 and B55?
=B 43 x B 55
=B43xB55
= B 43 * B 55
=B55*B43
19
What is the Math Operator for a division problem?
/
*
\
+
20
Which formula is written correctly to add the contents of B43 and B55?
=B43*B55
=B43+B55
= B 43 + B 55
B43+B55
