Specifications

Candy manufacturers have set percentages for the color mix that should be in each package of the candy that is available to consumers.  The color percentages for M&Ms and Skittles is found in the chart below.

                                M&M Colors    Percentages                         Skittles Colors      Percentages   
  Red 20%   Red 20%
  Green 10%   Green 20%
  Yellow 20%   Yellow 20%
  Orange 10%   Orange 10%
  Blue 10%   Purple 30%
  Brown 30%      
  1. Create a copy of the "Facts" worksheet and rename it "Specifications".  Change the tab color to black and move this worksheet so that it is the last worksheet tab.
  2. Rename this worksheet "[First Name]'s Specifications" and color the text black to match the tab color.
  3. Delete the chart from the Specifications worksheet.
  4. Delete Row 3 from the spreadsheet (contains the Actual Count information).
  5. In Cell B3, key "Actual" and in Cell C3, key "Specs".  Bold and right-align these subtitles.
  6. For each color, create a formula to multiply the "total" by the "percent" from the chart above.  For example, if cell B10 contained the actual total and I wanted to calculate the percentage of "red" candy that should be in the package, my formula might be:  =B10 * .20  Note:  You cannot copy this formula down the column as you will need to change the percentages for each candy color type.
  7. Use the SUM function to total Column C.  Note that the sum should equal the actual count total shown in Column B.
  8. Bold the Total title and the Totals.
  9. Select the range of data, beginning with cell A3 through the color data (do not include the totals).
  10. Insert a 3-D Area Chart and place the chart below your spreadsheet data.
  11. Add an appropriate Chart Title and format the chart as desired making your chart unique from others.
  12. In cell D3, key "Difference" as a subtitle and widen the column as needed to fit the text.  Bold and right-align this subtitle.
  13. Enter a formula in cell D4 to subtract the actual count from the specifications for the first color.  Fill this formula down the column for each color.
  14. In the cells to the right of the spreadsheet data, key a four-sentence paragraph describing how well or how poorly the manufacturer did in meeting the percentage and quantities of each color for the product you purchased.  Merge the cells and wrap the text to fit in the cells neatly.
  15. Save!

Congratulations!  You have just completed your first Excel spreadsheet exercise!  Submit to Mrs. Jansen or Mr. Ertl as directed.  Good job!