Google Sheets: Creating Complex Formulas Quiz

What is the first step in the order of operations in Google Sheets?

• Multiplication and division

• Exponential calculations

• Operations enclosed in parentheses

• Addition and subtraction

Which mnemonic can help you remember the order of operations?

• Please Excuse My Dear Aunt Sally

• My Very Educated Mother Just Served Us Noodles

• Never Eat Soggy Waffles

• Every Good Boy Deserves Fudge

In the formula 5 + 2 * 8, which operation is performed first?

• Addition

• Subtraction

• Multiplication

• Division

What is the result of the formula 3/4*4?

• 12

• 0.75

• 3

• 1

In the example formula =B3*C3+B4*C4, which operation is performed first?

• Addition

• Subtraction

• Multiplication

• Division

What is the result of the formula 10 + 3 - 1?

• 14

• 13

• 11

• 12

What is the purpose of using parentheses in formulas?

• To add comments to the formula

• To define which calculations will be performed first

• To make the formula look complex

• To increase the font size

What is the result of the formula (D3+D4+D5)*0.055 if D3+D4+D5 equals $274.10?

• $289.18

• $15.00

• $274.10

• $15.08

What should you do if Google Sheets does not indicate an error in your formula?

• Ignore it

• Double-check your formula for accuracy

• Assume it's correct

• Re-enter the formula

How do you calculate a 20% discount on a total in Google Sheets?

• Subtract 20 from the total

• Multiply the total by 0.80

• Add 20 to the total

• Multiply the total by 0.20