Excel Calculations

What must all formulas have at the start in Excel?

• A plus sign

• A minus sign

• An equals sign

• A dollar sign

Where does the equals sign go in an Excel formula?

• At the end of the formula

• In the cell where you want the formula answer to appear

• In the middle of the formula

• Outside the cell

How would you write a formula to add 16 and 23 in Excel?

• =16+23

• 16+23=

• +16+23

• 16+23

How would you usually add numbers using cell references in Excel?

• =A3+A4

• A3+A4=

• +A3+A4

• A3+A4

Which sign is used to add numbers in a formula?

• -

• *

• +

• /

What does the formula =B3-B4 do?

• Adds B3 and B4

• Subtracts B4 from B3

• Multiplies B3 and B4

• Divides B3 by B4

How do you represent multiplication in a formula?

• /

• *

• +

What operation does the formula =B3/B4 perform?

• Adds B3 and B4

• Subtracts B4 from B3

• Divides B3 by B4

• Multiplies B3 and B4

What is the first operation to perform according to the order of operations in Excel?

• Exponentiation

• Multiplication or Division

• Parenthesis

• Addition or Subtraction

In the order of operations, which comes first: multiplication or addition?

• Multiplication

• Addition

• They are performed simultaneously

• It depends on the numbers