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

Figure 3-1 In the accompanying figure, drag the Text hand in the Orientation area to the 45 point and to display 45 in the Degrees box.

The paste operation is one of many operations affected by an absolute cell reference.

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

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

The ____ is ideal for returning the worksheet to its original state after you have changed the values in a worksheet to answer a what-if question.

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

Excel allows you to ____, so that Excel displays the titles on the screen, no matter how far down or to the right as you scroll.

The Decrease Indent button decreases the indent by five spaces each time you click it.

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

A simple way to create a date stamp is to use the ____________________ function to enter the system date tracked by your computer in a cell in the worksheet.

Critical Thinking Questions Case 3-1 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 workbook to present to the bank when she seeks a loan for her business startup costs. Naturally, Bea wants a Pie chart in her workbook. She would like each slice to represent the different types of pies she plans to sell and show this on a 3-D Pie chart. Bea has received a suggestion to emphasize the most favorite type of pie. From a design perspective, what should she do to emphasize the apple pie?

To format the legend on the chart, use the ____.

A(n)____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.

If a window is split into four panes, you can drag the center of the four panes in any direction to change the size of the panes.

Critical Thinking Questions Case 3-1 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 workbook to present to the bank when she seeks a loan for her business startup costs. Naturally, Bea wants a Pie chart in her workbook. She would like each slice to represent the different types of pies she plans to sell and show this on a 3-D Pie chart. Bea has completed adding the results of her survey to the worksheets. The types of pies will be on each slice. Which statement is true about the number of people who voted on each type of pie?

The Formula Auditing group on the Formulas tab on the Ribbon also can be helpful when verifying ____________________.

Excel converts all the formulas from ____.

A(n)____________________ message always begins with a number (#)sign.