ACCOUNTING INFORMATION SYSTEMS ANALYZING DATA USING MS EXCEL DATA SUBTOTALS

       ANALYZING DATA USING MS EXCEL DATA SUBTOTALS                            INSTRUCTIONS: - 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   Question # (for example "Question 1")    - 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)             Question 1 What were total sales of End Tables?       Put your answer here:                           Question 2 How many total items did Norm   Thompson sell?      Put your answer here:                           Question 3 Which region had the highest total   sales for the year?     Put your answer here:                           Question 4 Which product had the most number of   items sold?     Put your answer here:                           Question 5 Which salesperson sold the most in   dollars?      Put your answer here:                           Question 6 What customer accounted for the most   sales?      Put your answer here:                           Question 7 How many total items were sold in   2016?      Put your answer here:                           Question 8 What were total sales for John   Lucas?       Put your answer here:                                     Hint: Don't forget to check that your cell   formats are proper!