Exam 5: Excel: What-If Analysis, Charting, and Working With Large Worksheets

The underline format underlines only the characters in the cell, rather than the entire cell, as is the case when you assign a cell a bottom border.

You should ____ cells to duplicate entries.

Which of the following formulas contains an absolute cell reference?

____________________ is the default option that Excel uses to fill an area.

Error messages begin with the ____ symbol.

Which comparison operator means "not equal to"?

Which of the following is the path to the Zoom button?

The less than or equal to .

In the accompanying figure, worksheet titles are frozen above and to the left of cell B13.

The NETWORKDAYS function checks a formula for correctness.

When you first enter text, its angle is ____ degrees, and it reads from left to right in a cell.

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

You can select nonadjacent ranges using the SHIFT key.

Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle?

Using the mouse to move or copy cells is called ____.

Which of the following is a suggested decision to make when you plan a workbook?

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

The use of multiple ____________________ charts in the worksheet will provide the user with a visual comparison of the various data items.