Excel - Module 1 and 2 - Getting Started - Working with Formulas

Using the order of precedence for arithmetic operators, these two formulas will calculate the same result: =22/2*5 =22/(2*5).

• true
• false

According to the order of precedence for arithmetic operators, operations contained within parentheses are performed last.

• true
• false

An absolute cell reference changes the cell references when the formula is copied to a new location.

• true
• false

An Excel complex formula uses more than one arithmetic operator.

• true
• false

Arguments are Excel’s built-in formulas.

• true
• false

To print the formulas in a worksheet, click the Formulas tab, then click the Show Formulas button in the Formula Auditing group.

• true
• false

=D8+E8*0.5 is a complex formula.

• true
• false

The cell in which you are working is called the active cell.

• true
• false

You use formulas in Excel to perform calculations such as adding, multiplying, and averaging.

• true
• false

When copying or moving formulas in an Excel worksheet, the default type of cell reference is absolute.

• true
• false