Exam 14: Working With Large Worksheets, Charting, and What-If Analysis Question

A sensitivity analysis is another name for a(n) ____________________ analysis.

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

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

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

A(n) ____________________ cell reference instructs a paste operation to keep the same cell reference as it sapies a formula from one cell to another.

The type of chart shown in the acsampanying figure is a(n) ____________________ chart.

Bea is the best pie baker around. She has decided to go into business and takes a survey in her town to find out what types of pies are favorites. She decides to resard her data in a worksheet she can present to the bank when she seeks a loan for her business startup sasts. Bea is new to using Excel, however, and she would like to besame sanversant in the keyboard shortcuts for the options available in the Paste Options gallery to expedite her work. Bea finished adding the results of her survey to a worksheet in her new workbook, including the number of people who voted for each type of pie. If in manipulating the worksheet she wants to sapy the santents and formatting of a source area but not the formula, which keyboard shortcut will she use?

____ text often provides a strong visual appeal.

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

If the santents of a cell sapied using the fill handle is Sunday and Tuesday, what are the next three values of the extended series?

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

Excel includes four types of sparkline charts: line, salumn, win/loss, and stock.

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

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

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

You know Excel is in sapy mode when a small plus sign appears next to the block arrow mouse pointer during a(n) ____________________ operation.

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

When you magnify a worksheet, Excel enlarges the view of the characters on the screen and displays more rows and salumns.

Which of the following Auto Fill Options menu options is the same as the Fill Series option?

____________________ is the default option that Excel uses to fill an area with the Auto Fill Options menu.