Practice #2: Complex Formulas

What is the mnemonic to remember the order of operations in Excel?

• PEMDAS

• BODMAS

• BEDMAS

• PODMAS

In the formula =(D3+D4+D5)*0.075, what operation is performed first?

• Addition

• Multiplication

• Subtraction

• Division

What is the result of the formula =(45.80+68.70+159.60)*0.075?

• $20.56

• $21.56

• $19.56

• $22.56

Which cell is selected to contain the formula in the example for calculating the subtotal?

• C5

• D6

• B3

• D7

What is the sales tax rate used in the example formula?

• 7.5%

• 5.5%

• 6.5%

• 8.5%

What is the correct formula to calculate the subtotal in the example?

• =B3*C3+B4*C4

• =B3+C3*B4+C4

• =B3*C3*B4*C4

• =B3+C3+B4+C4

What should you do after double-checking your formula for accuracy?

• Press Enter

• Press Shift

• Press Ctrl

• Press Alt