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

When working with a large worksheet,you can split the window into ____ panes.

Excel displays the error message ____________________ in cells to indicate a cell reference error in a formula.

If you enter 90 in the Degrees box in the ____ area of the Format Cells dialog box,the text will appear vertically and read from bottom to top in the cell.

Which of the following is not a valid format symbol?

Cell references in a formula are called ____.

You can press the CTRL+ACCENT MARK(`)keys to display the formulas in a worksheet._________________________

With bar charts,you can drag the bar in the chart in one direction or another to change the corresponding value in the worksheet.

-In the accompanying figure,the split double arrow mouse pointer ____.

You can create your own ____________________ fill sequences for use with the fill handle.

Many ribbon commands,galleries,and shortcut keys function as toggles or switches.

A(n)____ chart provides a simple way to show trends and variations in a range of data within a single cell.

When you change a value on which a chart is dependent,Excel immediately ____________________ the chart.

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

The ____________________ option on the Auto Fill Options menu fills the destination area with contents using the format of the source area and does not create a series.

Charts can either be embedded in a worksheet or placed in a separate ____.

Exploding worksheet columns and rows is a useful technique for viewing large worksheets that extend beyond the window._________________________

The range of entries that identifies the major groups for a clustered column chart are called the category names.

You should use a ____ chart to compare values side by side,broken down by category.

If formulas located in other cells reference cells in a deleted row or column,Excel does not adjust these cell references but instead displays the ____ error message.

The ____________________ option on the Auto Fill Options menu fills the destination area using the format of the source area;no content is copied unless the fill is a series.