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 21

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 22

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

The range of entries that identifies the major groups for a clustered column chart are called the category names.

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

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

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

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 2016. 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. -_____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.​

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

Excel includes four types of sparkline charts: line, column, win/loss, and stock.

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

When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.

Excel allows you to ____________________ the titles so that the titles remain on the screen no matter how far down or to the right you scroll.

A date stamp shows the date a workbook, report, or other document was created or the time period it represents.

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

Case 3-1 ​ George runs a mid-size accounting practice and recently upgraded to Excel 2016. 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. -_____ refers to cells not wide enough to display the entire entry.​

The path to the Format Painter button is ____.

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

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

Case 3-1 ​ George runs a mid-size accounting practice and recently upgraded to Excel 2016. 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. -Error messages begin with the _____ symbol.​