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

The less than or equal to .

Which of the following is an extension of the fill pattern Sunday, Tuesday?

_____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.

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

The _____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled.

You can ensure correctness in your formulas by carefully checking them using _____.

You can nest IF functions as deep as you want, but after you get beyond a nest of three IF functions, the logic becomes difficult to follow.

_________________________ are values in cells that can be changed to determine new values for formulas.

When you change a value on which a chart is dependent, Excel immediately redraws the chart based on the new value.

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