M&M Graph $-$ Student Instructions $-$ Follow the step$-$by$-$step instructions to graph your bag of M&Ms$!$

Search the web to find an interesting fact, product, or tool that you didn't know about M&Ms$.$ Write it down. Check off each of the steps as you complete them. Find a picture that you like.

Open Microsoft Excel$-$ Blank Worksheet

Open Excel and Enter a Heading in cell A$1$ that says What you get with M&Ms

In cell A$3$ type column heading M&M color and in cell B$3$ type column heading # of M&Ms in my bag

Adjust your column width so that the entire headings fit within the cell.

Below the column heading $"M$&$M$ color" list the colors that are in the plain M&M bag.

Below the column heading $"$# off M&Ms in bag" enter the number of each color that was in the bag.

Yes, you will need to count how many reds are in the bag and report it on your Excel spreadsheet.

Center the data in the cells below your column headings

In cell A$10-$ type the word Total

In cell C$3-$ type the word Percentage

Add a Function $($AutoSum$)$ to get the total Sum of the M&Ms in your bags.

Add a formula to calculate the percentage of each color M&M in your bags.

Use the Fill handle to drag the formula down the column. $($Hint: you need to make Cell B$10$ an absolute cell reference$)$

In Column C$,$ apply $\%$ style so it shows up as a percentage $($no decimals$)$

Merge and Center the title of your table

Under Cell Styles, Apply a Style to the title

In Cell A$2,$ type How many M&Ms are in my bag? $-$ Merge and Center and Apply a Style to the Heading

Format your column headings to increase their font size to $14$ points, bold, and center. This may require you to readjust your column width so that the entire heading fits in its cell.

Apply the Total Style to the TOTAL row.

For each M&M color listed turn the fill color of the cell to the color listed. Please note: if it is difficult to read the color in black font, you may need to adjust the font color to white.

Highlight cells A$4$ through B$9$ and insert a Clustered Column Chart

Move chart to begin in cell A$12$

Edit the title of your chart

Apply formatting to your chart.

Below your chart type: "Did YOU Know..." and then type your interesting fact that you learned on the M&M website in instruction #$1.$

Format your Did You Know fact to increase the font size to at least $16-$point font and to fit on the page. Insert a picture from the web.

Submission: Once you have finished all your Excel tasks above, save the file named Excel$2\_$FirstName.xIsx. Submit the file to Blackboard for feedback and grading.