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

If you accidentally delete valuable data, immediately click the Undo button on the Quick Access Toolbar.

A Pie chart with one or more slices offset is called a(n)____.

Figure 3-3 In the accompanying figure, the months were rotated by selecting the text and dragging the mouse pointer up and to the right.

Using the ____________________ button on the Ribbon, you can format a cell quickly by copying a cell's format to another cell or a range of cells.

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

With some fill operations, you may not want to copy the formats of the source cell or range to the destination cell or range. If this is the case, click the Auto Fill Options button after the range fills and then select the option you desire on the Auto Fill Options menu.

You can replace a formula with its function so it remains constant.

Which of the following is not an Auto Fill option?

Discuss the meaning of freezing titles and what is the advantage of using this technique.

Figure 3-2 In the accompanying figure, if you drag the pointer to the right, a ScreenTip indicates the ____.

When you ____ a worksheet, Excel is able to display more columns and rows.

The ____ function is useful when you want to assign a value to a cell based on a logical test.

With large worksheets that extend beyond the size of a window, it is best to enter titles in the ____.

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

Using Excel to scrutinize the impact of changing values in cells that are referenced by a formula in another cell is called ____.

____________________ are values in cells that can be changed to determine new values for formulas.

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

If you know the result you want a formula to produce, you can use ____ to determine the value of a cell on which the formula depends.

A versatile method of copying a source area is to use the Copy button and Paste button on the Home tab on the ____________________.

When a window is split into panes, scroll bars are available for top and bottom, and left and right panes.