Assignments

Unit 6 Overview 
Microsoft Excel 2010 – Exploring Formulas and Functions
One reason Excel (and other spreadsheet applications) has become so essential for business and personal use is because you can ask what if? What if I got a raise or acquired less expensive housing? How would that affect my financial life? 
In this unit you will learn how to create Excel formulas to use the data to gather valuable information

Outcomes
After completing this unit, you should be able to: 
•	Create Excel formulas
•	Utilize Excel functions
Course Outcome practiced in this unit: 
GEL-2.3: Solve real-world problems using mathematical skills

What do you have to do in this unit?
•	Complete all assigned readings 
•	Check for new announcements 
•	Participate in the discussion board 
•	Complete the Unit Assignment 
•	Attend the Live Audio Seminar or complete Flexible Learning Activity Quiz

eGuide Reading for this Unit: 
Unit 6 eGuide: Exploring Formulas and Functions 
Our eGuide focuses on the basic mathematical functions and formulas in Excel 2010. Specifically this week we will concentrate on creating formulas, learning about absolute and relative cell references, and using built in functions.

Assignment Instructions: 
Scenario Part 1 
You have decided that it might be a good idea to create a personal household budget. You want to be able to save money to purchase a house after you graduate. You decide to create a personal budget. You may either gather your pay stubs and the bills you pay each month or create fictional expenses to complete this assignment. 
Scenario Part 2 
Once you have all the appropriate budget data added to your workbook, you want to analyze it to determine how much your expenses are each month and year, as well as how much you make per year, to determine if you are spending too much and where you are spending it.
Deliverables: Submit one Microsoft Excel 2010 document that contains both part 1 and 2 of this assignment. Save the workbook as Unit_6_Lastname.xls and submit to the Unit 6: Assignment Dropbox by 11:59 pm (EST) Tuesday night.
This is a summary of your assignment. Please click on the Rubric icon (below) for full details and grading criteria.