Microsoft Office Tutorials and References
In Depth Information
Summarizing data with subtotals
8
Click the Data tab, and in the Data Tools group, click What-If Analysis (
). The What-If
Analysis drop-down menu appears.
The What-If Analysis menu of ers
three options.
9
Select Data Table. Excel displays the Data Table dialog box.
Click the cell where the formula resides to
display it in the Data Table dialog box.
10 Click the Column input cell text box; click cell B2, and then click OK.
Excel displays the monthly payment for each interest rate.
11 Choose File > Save, and then choose File > Close.
Summarizing data with subtotals
If you need a quick summary of data, Excel of ers a tool called automatic subtotals, which are
formulas that Excel automatically adds to a worksheet.
To open the i le you need for this lesson:
1
Choose File > Open and navigate to the Excel07lessons folder.
2
Click excel0705 and then click Open.
3
Select File > Save As. Excel displays the Save As dialog box.
4
In the Save As text box, type excel0705_done and then click Save.
Search JabSto ::




Custom Search