Excel Chapter 3

When you set up a worksheet, you should use cell references in formulas whenever possible, rather than _____ values.

• logical

• constant

• consistent

• calculated

The Copy button copies the contents and format of the source area to the office _____, a reserved place in the computer's memory.

• Ribben

• Clipboard

• Folder

• File

Rotated text also allows you to fit more text into a smaller column width.

• True

• False

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

• True

• False

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

• True

• False

Excel includes four types of Sparkline charts: Line, Column, Win/Lose, and Stock.

• True

• False

You can select nonadjacent ranges using the SHIFT key.

• True

• False

When you rest the mouse pointer over a chart item, such as the legend, Excel displays a chart tip containing the name of the item.

• True

• False

Changing the order of sheets in a workbook allows you to position the most important worksheets first.

• True

• False