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.
In this assignment, you will build on the spreadsheet you created for this week’s discussion board using the instructions below.
Cost (per item)
Markers (10 count set)
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.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more