You may not have enough time during the organized lab time to finish this exercise. You will need to go to the U.C. user room at another time to finish it.
Read through page 156. Also read 173-177.
Part 1: Hands-On Exercise 2, pages 157-163
Before step 7, add text box to both of your new chart pages containing "Prepared by: your name. In step 7, print just the Sales Data, Revenue by City, and Revenue by Product pages, not the entire wookbook.
Note: The office assistant button is mislabeled on page 158. It is the button with the question mark at the right end of the standard tool bar. The office assistant may not be available in the UC lab.
Part 2: Create charts showing the amount of a regular monthly regular monthly deposits needed to achieve a retirement goal.
Create a table that shows the regular monthly deposit needed to achieve a retirement fund goal of $500,000. Display the monthly payment for interest rates 0%, 4%, 8%, and 12% and years 4, 8, 12, ..., 40. A working model is available in lab7.xls which can be found on the downloadable file folder. The URL is www://www.cs.plu.edu/pub/faculty/csce115/lab7.xls.) Embed two charts: One should be a line or XY Scatter chart. The other should be a column chart. Create some kind of note that explains that 0% corresponds to the amount deposited. Print the charts as shown in the sample. Then change retirement fund goal to $800,000. You should not have to change the formulas. Print the page again. Also print the formulas.
Part 3: Create a new chart from lab 6 data
Add two new columns to your table created for part II of lab 6 (Who wants to become a millionaire?) entitled "Total payments" and "Total interest". "Total payments" is the amount you actually deposit in the account. "Total interest" is the total interest paid over the years. Create a line chart on its own page that shows the "Total payments" and "Total interest" for each age shown in the table. The chart should have appropriate titles and legends.
Print and turn in the chart, the formatted table and formulas.
Important comment: Please read before beginning this optional part. It takes a reasonable amount resources to run two programs like Excel and Word at the same time. It is suggested that you close unneeded applications and save often in case there are unexpected problems.
Turn in your output printed in part I (three sheets), Part 2 (2 sets of charts and the formula page), and Part 3 (chart, formatted and formula pages). If you did the option, turn in a copy of the memo. Label each page you turn in.
For more information, contact James Brink
brinkje@plu.edu
Last Updated: 3/28/00, corrected 3/28/00