Using the information given here recreate this spreadsheet following the task, SAMPLE TEST: SPREADSHEET JOB 1: SPREADSHEET B C D E G H COMPUTER SALES & 1 SERVICE 2 SIX-MONTH BUDGET 3 4 5 6 INCOME 6-MONTH TOTALS JUL AUG SEPT OCT NOV DEC 12090 1100 11095 1500 18950 600 8500 900 17400 800 1360 0 500 7 Computer Sales 8 Repairs and Parts 9 TOTAL INCOME 10 11 EXPENSES: 12 Salary Expense 13 Office Expense 14 Advertising Expense 15 Utilities Expense 16 Miscellaneous Expense 17 TOTAL EXPENSES 18 19 BALANCE 2500 150 100 200 100 2500 160 100 2500 150 275 175 150 2500 160 250 175 75 2500 250 300 180 100 2500 250 100 200 150 200 100 1. 5. 3. 3. . 10. 11. 12 13 14. 15. 16. Key in the above spreadsheet Calculate the Total Income for each month Calculate the Total Expenses for each month Calculate the Balance for each month Calculate 6-Month Totals for everything Format the entire spreadsheet for commas Format the Total rows and Balance row for currency Format the 6-month Totals column for currency Shade all the Total rows in light green Bold all areas that are in CAPS Center and bold the columnar headings Merge and center the two title rows over the spreadsheet Sort the expense items in alphabetical order Format the spreadsheet for borders inside and outside Extend column width if need be Insert a footer in the spreadsheet that is to be centered Your Name Open MS Excel and save the document as your last name. Using the information given here recreate this spreadsheet following the task, SAMPLE TEST: SPREADSHEET JOB 1: SPREADSHEET B C D E F G H A COMPUTER SALES & 1 SERVICE 2 SIX-MONTH BUDGET 3 4 5 6 INCOME: 6-MONTH TOTALS JUL AUG SEPT OCT NOV DEC 17400 12090 1100 11095 1500 18950 600 8500 900 1360 0 500 800 7 Computer Sales 8 Repairs and Parts 9 TOTAL INCOME 10 11 EXPENSES: 12 Salary Expense 13 Office Expense 14 Advertising Expense 15 Utilities Expense 16 Miscellaneous Expense 17 TOTAL EXPENSES 18 19 BALANCE 2500 150 100 200 100 2500 180 100 200 100 2500 150 275 175 150 2500 160 250 175 75 2500 250 300 180 100 TETTE 2500 250 100 200 150 2 1 3. . 3. 10 11 12 13 14. 15 16 Key in the above spreadsheet Calculate the Total Income for each month Calculate the Total Expenses for each month Calculate the Balance for each month Calculate 6 Month Totals for everything Format the entire spreadshoot for commas Format the Total rows and Balance row for currency Format the 6-Month Totals column for currency Shade all the total rows in light green Bold all areas that are in CAPS Center and bold the columnar headings Merge and center the two title rows over the spreadsheet Sort the expense items in alphabetical order Format the spreadshoot for borders inside and outside Extend column width if need be Insert a footer in the spreadsheet that is to be centered Your Name Your School Name Current Date Print Job 1. TRIAL Achim Dream 32