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

The what-if assumptions should not clutter the worksheet, but they should be placed in an easily located portion of the worksheet.

Hiding the ____ will allow a larger portion of the worksheet to be visible.

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

Which of the following is not a valid format symbol?

The color bar at the bottom of the Fill Color and Font Color buttons on the Home tab on the Ribbon changes to the ____ color.

Studies have shown that more than 25 percent of all business worksheets have errors.

Excel displays #REF! in a cell to indicate the cell is a cross reference.

Figure 3-2 In the accompanying figure, the split double arrow mouse pointer ____.

Figure 3-3 In the accompanying figure, to achieve the format for the dollar values, the Currency category was selected in the Format Cells dialog box.

Critical Thinking Questions Case 3-2 George runs a mid-size accounting practice. He has recently upgraded to Excel for some aspects of his business. 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 worksheet, the result for the calculation in cell H14 is ######. What should George do?

When you complete a copy, the values and formats in the destination area are replaced with the values and formats of the ____ area.

Click Microsoft Office in the ____ list to display the Microsoft Office list.

Which comparison operator means "not equal to"?

If the contents of cells copied using the fill handle are 430 and 410, then the next three values of an extended series are: 400, 390, 370.

The ____ button on the Ribbon or the ____ command on the shortcut menu removes cells (including the data and format)from the worksheet.

Figure 3-3 In the accompanying figure, the values that have dollar signs in column H are Currency style with fixed dollar signs.

To freeze both column headings and row titles, select the cell that is the intersection of the column and row titles before you click the ____________________ button on the View tab on the Ribbon.

Excel rotates the chart 10 degrees in a ____ direction each time you click the Increase X Rotation button.