Excel Module 3 Quiz 2

The arguments in an IF function are______.

• logical_test

• value_if_true

• value_if_true_false

• value_if_false

Excel allows you to rotate text in a cell counterclockwise by entering a number between -1 degrees and -90 degrees.

• true

• false

The Increase Indent button indents the contents of a cell to the right by three spaces each time you click it.

• true

• false

The Linked Pictures option in the Paste Options gallery copies an image of the source area as a picture so that a change to the cells in the source area updates the picture in the destination area.

• True

• False

A date stamp shows the date a workbook, report, or other document was created or the time period it represents.

• True

• False

A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area.

• true

• false

A cell reference with only one Dollar sign before either the column or the row is called an absolute reference.

• True

• False

The <= comparison operator means less than or equal to.

• True

• False

The path to the Logical button is (FORMULAS tab | Function Library Group).

• True

• False

A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function.

• True

• False