Excel Module 2 Test Review

A statistical function.

• relative

• AVERAGE

• template

• relative

Allows the user to move or copy data from one cell to another without using the Clipboard

• drag-and-drop method

• $G6

• COUNT

• paste and list arrow

The Excel function that returns the number of cells in a range containing numeric data.

• relative

• $G6

• template

• COUNT

Mixed cell reference.

• relative

• $G$6

• AVERAGE

• $G6

 Predesigned workbook files that contain labels, values, formulas, and formatting.

• template

• Paste list arrow

• $G$6

• AVERAGE

Absolute cell reference.

• $G6

• COUNT

• $G$6

• relative

The type of cell reference used to preserve the relationship to the formula location.

• relative

• template

• Paste list arrow

• AVERAGE

The Excel feature used to selectively copy formulas, values, etc. by choosing options such as “paste formulas only.”

• COUNT

• Paste list arrow

• AVERAGE

• COUNT

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.

Which keyboard shortcut turns on Edit mode?

• [F1]

• [F2]

• [F4]

• [F8]