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

Panes created using the vertical split bar scroll together horizontally .

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

The _________________________ at the bottom of the Fill Color and Font Color buttons changes to the most recently selected color.

To open the Format Cells dialog box with the Alignment sheet active, click the Format Cells _____.

_________________________ is the default option that Excel uses to fill an area.

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

You can ensure correctness in your _________________________ by carefully checking them using Range Finder.

You can press the CTRL+ACCENT MARK(`)to display the formulas in a worksheet.

In the accompanying figure, the split double arrow mouse pointer _____.

Which of the following is the path to the Goal Seek button?

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 you click a 3-D Pie chart so that all of the slices are selected, you can drag one of the slices to explode it, leaving the remaining slices unexploded.

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

The range of entries that determines the size of the slices in a Pie chart is called the category names.

_________________________ chart formatting is restricted greatly as compared to standard charts.

A(n)_____ chart provides a simple way to show trends and variations in a range of data within a single cell.

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

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