You will upload/submit to your Excel file with the name NAMEID_MonthlySales. Instructions: 1) First you will get the data for your monthly sales. Important: When you get your numbers you will take a screen shot. **Without the screenshot you will lose 50% of the grade. Put the screen shot in your file in a separate sheet. ** Go to the website: https://www.random.org/integers/ Enter to Generate 12 random integer. Values between 15000 and 50000. Format in 1 column. Note: Change from 5 to 1. Then click Get Numbers. You will get a page with your 12 numbers in 1 column and a timestamp. This is your monthly data starting at the top as January and so on. You must provide the screen shot of these numbers with the Timestamp. Do not forget the screen shot. The screen shot should be put in a separate sheet at the end. Rename the sheet to screen shot. 2) Sheet 1 - Name it Formulas In 1 column type a title/label Month, then you will type Jan thru Dec, so 12 cells down. In the next column type a title/label Sales, then enter the numbers in each cell next to its month.

Then you will find a) thru e) below for your data. You should have a label and then the next cell to the right use the correct formula. Ex:

Total

Enter correct Formula

You also change the cell properties and change the color to a different color for each. a) Total (total sum of the monthly sales) b) Average (average of month sales) c) Count (count for the total amount of sales months that has sales amounts over $35000) d) Minimum (minimum sales amount) e) Maximum (maximum sales amount) 3) Sheet 2 - Name it Tables You will copy the cells with the Months and Sales amounts from Sheet 1. You will then insert a table with the data you copied. (It changes the data into a table and you will see down arrows with the column title) Then copy it 4 times underneath the table with 2 cells in between. a) Sort the 2nd Table Alphabetically. b) Sort the 3rd Table From Smallest to Largest Sales Amounts. c) Filter the 4th Table to only show Months that start with the letter J. d) Filter the 5th Table to only show Months with values greater than $35,000. 4) Sheet 3 - Name it Cluster 1 You will copy the cells with the Months and Sales amounts from Sheet 1. [Note: After you copy the cells from Sheet 1 you can duplicate this Sheet two times for Step 5 and 6 before you continue] Insert a clustered column graph. 1. Update Chart Title 2. Add a Horizontal Axis Title, Months. 3. Add a Horizontal Axis Title, Months. 4. Add a Data Label - Outside End 5) Sheet 4 - Name it Cluster 2 You will copy the cells with the Months and Sales amounts from Sheet 1. Insert a clustered column graph. 1. Update Chart Title 2. Add a Moving Average Trend Line 3. Add a Data Talel with Legend Keys 6) Sheet 5 - Name it Pie You will copy the cells with the Months and Sales amounts from Sheet 1. a) Insert a Pie graph. 1. Update Chart Title 2. Add Data Labels best fit 3. Move the legend to the left of the Pie Chart 7) Sheet 6 - Name it Screen Shot Put your screenshot from the random number generator in this sheet.