Refer to attachment – personal budget exercise

Document Preview:

Connect with a professional writer in 5 simple steps

Please provide as many details about your writing struggle as possible

Academic level of your paper

Type of Paper

When is it due?

How many pages is this assigment?

Personal Budget Exercise – Excel Creating a spreadsheet track personal business 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. You will create a personal budget to demonstrate your ability to correctly create and format an Excel spreadsheet and incorporate appropriate formulas to provide a useful budgeting tool for personal financing. After completing your budget, you will answer 3 “critical thinking” questions about your budget. Here are suggested budget categories if you are not using a real budget. At a minimum, you must have 9 budget categories: Housing (mortgage or rent) Food Utilities Misc. Car payment Entertainment Insurance Gas Student Loans Savings Note: All requirements must be met Requirement Points Allocated Comments Custom Header titled, “My Household Budget.” 0.25 This Custom Header text must be Arial 14 point, Bold, and be centered on the page. Custom Footer with your name in the Right Section and automatic pagination in the Left Section. 0.25 Text format is Arial 10 point, Normal. Enter column headings : ITEM, MONTHLY BUDGET, Months – January through December 0.25 All column headings must use the following text formatting: Arial 10 point Bold Centered text in column All capital letters Set Page Layout to Landscape 0.25 Use Print Preview to review how spreadsheet would print. Use your own personal budget categories or the list provided to set up the rows under ITEM. 0.25 Text format is Arial 10 point, Normal. Align text Left in the cell. Format all numeric for Currency, using two decimal places. If you have this set up correctly MS Excel will automatically insert a “$” in front of the amounts that you enter. 0.25 I will be able to tell if you simply typed in the “$.” This will…