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

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.

The NETWORKDAYS function checks a formula for correctness.

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

The arguments in an IF function are _____.

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

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

Using the accompanying figure, identify the following chart elements: chart sheet, chart title, Pie chart, data series, category names, exploded slice, and data labels.

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

Which of the following formulas contains an absolute cell reference?

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

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 wants to add a 3-D Pie chart to her workbook in which each slice represents the popularity of different types of pies she plans to sell.Bea wants to emphasize that apple pie is the most favorite type of pie.Which of the following is the best design approach to emphasize the apple pie slice?

Which of the following are formatting symbols?

Briefly discuss how to best utilize Sparkline charts and how charts should convey necessary information.

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

In the accompanying figure, the formula in cell B14 contains an absolute reference.

You can click the Logical button (Formulas tab | Function Library group)and click IFERROR to insert the IF function.

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?

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

Studies have shown that more than 25 percent of all business worksheets have errors.

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