1. Using Microsoft Excel or Excel Online, design and create a spreadsheet that organizes your total estimated personal expenses (including rent or house payments, car payments, loan payments, and other items on which you spend money) by month for a twelve-month period. This can be fictional data, as long as it's realist data. Format the cells using the accounting number format, and add a worksheet title in cell A1. Merge and center cell A1 across the top of your worksheet, and format the text appropriately to give it a professional appearance.

2. Building on the spreadsheet you created in question #2; add your monthly income over the last 12 months. This can be fictional data, as long as it's realist data. You may need to change your worksheet title to reflect this additional information. Format the monthly income using the accounting number format. Use the SUM function to calculate your total expenses, as well as your total income (you will add together your expenses for each of the twelve months, and then add together your income for each of the twelve months).

3.Using the spreadsheet from questions 6 and 7. Use the AVERAGE, MAX, and MIN functions to determine the following:

* Use the AVERAGE function to determine your average monthly expenses

* Use the AVERAGE function to determine your average monthly income

* Use the MAX function to determine how much you spent during the month when your monthly expenses were the highest.

* Use the MAX function to determine how much income you received during the month when your monthly income was the highest.

* Use the MIN function to determine how much you spent during the month when your monthly expenses were the lowest.

* Use the MIN function to determine how much income you received during the month when your monthly income was the lowest.