Excel is a simple yet complex tool that can help with analyzing data, creati
Excel is a simple yet complex tool that can help with analyzing data, creating charts, and creating calculations. It’s 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.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.