Copyright (c) Newday Com. Ltd. All rights reserved-2001-2008

 Assignment 3: Due Friday, March 28


In this final assignment, you are going to build on the spreadsheet you created in assignments 1 and 2. You will create a pie chart, setup page options definitions, and print the checkbook.

  1. Open your checkbook spreadsheet, YourName_Excel_assignment2.
  2. Create an embedded pie chart showing checks written during the month of January.
  3. Add the title, January's Expenses, to the chart and format the chart title and chart legend.
  4. Next show the actual dollar values paid next to each slice of the pie chart.
  5. Now create an embedded pie chart for February's checks; assign the chart title, February's Expenses, to it.
  6. Format the Chart Legend and Data Series just as you did for January.

    At this point, we have created both a spreadsheet to manage your checkbook and charts to visually show you how your money is being spent.

  7. Select the Checkbook worksheet
  8. Set the Print Margins to print 0.5" from the left and 0.5" from the right. Verify that both the top and bottom margins are 1".
  9. Change the Print Orientation to landscape.
  10. Change the Paper Size to Legal.
  11. Create a Header that shows a page number.
  12. Save the file as YourName_Excel_assignment3 and submit it to your instructor.
Back Next

 Student should make sure to login to class discussion board to view the neccessary information about his or her progress.
 Don,t forget to log out when you are about to leave the class

Students Should not forget to send his or her registration password and User name to
For future refrence.
Student should make sure to subscribe to newsletter of this site for useful information.
 Microsoft Access
 Peachtree Account
 Adobe Photoshop
 Programming
 Café Management
 Repair and Maintenance
 Electronic Basic
 Networking

=> Do you also want a homepage for free? Then click here! <=