Part 3: Excel Practice (This part of the assignment will be completed in Excel.)

1. Create a tab in your spreadsheet and label it, "Findings".
2. Add the results of your findings from parts 1 and 2 of the worksheet to this tab.
3. Create a second tab in your spreadsheet and label it, "Colors".
4. Create a graph (bar or column) with one axis listing each color of M&M and the other axis listing the total. For the bar that shows the total for each color, the bar color should match the color of the M&M.
5. Next to each color bar add a black bar to show how many were defective for each color.
6. Information for the above assignment.I have a total of 22 m&m's 9 defective and 13 non defective. I have red, brown and tan colored m & m's. The defected m&m's are as follow red-3, brown-4, tan-2. The non defective are as follows red-3, brown-4, tan-6.