If a formula depends on the value in a cell, you can see what effect it will have if you change the value in that cell. Then, you can copy the value computed by the formula and paste it into another part of the worksheet where it can be compared and charted. This can be done for multiple formulas.
Activity 2.20. Performing What-If Analysis and Using Paste Special
Ms. French can see that a growth rate of 26% each decade will result in a population of more than 2.3 million people by 2040. The city planners will likely ask her what the population might be if it grows at varying rates, for example the highest rate of 36%. Because the formulas are constructed to use the growth rate entered into a single cell, Ms. French can answer these questions quickly by entering different percentages into that cell. To keep the results of each set of calculations so they can be compared, you will paste the results of each what-if analysis into another area of the worksheet.
1. |
In cell A13 type Comparison of Estimates and then press |
2. |
In cells A15:A18 type the following row titles: |
3. |
Select the range B10:F10, click Copy |
4. |
Select the range B11:F11, click Copy |
5. |
Click the Undo button |
6. |
In the displayed Paste Special dialog box, click OK. Click cell C16. Notice on the Formula Bar that the cell contains a value, not a formula. Press Figure 2.48. (This item is displayed on page 747 in the print version) ![]() The estimates based on a 26% growth rate are pasted along with the formatting. |
|
|
7. |
Click cell B8. Type 31.5 and on the Formula Bar, click the Enter button |
8. |
Select the range B11:F11 and then click Copy |
9. |
In cell B8, type 36 and press |
10. |
Use the skills you just practiced to copy the values and formats in the range B11:F11 to the range B18:F18. |
11. |
Press Figure 2.49. (This item is displayed on page 748 in the print version) ![]() Ms. French is now able to answer several what-if questions about the future population of the city and provide a range of population estimates based on the smallest, largest, and medium rates of growth over the past four decades. |
|
|
12. |
Save |
[Page 748 (continued)] Objective 12 Compare Data with a Line Chart |
Windows XP
Outlook 2003
Internet Explorer
Computer Concepts
Word 2003
Chapter One. Creating Documents with Microsoft Word 2003
Chapter Two. Formatting and Organizing Text
Chapter Three. Using Graphics and Tables
Chapter Four. Using Special Document Formats, Columns, and Mail Merge
Excel 2003
Chapter One. Creating a Worksheet and Charting Data
Chapter Two. Designing Effective Worksheets
Chapter Three. Using Functions and Data Tables
Access 2003
Chapter One. Getting Started with Access Databases and Tables
Chapter Two. Sort, Filter, and Query a Database
Chapter Three. Forms and Reports
Powerpoint 2003
Chapter One. Getting Started with PowerPoint 2003
Chapter Two. Creating a Presentation
Chapter Three. Formatting a Presentation
Integrated Projects
Chapter One. Using Access Data with Other Office Applications
Chapter Two. Using Tables in Word and Excel
Chapter Three. Using Excel as a Data Source in a Mail Merge
Chapter Four. Linking Data in Office Documents
Chapter Five. Creating Presentation Content from Office Documents