Excel Module 2 Review

An Excel complex formula uses more than one arithmetic operator.

• True
• False

Using the Cut command completely removes data from its original location, while the Copy command leaves information in its original location.

• True
• False

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

• True
• False

With Auto Fill, dragging the fill handle on a cell copies the cell's contents or continues a series of data into adjacent cells.

• True
• False

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

• True 
• False

When using the Insert Function button or the AutoSum list arrow, it is necessary to type the equal sign.

• True
• False

Which of the following is a complex formula?

• =SUM(B4:B8)
• =AVERAGE(C6:D6)
• =(B4/B8)*10
• =MIN(D5:D7)

Which formula contains a mixed cell reference?

• =(A6+A7)*0.20
• =($A$6+$A$7)*0.20
• =($A$6+A7)*0.20
• =($A6+$A$7)*0.20

In the formula =(G15-G14)*$M$3/4, which mathematical operation is performed first?

• $M$3/4
• (G15-G14)
• (G15-G14)*$M$3
• (G15-G14)/4

In the formula =ROUND(D4:F4,0), what does the zero indicate?

• The number of decimal places in the rounded number
• The number of times the formula should be repeated.
• A null value
• The value for cell F4