Excel Formula Practice

In the picture, why is D2 through D5 placed in paranthesis?

• So Excel knows to total the cells before performing the next operation.

• So the total of the cells can be multiplied rather than added.

• So the calculation will be done last.

Which response best completes the following statement: A formula is used to

• perform calculations or other actions.

• find averages.

• Look Up data

Excel follows the ___________________ and first adds the values inside the parentheses.

• Order of Operations
• Formula Guidelines

By default, all cell references are _________ references. 

• Absolute
• Relative

An absolute reference is designated in a formula by the addition of a _______ sign before and after the cell reference letter.

• %

• $

• &

• #

If you want a cell reference to change when copied to other cells, use _________ references

• Absolute
• Relative

Which of the following is not an arithmetic operator?

• =

• +

• s

• ^

List the following in order of operations: addition (+), division (/), multiplication (*), subtraction (-).

• /,+,-,*

• *,/,+,-

• ^,s,r,t

Do you need an = sign to start a formula?

• no

• yes

• never

Which symbol must all formula begin with?

• =
• +
• (
• @