Understanding Order of Operations in Google Sheets

What is the acronym used to remember the order of operations?

• GEMDAS

• BEDMAS

• PEMDAS

• BODMAS

In the order of operations, which operation is performed first?

• Exponents

• Parentheses

• Addition

• Multiplication

If a formula contains both multiplication and division, how are they processed?

• Multiplication first, then division

• Division first, then multiplication

• From right to left

• From left to right

What should you do if you want to ensure certain operations are performed first in a formula?

• Use parentheses

• Use subtraction

• Use addition

• Use exponents

In the sales tax example, why was the initial formula incorrect?

• Multiplication was performed before addition

• Addition was performed before multiplication

• Parentheses were used incorrectly

• The tax rate was incorrect