computer

 

Excel is a simple yet complex tool that can help with analyzing data, creating charts, and creating calculations. Its important for a user new to Excel to understand how to apply the basics of Microsoft Excel to a document before moving on to the more advanced features of Excel.

Assignment Instructions:

In this assignment, you will build on the spreadsheet you created for this week’s discussion board using the instructions below. 

Item

Quantity

Cost (per item)

Total Cost

Plastic Folders

8

$1.99

1-inch binders

4

$1.99

Markers (10 count set)

2

$2.79

Graphing Calculator

2

$19.24

18-pack Pencils

2

$3.79

10-pack Pens

3

$0.99

Notebooks

10

$2.49

Tissues

3

$1.79

Notebook Paper

4

$0.89

Total Quantity 

Total Cost 

Please include each of the features below:

  • Add a fourth column titled “Total Cost”
  • Merge and Center the title “School Supplies”
  • Shade the title cell any color
  • Use a bolded font for the title and headers of each column
  • Format the cost column and total cost using the currency format.
  • Include a cell border in between all of the cells in the data set.
  • Use the sum formula below the quantity column to add the total number of items needed 
  • Use the product formula 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 formula 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
  • Create a simple pie chart showing the quantity of each item to purchase. Add data labels to the chart. 
  • Rename the sheet tab School Supplies and add any color to the tab.