Exam 10: Excel_Module_3

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

Which comparison operator means "not equal to"?

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

Text in a cell can be rotated counterclockwise by entering a number in the Alignment sheet in the Format Cells dialog box. Which of the following are valid values for that number?

A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area.

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

You should use a ____ chart to compare values side by side, broken down by category.

The Increase Indent button indents the contents of a cell to the right by three spaces each time you click it.

When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.

If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ____ error message.

The path to the Logical button is (FORMULAS tab | Function Library group).

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

Which of the following are formatting symbols?

A(n) ____________________ cell reference instructs a paste operation to keep the same cell reference as it copies a formula from one cell to another.

Exploding worksheet columns and rows is a useful technique for viewing large worksheets that extend beyond the window. _________________________

Charts can either be embedded in a worksheet or placed in a separate ____.

The ____________________ option on the Auto Fill Options menu fills the destination area with the contents but without the formatting of the source area.

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

____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another 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.