Create your yearly budget using Labels as follows: Expenses, January, February...... December. (From column A1 through...

Transcribed Image Text:

Create your yearly budget using Labels as follows: Expenses, January, February...... December. (From column A1 through column M1) see example below. Answer the questions using formulas using cell references. Create at least 10 expenses. (Must have rent/mortgage and transportation as expenses on your spreadsheet) 1. 2. Give different amounts for all monthly expenses, only rent or mortgage should be fixed (e.g. $1000.00 each month). Change your expenses to accounting format. Find the sum of your expenses for each month. What are your total expenses for the year? 6. Given that your salary is $45,000.00 per year(please make cell reference), what is difference of your yearly salary less total yearly expenses? 3. 4. 5. 7. What is the average you spend per year on transportation? What is the Max you spend each month? What is the Min you spend each month? Rename your worksheet from sheet 1 to your name 8. 9. 10. (e.g. Ria) Budget. salary less total yearly expenses? What is the average you spend per year on transportation? What is the Max you spend each month? What is the Min you spend each month? 10. Rename your worksheet from sheet 1 to your name (e.g. Ria) Budget. 7. 8. 9. 11. In June of this year your rent/mortgage was increased by 5% (.05) What is the new rent using absolute referencing. 12. Create a pie chart from January to May expenses. 13. Add today's date using the date formula. 14: Add Conditional formatting to your sheet to show in red all expenses less than $300.00. Follow this example>> Expenses January February March April May June Create your yearly budget using Labels as follows: Expenses, January, February...... December. (From column A1 through column M1) see example below. Answer the questions using formulas using cell references. Create at least 10 expenses. (Must have rent/mortgage and transportation as expenses on your spreadsheet) 1. 2. Give different amounts for all monthly expenses, only rent or mortgage should be fixed (e.g. $1000.00 each month). Change your expenses to accounting format. Find the sum of your expenses for each month. What are your total expenses for the year? 6. Given that your salary is $45,000.00 per year(please make cell reference), what is difference of your yearly salary less total yearly expenses? 3. 4. 5. 7. What is the average you spend per year on transportation? What is the Max you spend each month? What is the Min you spend each month? Rename your worksheet from sheet 1 to your name 8. 9. 10. (e.g. Ria) Budget. salary less total yearly expenses? What is the average you spend per year on transportation? What is the Max you spend each month? What is the Min you spend each month? 10. Rename your worksheet from sheet 1 to your name (e.g. Ria) Budget. 7. 8. 9. 11. In June of this year your rent/mortgage was increased by 5% (.05) What is the new rent using absolute referencing. 12. Create a pie chart from January to May expenses. 13. Add today's date using the date formula. 14: Add Conditional formatting to your sheet to show in red all expenses less than $300.00. Follow this example>> Expenses January February March April May June

Answer rating: 100% (QA)

1 Create at least 10 expenses In cells A2 to A11 enter your expenses For example A2 RentMortgage A3 Transportation A4 Groceries A5 Utilities A6 Entert... View the full answer