computer

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.

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

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.

Money-back guarantee

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

Zero-plagiarism guarantee

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

Free-revision policy

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

Privacy policy

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

Fair-cooperation guarantee

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