Microsoft Excel Ch. 4 Review

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

Date *

YYYY

Last Name *

First Name *

Hour *

MULTIPLE CHOICE

Select the best response for the following statements.

An example of a formula that contains a mixed cell reference. *

____ calculation lets you control when Excel calculates the formulas in a worksheet. *

How do you display formulas instead of formula results in a worksheet? *

The sequence used to calculate the value of a formula is called the ____. *

What type of cell reference will not adjust to its new location when it is copied or moved to another cell? *

In a worksheet formula, which operator has the highest priority in the order of evaluation? *

Default summary calculations for a selected range appear in the ____. *

The cell reference D4 is an example of a(n) ____ cell reference. *

The equation used to calculate values based on numbers entered in cells is called a(n) ____. *

TRUE/FALSE

Choose TRUE if the statement is true or FALSE if the statement is false.

An operator is a constant or cell reference used in formulas. *

TRUE

FALSE

Required

An absolute reference does not change when the formula is copied or moved to another cell. *

TRUE

FALSE

Required

In a formula, operations within parentheses are performed after operations outside parentheses. *

TRUE

FALSE

Required

In a formula, multiplication is performed before subtraction. *

TRUE

FALSE

Required

Manual calculation lets you control when Excel calculates formula results. *

TRUE

FALSE

Required

Submit

Clear form

Never submit passwords through Google Forms.

This content is neither created nor endorsed by Google. - Terms of Service - Privacy Policy

Does this form look suspicious? Report