WorksheetsExcel Chapter 3
Total questions: 9
Worksheet time: 5mins
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
