Create a simple pie chart showing the quantity of each item to purchase.

You are going to create an Excel spreadsheet that discusses the costs of school supplies. The following items should be included as line items: Item/Quantity/Cost per item Plastic Folders8$1.991-inch binders4$1.99Markers (10 count set)2$2.79Graphing Calculator2$19.2418-pack Pencils2$3.7910-pack Pens3$0.99Notebooks10$2.49Tissues3$1.79Index Cards (100 cards each)4$0.89In the first row, create a header row called ‘School Supplies Needed’. Shade the header and use the Merge and Center feature to center the header.Create column headers called ‘Item’, ‘Quantity’, and ‘Cost (per item)’, ‘Total Cost’. Shade the column headers a color of your choice. Expand the columns to show each column header title.Format the font of the column headers to Arial Rounded MT Bold in 14 font.Under each column header, list each item, quantity and cost (per item). Use the Calibri font in 11 font.Using a formula, create the ‘Total Cost’ per item.Using formulas, create the sum of the following column – quantity, total cost.Format the cost (per item) column and total cost using the currency format.Add a cell border in between all of the cells in the data set.For any total costs over $15.00, use conditional formatting to highlight the total in red.Insert a stock picture of any type of school supplies on the sheet.Create a simple pie chart showing the quantity of each item to purchase. Add data labels showing that quantity. Choose any design to apply to the pie chart.Rename the sheet that the data is on to ‘School Supplies’. Color the tab any color of your choice.