Description
Module 2 Excel AYK1 C
You have been introduced to Microsoft Excel and are ready to begin using it to help track your monthly expenses and take charge of your financial destiny. The first step is to create a personal budget so you can see where you are spending money and if you need to decrease your monthly expenses or increase your monthly income.
This assignment includes several Excel skills you must learn
- Creating formulas to add/subtract cell contents into another cell
- Using the Sum() function to total the contents of a column
Excel technical help can be located in several places.
- Tech Plugins 2, 3 and 4 from the textbook
- Microsoft Office Help and Training: https://support.office.com/ (Links to an external site.)
- YouTube videos
Watch the demonstration video in the Excel Directions and Resources link in Canvas. Then download the AYK1_Data_Version.xlsx
file and follow the directions
to modify the file using Excel. Upload the modified file to the link in this assignment.
- Directions and grade weights
- Put your name in cell B3 of the Financial Destiny tab. Format smaller (5)
- Cells E8 and E12 sum the cell above them (0.5)
- Columns E & J calculate the difference between planned and actual (1.5)
- Subtotal rows sum down (1.5)
- Cell J61 adds/sums subtotal rows C & H (1.5)
- Cell J63 adds/sums subtotal rows D & I (1.5)
- Cell J65 adds/sums subtotal rows E & J (1.5)
- Cell J6 is Projected Monthly Income minus Total Projected Cost (0.5)
- Cell J8 is Actual Monthly Income minus Total Actual cost (0.5)
- Cell J10 is Actual Balance minus Projected Balance (0.5)
Save the completed assignment file to your desktop and then upload it to the link in this assignment to be graded.