Analyze the data using Microsoft Excel and answer questions based on your findings from your manipulations of the data.
1. Download the spreadsheet SectionESpring15.xlsx from Blackboard. Save this file as: E_FirstName_LastName _Excel.xlsx. For example, if I were to submit this assignment I would need to save and rename the spreadsheet as E_Natasha_Veltri _Excel.xlsx. Save a copy of the original data sheet to a new page in the workbook and rename that data sheet Working Copy of Data. Format the sheet so that the reader can see all of the column names and all of the data in the columns so that the words aren't cut off or hidden. On a separate work sheet create a List Definition Table to explain to users what the data in the columns of the Original Data worksheet mean.
2. Use the data on the Working Copy of Data sheet along with the techniques learned in class (filtering, autofiltering, conditional formatting and pivot tables) to answer the following questions: (Create a work sheet named Answers and place your answers on this sheet (the answers must be clearly marked so I know what the answer is to each part of question 2.)
a. Create a copy of your Working Copy of Data and re-name it 2a. Use conditional formatting to highlight in red the team name for all sales made by your muesli company. For example, if my company was A, I would highlight all cells that contained AA under Team.
b. Create a copy of your Working Copy of Data and re-name it 2b. Use filtering to filter out all of the cereals except those sold by your company. Find the smallest numberof boxes purchased from your company based on the Quantity column. Use fill color red to highlight this quantity. Which cereal is this?
c. Create a copy of your Working Copy of Data and re-name it 2c. What was the highest Price charged by any company for a box of muesli? Change the fill color to green for those prices. Which company or companies sold those boxes?
d. Using the Working Copy of Data, create a pivot table to answer the following questions. Name the sheet containing the pivot table 2d. Which product sold for the highest average price? Highlight the muesli and amount in red. Which product sold the least based on quantity (count) of sales transactions? Highlight the muesli and amount in green.
Attachment:- data analysis assignment.rar