Excel Chapter 2

Use the ___ function to display the highest value in a range. 

• MAX
• MIN
• both choices
• none of the choices

Formatting that appears only when the value in a cell meets specific conditions is called ____ formatting

• formula
• arguments
• conditional
• ranging

The AVERAGE function sums the numbers in the specified range and then divides the sum by the number cells with numeric values in the range. 

• True
• False

_____   ____ allows you to select cells for use in a formula by using the mouse

• Order of operations
• Point mode
• Select options
• Argument options

A(n) ____ is a prewritten formula that is built into Excel

• function
• equal sign
• arguments
• order of operations

Conditional formatting is used to average numbers in a data range

• True
• False

The Currency style format can be used with a floating dollar sign.

• True
• False

The order of operations is from left to right.

• True
• False

A blank cell in Excel has the numeric value of -1.

• True
• False

The Currency style format cannot be used with a floating dollar sign.

• True
• False