FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

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

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 32

Short Answer

Review LaterAdd Note

Review Later

A sensitivity analysis is another name for a(n)____________________ analysis.

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

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

Cell references in a formula are called ____.

A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination 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.

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

You can select nonadjacent ranges using the SHIFT key.

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 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 ____________________ option on the Auto Fill Options menu fills the destination area with a series that uses the format of the source area.

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

In the context of copying a range of cells to a nonadjacent location,an alternative to clicking the Paste button is to press the ____ key.

You can specify the style and color for the parts of a sparkline chart by selecting a style in the Styles group on the ____________________.

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

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

Which of the following patterns extends the fill series to 525,475,425?​

Excel allows you to rotate text in a cell counterclockwise by entering a number between -1 degrees and -90 degrees.

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.

The underline format underlines the entire cell,not just the characters in the cell.