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

Figure 3-1 In the accompanying figure, if you prefer, you can type the number of degrees in the Orientation box instead of dragging the Text hand.

Figure 3-3 In the accompanying figure, the only cells that you should change when performing what-if analysis are those in the what-if portion of the worksheet.

When a number is entered with a format symbol, Excel immediately displays it with the assigned format.

Error messages always begin with what symbol?

Methods for moving cells are drag and drop and cut and paste.

The dollar sign ($), comma (,), and percent sign (%)are called ____________________ symbols.

In accounting, ____________________ numbers often are shown with parentheses surrounding the value

Before creating a worksheet, you should have a good understanding of the ____________________ document.

Unless you first select a range of cells or an object before starting the spell checker, Excel checks the selected ____.

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. 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 should George determine this in the worksheet?

When you change a value on which a chart is dependent, Excel ____.

You can ensure correctness in your formulas by carefully checking them using ____.

Figure 3-2 In the accompanying figure, the width of column A changes if you double-click the split double arrow mouse pointer

An alternative to increasing the column widths or row heights is to ____ to fit the current width of the column.

Figure 3-1 In the accompanying figure, if you enter 90 in the Degrees box in the Orientation area, the text will appear ____.

A formula using the ____ cell reference B20 instructs Excel to adjust the cell reference as it copies it to the destination area.

Figure 3-2 A split double arrow mouse pointer, as shown in the accompanying figure, can be used to widen a column.

Use a(n)____________________ chart to show the relationship or proportion of parts to a whole

Freezing worksheet titles is a useful technique for viewing large worksheets that extend beyond the window.