Reference no: EM13763051
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
|
Identify the symbols you notice in each poem
: Identify the symbols you notice in each poem. What abstract concepts (e.g., love, death, truth) might the concrete objects (e.g., persons, places, things) suggest?
|
|
Modify the inventory program to use a gui
: Modify the Inventory Program to use a GUI. The GUI should display the information one product at a time, including the item number, the name of the product
|
|
Classify the types of expenses associated with the operation
: Identify and classify the types of expenses associated with the operation of the selected organization.
|
|
Review of relevant accounting principles
: Conduct a review of relevant accounting principles related to mergers. Explain key components of the acquisition method of accounting. How does a consolidated firm report financial results when the acquired firm remains a separate corporate entity..
|
|
Which product sold for the highest average price
: 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 ..
|
|
How to solve 8-3(x+1)=5-(2x-3) what is the process
: How to solve 8-3(x+1)=5-(2x-3) what is the process?
|
|
Par value and number of shares
: ABC Corporation offered a four-for-one stock split. The number of outstanding shares before the split was 15,000, and the par value was $20 per share. After the split, what was the par value and number of shares?
|
|
Modify the inventory program by adding a button to the gui
: If the first item is displayed and the user clicks on the Previous button, the last item should display. If the last item is displayed and the user clicks on the Next button, the first item should display. Add a company logo to the GUI using Java ..
|
|
Corporation on the exchange
: What amount of gain or loss is recognized by Sam and M Corporation on the exchange?
|