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

The underline format underlines the entire cell,not just the characters in the cell.

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

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

To open the Format Cells dialog box with the Alignment sheet active,tap or click the Alignment Settings ____.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.NOW function f.#NAME? b.Fill Formatting Only g.Keep Source Formatting c.goal seeking h.Fill Series d.what-if analysis i.IF function e.NUM! j.absolute cell referencing -The default option to fill an area.

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

After shrinking entries to fit in cells,consider using the ____ slider on the status bar to make the entries more readable.

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

Which of the following is the path to the Insert Cells arrow?

The ____________________ option on the Auto Fill Options menu fills the destination area with a series of months using the format of the source area.

Which of the following Auto Fill Options menu options is the same as the Fill Series option?

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

You can select nonadjacent ranges using the SHIFT key.

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

When Excel cannot calculate a formula,it displays an error message in a cell.

You know Excel is in Copy mode when a small plus sign appears next to the block arrow mouse pointer during a(n)____________________ operation.

A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.NOW function f.#NAME? b.Fill Formatting Only g.Keep Source Formatting c.goal seeking h.Fill Series d.what-if analysis i.IF function e.NUM! j.absolute cell referencing -Assigns a value to a cell based on a logical test.

Which comparison operator means "not equal to"?