plz help me with this attach file.
plz help me with this attach file………………………..
Personal Budget Exercise – MS ExcelFor a review of the complete rubric used in grading this exercise, click on theAssignments tab, then on the titlePersonal Budget (Excel)click on ShowRubrics if the rubric is not already displayed.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 budget using a monthly income amount of$3,500Here are suggested budget categories if you are not using a real budget.Ata minimum, you must have 9 budget categories:Housing (mortgage or rent)FoodUtilitiesMiscellaneousCar paymentEntertainmentInsuranceGasStudent LoansSavingsRequirementPointsAllocatedComments1Open Excel and save a blank worksheet with thefollowing name:“Student’s First InitialLast Name Excel”Example: JSmith ExcelSet Page Layout to Landscape0.1Use Print Preview toreview howspreadsheet wouldprint.2In the worksheet, insert a CustomHeadertitled,“My PersonalBudget.”0.25This Custom Headertext must be Arial 14
RequirementPointsAllocatedCommentspoint,Bold, and becentered on the page.3Add a customFooterwith your name in the LeftSection and automatic pagination in the RightSection.0.25Text format is Arial 10pointNormal.4Enter columnheadings :BUDGET ITEM, PROJECTED COSTS and the 12months for the year: JANUARY THROUGHDECEMBERYou may abbreviate the months as follows: JAN,FEB, MAR, APR, MAY, JUN, JUL, AUG,SEP, OCT, NOV, DEC0.25All column headingsmust use the followingtext formatting:Arial 10 pointBoldText centered incolumnAll capital letters5Enter your personal budget categories/labels (eitheryour own or the list provided) in the rows under thecolumn heading BUDGET ITEM.A minimum of 9 categories is required.0.25Text format is Arial 10point, Normal.Align text Left in thecell.6Format 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 ifyou simply typed in the“$.” This will result inzero (0) points for thisitem. If any otherformat is used besidesCurrency, the scorewill be zero (0) for thiscomponent.7In the column under your PROJECTED COSTSlabel, enter a monthly budget goal amount for eachBUDGET ITEM category. This would be the limit ofwhat you wantto spend on each category in onemonth’s time.0.25Arial 10 pointBoldAlign text Right incolumn8Enter the label “PROJECTED BUDGET TOTAL:” inthe next row in the BUDGET ITEM column.0.35Use the followingformats:
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
