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

The ____________________ function is useful when you want to assign a value to a cell based on a logical test.

Copying, deleting, inserting, and moving ranges of cells have the potential to ____.

In addition to creating a series of values, dragging the fill handle instructs Excel to ____ the format of a cell to a range.

An alternative to increasing the column widths or row heights is to enlarge the characters in the cell to fit the current width of the column.

Discuss using the fill handle (from the Fill Series command on the Auto Fill menu)to create a series.

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

Figure 3-3 In the accompanying figure, the worksheet in the Window is split at the orange double lines.

When you complete a copy, the values and formats in the destination area are replaced with the values and formats of the source area.

Splitting the Excel window into two panes allows you to view all four corners of the worksheet easily.

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

Figure 3-1 In the accompanying figure, the Alignment tab allows you to position data by ____.

Figure 3-4 In the accompanying figure, you know that the Pie chart was rotated because Excel initially positions the chart so that one of the dividing lines between two slices is a straight line pointing to 6:00 o clock.

Viewing the ____________________ version of the worksheet allows you to check the formulas assigned to the range.

AND, OR, and NOT are called ____________________ operators.

The ____________________ Indent button decreases the indent by three spaces each time you click it.