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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -The default option to fill an area.

The ____________________ option on the Auto Fill Options menu fills the destination area with the contents but without the formatting of the source area.

Which of the following is the path to the Insert Cells arrow?

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 ____ spaces each time you click it.

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 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 copy the contents and formatting of a source area but not the formula, which keyboard shortcut will she use?

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

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

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

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

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

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

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

After shrinking entries to fit in cells, consider using the ____ slider on the status bar to make the entries more readable.

Briefly discuss how Excel modifies cell references when copying and pasting formulas, including an explanation of absolute, relative, and mixed cell references.

AND, OR, and NOT are called ____________________ operators.

Which of the following patterns extends the fill series to 575, 550, 525?

Excel allows you to rotate text in a cell counterclockwise by entering a number between -1 degrees and -90 degrees.

If you drag the fill handle to the left or up, Excel will increment the series rather than decrement the series.

Panes created using the vertical split bar scroll together horizontally.