FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

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

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

Short Answer

Review LaterAdd Note

Review Later

You can ensure correctness in your ____________________ by carefully checking them using Range Finder.

Correct Answer

verified

Show Answer

Question 52

Short Answer

Review LaterAdd Note

Review Later

A(n)____________________ table should be diminished in its formatting so that it does not distract from the main calculations and data in the worksheet.

Correct Answer

verified

Show Answer

Question 53

Multiple Choice

Review LaterAdd Note

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

The arguments in an IF function are ____.

With a three-dimensional chart, you can change the view to better show the section of the chart you are trying to emphasize.

____ refers to cells not wide enough to display the entire entry.

In the accompanying figure, the formula in cell B14 contains an absolute reference.

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

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

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

The ____________________ at the bottom of the Fill Color and Font Color buttons changes to the most recently selected color.

When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899.

George runs a mid-size accounting practice and recently upgraded to Excel 2011.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.If sales reach a certain amount by the end of April, George will purchase a desk, chair, computer, and software upgrade for the receptionist.Otherwise, George will just purchase the desk and chair.How can George determine the best action to take using a Sales Data worksheet?

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

Which of the following patterns extends the fill series to 575, 550, 525?

Panes created using the vertical split bar scroll together horizontally .

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

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

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