Excel help please Project Setting: You have just moved into a new apartment and will be furnishing it with new furniture. Your kitchen has a stove, oven, and refrigerator; and your apartment complex has a laundry room. You will need to furnish your kitchen$/$dining area, living room, and bedroom. You are borrowing $$5,000$ dollars to furnish your apartment. Using shopping sites located on the internet, find items you would like to purchase for each of your rooms.

Spreadsheet Requirements: For this project, you must create a sheet for each room. You will also be creating a summary sheet, so each of the sheets needs to be set up the same. On each sheet, you need to make a table with the information listed below for each item you are purchasing. $($Hint: create one sheet and copy it for the other rooms so all the sheets are identical.$)$

Item name

Description

Website $-$ If you include a link to the website for the item$($s$)$ be sure you only include the domain name $($

www$.$target.com$)$ not the long link to the actual item.

Number of items

Cost per item

Total cost

Shipping charges per item $-$ outside of the table enter a label for shipping charges and in a cell adjacent to the label, enter $12\%.$ Enter a formula in the shipping charges column to calculate the shipping charges based on the total cost per item for each item using an absolute cell reference to the shipping charges percentage.

Each table should have at least $10$ items. The table should be sorted by item name and needs to include a total row that shows the total number of items for each room, the total spent, and the total shipping charges. Below the table, add an area to calculate the average Total Cost using the AVERAGE function. Also add conditional formatting of your choice to the total cost column.

Summary Sheet Requirements: When you have completed the sheets for the rooms, create a summary sheet that shows:Summary Sheet Requirements: When you have completed the sheets for the rooms, create a summary sheet that shows:

Total spent in each room $-$ use a $3-$D formula for this!

Total cost for all the rooms together $-$ using a $3-$D formula.

Total shipping charges for all the rooms $-$ using a $3-$D formula.

Grand total which includes the total cost for all three rooms plus the shipping charges.

How much money you have left.

An IF statement that shows if you are over or under budget.

Calculation determining the monthly payment for the $$5,000$ loan. $($Note: even if you didn't spend the whole $$5,000,$ calculate the monthly payment based on borrowing $$5,000.)$ You will be paying it off over a period of $5$ years and the annual interest rate for the loan is $3\%.$ List the loan amount, length of the loan $($years$),$ and the annual interest rate and name these cells. Make sure to use cell references$/$named cells in your function, not values.

A pie chart that shows how much money you spent in each room.

A relevant image of your choice, with Alt text added.