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

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

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

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

Critical Thinking Questions Case 3-2 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 record her data in a worksheet she can present to the bank when she seeks a loan for her business startup costs.Bea is new to using Excel, however, and she would like to become conversant in the keyboard shortcuts for the options available in the Paste Options gallery to expedite her work.Bea wants to copy the contents and format of a source area but transpose, or swap, the rows and columns.What keyboard shortcut can she use to do this?

The ____________________ option on the Auto Fill Options menu fills the destination area with a series that uses the format of the source area.

In the context of copying a range of cells to a nonadjacent location, an alternative to clicking the Paste button is to press the ____ key.

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

The syntax of the IF function is IF(logical_test), value_if_false, value_if_true) .

The Copy button copies the contents and format of the source area to the Office ____, a temporary storage area in the computer's memory.

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

Discuss how you should format the various elements of a worksheet.

The less than or equal to .

Modified Multiple Choice If the contents of a cell copied using the fill handle is Sunday and Tuesday, what are the next three values of the extended series?

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.

Rotated text allows you to fit more text into a smaller column width.

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

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.

____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.

The path to the Logical button is (FORMULAS tab | Function Library group).

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