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

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.

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

When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899.

The Linked Pictures option in the Paste Options gallery copies an image of the source area as a picture so that a change to the cells in the source area updates the picture in the destination area.

Panes created using the vertical split bar scroll together horizontally .

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

The underline format underlines the entire cell, not just the characters in the cell.

When you rest the mouse pointer over a chart item, such as the legend, Excel displays a chart tip containing the name of the item.

____ text often provides a strong visual appeal.

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

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?

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

When you change a value on which a chart is dependent, Excel immediately redraws the chart based on the new value.

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

You can press the ____ keys to open the Format Cells dialog box.

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

When the Paste Options button is visible, you can use ____________________ to access the paste commands available in the Paste Options gallery.