In this assignment, you will build an Excel spreadsheet with the data shown here from a blank worksheet. Do not use a template or table. Then, include each requirement listed below.

Be sure to start in cell A$1.$ Do not skip cells between columns and rows. Instead, resize the cells to fit the data.$$

Item Quantity Cost $($per item$)$ Total Cost

Crayons $2$ $$2\mathrm{.}50$

Graphing Calculator $1$ $$37\mathrm{.}99$

Notebook Paper $4$ $$1\mathrm{.}99$

Notebooks $8$ $$3\mathrm{.}19$

One inch binders $4$ $$3\mathrm{.}99$

Pencils $(18$ pack$)2$ $$3\mathrm{.}79$

Pens $(10$ pack$)2$ $$5\mathrm{.}99$

Plastic Folders $8$ $$2\mathrm{.}29$

Tissues $3$ $$3\mathrm{.}99$

Total Quantity Total Cost

Please include each of the features below:

Merge and Center the title "School Supplies"$($You should start the title in cell A$1.$ Then, merge and center cells A$1$ through D$1$ to create one title cell.$)$

Shade the title cell any color

Use $$Bold$$ on the title and headers of each column

Format the 'cost$$ column and 'total cost' column using the currency format.

Include a cell border in between all the cells in the data set.

Use the SUM Function below the quantity column to add the total number of items needed.$$

Use the PRODUCT Function in each cell of the fourth column to determine the total cost of each item$($quantity x cost $=$ total cost per item$)$

Use the SUM Function below the total cost column to add the total cost of all supplies$($total cost per item $+$ total cost per item... $=$ total cost$)$

Use conditional formatting to highlight any total costs over $$15\mathrm{.}00$ in red.

Insert a picture of any type of school supplies on the sheet$($from your computer, a stock image, or an online image. When using images from online, be sure to include the citation.$)$

Create a simple pie chart showing the$$quantity of each item$$needed$.($To do this, highlight the column headers and all data in columns $1$ and $2.$ Then, click on the pie chart option.$)$

Add$$data labels$$to the chart.$($This is an additional formatting option for charts that can be accessed from the $\text{'}+\text{'}$ icon beside the chart.$)$

Rename the sheet tab $$School Supplies$.$

Shade the worksheet tab blue.