College Paper Writing Service- ANALYZING DATA USING MS EXCEL DATA SUBTOTALS
ANALYZING DATA USING MS EXCEL DATA SUBTOTALS
Included on the Original Data in this workbook is a worksheet with data about company sales in 2016. Your manager wants you to analyze this data using data subtotals and answer the questions below.
Create a new worksheet tab to show your answer for each question. Name each tab the Format the cell to match the proper format for your answer (dollar amounts should include the dollar sign, numbers over 1,000 should include the comma, etc)
What were total sales of End Tables?
How many total items did Norm Thompson sell?
Which region had the highest total sales for the year?
Which product had the most number of items sold?
Which salesperson sold the most in dollars
What customer accounted for the most sales?
How many total items were sold in 2016?
What were total sales for John Lucas? Don’t forget to check that your ce
