Table of Contents
Background:
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 an Excel spreadsheet with the data below. Then, include each requirement
listed.
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:
- 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.
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."