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 31

Multiple Choice

Review LaterAdd Note

Review Later

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

A) IF
B) NOW
C) AND
D) OR

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

The arguments in an IF function are ____.

A) logical_test
B) value_if_true
C) value_if_true_false
D) value_if_false

Correct Answer

verified

Show Answer

Question 33

True/False

Review LaterAdd Note

You can select nonadjacent ranges using the SHIFT key.

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

You can click the Logical button (FORMULAS tab | Function Library group) and click IFERROR to insert the IF function. _________________________

Using the mouse to move or copy cells is called ____.

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

Cell references in a formula are called ____.

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

The path to the Format Painter button is ____.

Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle?

Panes created using the vertical split bar scroll together horizontally. ________________________

____________________ is the default option that Excel uses to fill an area with the Auto Fill Options menu.

The Linked Pictures option in the Paste Options gallery copies an image of the source area as a picture so that a change to the cells in the source area updates the picture in the destination area.

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

The <= comparison operator means less than or equal to.

The ____________________ option on the Auto Fill Options menu fills the destination area with contents using the format of the source area and does not create a series.

Which of the following is not a valid format symbol?

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

You can press the CTRL+ACCENT MARK(`) keys to display the formulas in a worksheet. _________________________