Home / Expert Answers / Computer Science / in-this-assignment-you-will-build-an-excel-spreadsheet-with-the-data-shown-here-from-a-blank-works-pa353

(Solved): In this assignment, you will build an Excel spreadsheet with the data shown here from a blank works ...



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 A1. 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.50 Graphing Calculator 1 $37.99 Notebook Paper 4 $1.99 Notebooks 8 $3.19 One inch binders 4 $3.99 Pencils (18 pack) 2 $3.79 Pens (10 pack) 2 $5.99 Plastic Folders 8 $2.29 Tissues 3 $3.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 A1. Then, merge and center cells A1 through D1 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.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 '+' icon beside the chart.) Rename the sheet tab ‘School Supplies’. Shade the worksheet tab blue.



We have an Answer from Expert

View Expert Answer

Expert Answer


We have an Answer from Expert

Buy This Answer $5

Place Order

We Provide Services Across The Globe