FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 10: Excel_Module_3

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

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.

A) #NULL!
B) #DIV/0!
C) #N/A
D) #REF!

Correct Answer

verified

Show Answer

Question 2

Essay

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 3

True/False

Review LaterAdd Note

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

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

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

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

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

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

____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.

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

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

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

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

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

Which comparison operator means "not equal to"?

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?

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

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

Which of the following are formatting symbols?

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