Excel assignment #2

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 second Excel assignment (City Expenses), you will follow the directions in Grader to demonstrate your mastery of the following skills:

• Applying a theme to the workbook
• Wrapping cell text
• Positioning cell contents
• Using AutoSum function
• Creating formulas using absolute cell references
• Copying formulas using the copy handle
• Applying formatting to ranges of cells
• Inserting charts
• Moving charts
• Applying chart layouts
• Adding chart titles
• Formatting chart area
• Adding shape effects to chart elements
• Inserting WordArt
• Formatting worksheets for printing

Excel homework #2 - Aspen Falls
Expenses Worksheet

Excel homework #2 - Aspen Falls
Expenses Chart

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 17th, 8:00am