Personal Budget Exercise – MS Excel
Personal Budget Exercise – MS Excel (These instructions are also attached here as a Word document)
Creating a spreadsheet to track personal expenses is an excellent use of Microsoft Excel. For this exercise, you will create a spreadsheet to enter a personal budget and track actual expenses for the year. You may choose to use real data or create a fictitious budget using a monthly income amount of $2,500.
Here are suggested budget categories if you are not using a real budget. At a minimum, you must have 9 budget categories:
Personal Budget Exercise – MS Excel(These instructions are also attached here as a Word document)Creating a spreadsheet to track personal expenses is an excellent use ofMicrosoft Excel.For this exercise, you will create a spreadsheet to enter apersonal budget and track actual expenses for the year.You may choose touse real data or create a ±ctitious budgetusing a monthly income amount of$2,500.Here are suggested budget categories if you are not using a real budget.Ata minimum, you must have 9 budget categories:Housing (mortgage or rent)FoodUtilitiesMisc.Car paymentEntertainmentInsuranceGasStudent LoansSavingsRequirementPointsAllocatedCommentsOpen Excel and save a blank worksheet with thefollowing name:“Student’s First InitialLast Name Excel”Example: JSmith ExcelSet Page Layout to LandscapeIn the worksheet, insert a CustomHeadertitled,“My Household Budget.”0.25Use Print Preview to reviewhow spreadsheet wouldprint.This Custom Header textmust be Arial 14 point,Bold, and be centered onthe page.
RequirementPointsAllocatedCommentsAdd a customFooterwith your name in the RightSection and automatic pagination in the LeftSection.0.25Text format is Arial 10 pointNormal.Enter columnheadings :ITEM, MONTHLY BUDGET,MONTHS – JANUARY THROUGH DECEMBERYou may abbreviate the months as follows: JAN,FEB, MAR, APR, MAY, JUN, JUL, AUG,SEP, OCT, NOV, DEC0.25All column headings mustuse the following textformatting:Arial 10 pointBoldText centered in columnAll capital lettersEnter your personal budget categories/labels(either your own or the list provided) in the rowsunder the column heading ITEM.0.25Text format is Arial 10 point,Normal.Align text Left in the cell.Format all cells containing numeric datatoCurrency, using two decimal places. If you havethis set up correctly MS Excel will automaticallyinsert a “$” in front of the amounts that you enter.0.25I will be able to tell if yousimply typed in the “$.” Thiswill result in zero (0) pointsfor this item. If any otherformat is used besidesCurrency, the score will bezero (0) for this component.In the column under your MONTHLY BUDGETlabel, enter a budget amount for each ITEMcategory.0.25Arial 10 pointBoldAlign text Right in columnEnter the label “Monthly Budget Total:” in the nextrow in the ITEM column. Use the SUM function tocalculate the total amount of the MONTHLYBUDGET column in the cell to the right of thislabel (under the MONTHLY BUDGET values).(This amount should equal your income amountof $2,500.)0.25Use the following formats:Arial 10 pointBoldBlueAlign text Right in the cellUnder the heading foreachMonth,enter anactual expense amountfor that item for thatmonth. (For example, in the winter months, your0.5Use the following textformat:
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
