You are going to create an Excel spreadsheet that discusses the costs of school supplies. The following items should be included as line items:

Excel is a simple but also complicated 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:

You are going to create an Excel spreadsheet that discusses the costs of school supplies. The following items should be included as line items:

Item

Quantity

Cost (per item)

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

Index Cards (100 cards each)

4

$0.89

In the first row, create a header row called ‘School Supplies Needed’. Shade the header and use the Merge and Center feature to center the header.

Create column headers called ‘Item’, ‘Quantity’, and ‘Cost (per item)’, ‘Total Cost’. Shade the column headers a color of your choice. Expand the columns to show each column header title.

Format the font of the column headers to Arial Rounded MT Bold in 14 font.

Under each column header, list each item, quantity and cost (per item). Use the Calibri font in 11 font.

Using a formula, create the ‘Total Cost’ per item.

Using formulas, create the sum of the following column – quantity, total cost.

Format the cost (per item) column and total cost using the currency format.

Add a cell border in between all of the cells in the data set.

For any total costs over $15.00, use conditional formatting to highlight the total in red.

Insert a stock 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 showing that quantity. Choose any design to apply to the pie chart.

Rename the sheet that the data is on to ‘School Supplies’. Color the tab any color of your choice.

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.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

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.