FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

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

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

-In the accompanying figure,the split double arrow mouse pointer ____.

A) indicates a hidden column
B) allows text to be entered at that location
C) is the result of moving the mouse pointer to the boundary between column heading A and column heading B
D) indicates the proposed width of column A

E) B) and D)
F) A) and C)

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

Identify the letter of the choice that best matches the phrase or definition. -Keeps a cell reference constant when copying a formula or function.

A) NOW function
B) Fill Formatting Only
C) goal seeking
D) what-if analysis
E) NUM!
F) #NAME?
G) Keep Source Formatting
H) Fill Series
I) IF function
J) absolute cell referencing

K) A) and I)
L) B) and H)

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

Cell references in a formula are called ____.

You can create your own ____________________ fill sequences for use with the fill handle.

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

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

Identify the letter of the choice that best matches the phrase or definition. -Pastes the contents,format,and styles of the source area.

When you change a value on which a chart is dependent,Excel immediately ____________________ the chart.

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

When working with a large worksheet,you can split the window into ____ panes.

Identify the letter of the choice that best matches the phrase or definition. -Scrutinizes the impact of changing values in cells that are referenced by a formula in another cell.

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

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

You use the ____ sheet in the Format Cells dialog box to position data in a cell by centering it,for example.

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

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

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

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

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

Identify the letter of the choice that best matches the phrase or definition. -Assigns a value to a cell based on a logical test.