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.
