Print
Rubric
Lesson
Example

Projects.Excel.09

Excel Final Review:
Expensive Mall Store

Problem

You have been hired by a trendy store in the mall to calculate their profits and determine which items they make the most money on. You will be using Excel to do this.

Initial Spreadsheet

Instructions

  1. Create a spreadsheet that that contains the information above.
  2. Create a new column called Markup that calculates the profit generates by each item sold.
  3. Create a new column called Total Sales Made that determines how much money was made on each item by multiplying the amount sold by the selling price.
  4. Create another column called Actual Profit that determines how much profit was made on the amount of items sold.
  5. Create a column called Percent Profit that says the percentage of the Actual Profit is or the Total Sales Made.
  6. Use the table-array below and the vlookup function in one final column called Suggestion.
    Table Array
  7. Finally, create a line chart named Item Pricing that plots the item cost and the selling price. Make sure everything is labeled correctly.
  8. Make your spreadsheet look professional by using color and borders. Format all the numbers correctly.
  9. Make sure your name is in the title of the Excel document and turn it in to Mr. Miller's Neighborhood.