South SCC1031 2020 JUNE Week 4 Assignment Latest

SCC1031 Computers and Information Literacy

Week 4 Assignment  

Background:

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:

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.