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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Fills a destination area using the format of the source area; no content is copied.

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

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

Excel allows you to ____________________ the titles so that the titles remain on the screen no matter how far down or to the right you scroll.

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

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

You can select nonadjacent ranges using the SHIFT key.

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

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

George runs a mid-size accounting practice and recently upgraded to Excel 2013. He expects sales to grow in the next few months during tax season. After that, he would like to begin upgrading some of the equipment and furniture for the employees in his office. He will start with the Reception area, which has the most visibility. -In George's Sales Data worksheet,the result for a formula in cell H14 is ######.What should George do?

A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area.

Following the insertion of a row,the Insert Options button lets you select from which of the following options?

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

In a clustered column chart,the names of each column are part of the ____ series.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Keeps a cell reference constant when copying a formula or function.

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?

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

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

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