Excel assignment #3

Be sure to read the blog post Using Grader. You will be completing and submitting your homework assignments for Word, Excel, and Access using the Grader module of myItLab.

This week's homework is done in Microsoft Excel 2010. You must do your work in Excel 2010, not 2007 or 2003. Your textbook packet from the bookstore has a 180 licensed copy of Microsoft Office inside. If you do not have Office 2010 installed on your personal computer, you will need to do your work in one of the labs on campus. You must use a Windows computer, not a Mac, for all of your work in this class.

For the third Excel assignment (Aspen Falls), you will follow the directions in Grader to demonstrate your mastery of the following skills:

• Renaming and recoloring tabs
• Moving sheets withing the workbook
• Entering and formatting dates
• Clearing cell contents
• Grouping sheets and simultaneously editing multiple sheets
• Formatting cells
• Entering formulas
• Entering formulas using data from other sheets
• Creating a chart
• Relocating a chart on a worksheet
• Adding a centered overlay title on a chart
• Modifying alignment of text on primary horizontal axis

Excel homework #3 - City Expenses
Summary Worksheet

Excel homework #3 - City Expenses
Quarter 2 Worksheet

Excel homework #3 - City Expenses
Quarter 3 Worksheet

You must follow the instructions given in Grader very carefully, in order to receive full credit; this assignment is worth a maximum of 30 points.

Due Date:
Monday, October 31st, 8:00am