Exam 10: Excel_Module_3

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

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

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

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

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.

The path to the Format Painter button is ____.

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

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

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

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 <= comparison operator means less than or equal to.

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

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

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

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

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 Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it.

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

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

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