FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

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

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Multiple Choice

Review LaterAdd Note

Review Later

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

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 H)
L) D) and J)

Correct Answer

verified

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

Following the insertion of a row, the Insert Options button lets you select from which of the following options?

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

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

MATCHING 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.

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

Which comparison operator means "not equal to"?

The NETWORKDAYS function checks a formula for correctness.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Indicates a cell that uses a number incorrectly.

Which of the following is not a valid format symbol?

The ____________________ option on the Auto Fill Options menu fills the destination area using the format of the source area; no content is copied unless the fill is a series.

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

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

Discuss how you should format the various elements of a worksheet.

____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.

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

Case 3-1 George runs a mid-size accounting practice and recently upgraded to Excel 2013. He expects sales to grow in the next few months during tax season. After that, he would like to begin upgrading some of the equipment and furniture for the employees in his office. He will start with the Reception area, which has the most visibility. -In George's Sales Data worksheet, the result for a formula in cell H14 is ######. What should George do?

Excel displays the error message ____________________ in cells to indicate a cell reference error in a formula.

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