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

Which of the following is the path to the Increase or Decrease Indent button?

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

The error message #VALUE! indicates the use of an incorrect argument or operand.

With a solid understanding of the requirements document, an understanding of the necessary decisions, and a sketch of the worksheet, the next step is to ____.

____ text often provides a strong visual appeal.

A date stamp shows the date a workbook, report, or other document was created or the period it represents.

____________________ charts allow worksheet users quickly to visualize information in a small chart within a cell.

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

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

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

A Pie chart with one of more slices offset is called a(n)____.