Recall & Review
beginner
What symbol is used for addition in Google Sheets formulas?
The plus sign
+ is used for addition. For example, =A1 + B1 adds the values in cells A1 and B1.Click to reveal answer
beginner
How do you multiply two numbers in Google Sheets?
Use the asterisk
* symbol. For example, =A1 * B1 multiplies the values in cells A1 and B1.Click to reveal answer
beginner
What does the formula
=A1 / B1 do?It divides the value in cell A1 by the value in cell B1. The slash
/ is the division operator.Click to reveal answer
beginner
Which operator is used for subtraction in Google Sheets?
The minus sign
- is used for subtraction. For example, =A1 - B1 subtracts the value in B1 from A1.Click to reveal answer
intermediate
What is the result of
=2 + 3 * 4 in Google Sheets and why?The result is
14. Google Sheets follows order of operations, so it multiplies 3 * 4 = 12 first, then adds 2 + 12 = 14.Click to reveal answer
Which symbol is used for multiplication in Google Sheets?
✗ Incorrect
The asterisk
* is the multiplication operator in Google Sheets.What does the formula
=A2 - B2 do?✗ Incorrect
The minus sign
- subtracts the value in B2 from A2.What is the result of
=10 / 2?✗ Incorrect
The slash
/ divides 10 by 2, resulting in 5.Which formula correctly adds values in cells A1 and B1?
✗ Incorrect
The plus sign
+ adds the values in A1 and B1.What is the correct order of operations in Google Sheets?
✗ Incorrect
Google Sheets follows standard math order: Multiplication and Division first, then Addition and Subtraction.
Explain how to use the four basic arithmetic operators in Google Sheets with examples.
Think about how you write math on paper and how that translates to formulas.
You got /5 concepts.
Describe how Google Sheets handles the order of operations in a formula like =2 + 3 * 4.
Remember PEMDAS or BODMAS rules from school math.
You got /3 concepts.