ACCOUNTING INFORMATION SYSTEMS (ACTY 3130) 2018 SUMMER II ANALYZING DATA USING MS EXCEL TABLES WITH FILTERS DROP-BOX ASSIGNMENT INSTRUCTIONS: – Company sales data for 2015 and 2016 is listed in the “Original Data” worksheet. Your manager wants you to analyze this data using Tables with filters to answer the questions below. – Copy the Original Data tab to a new tab called “Question 1” etc. and create your filter to answer each question below. – Make sure your answers are presented in the correct cell format (dollars are displayed with the dollar sign and 2 decimals, units are displayed to include the comma, if applicable). ANALYZE THE DATA AND ANSWER QUESTIONS Question 1 In 2015, how many Arm Chairs did Susan Mushton sell in the North East region? Put your answer here: Question 2 In 2016, how many Arm Chairs did Susan Mushton sell in the North East region? Put your answer here: Question 3 In 2016, what was the total amount of sales recorded for Susan Mushton? Put your answer here: Question 4 How many Armoires were sold in February 2015? Put your answer here: Question 5 How many Armoires were sold in February 2016? Put your answer here: Question 6 In 2015, how much were total sales (in dollars) to Prestige Furnishings LLC? Put your answer here: Question 7 In 2016, how many Coffee tables did John Lucas sell to Prestige Furnishings LLC? Put your answer here: Question 8 How many units of all products were sold by the company in 2016? Put your answer here: Question 9 What were total sales (in dollars) of all products in the last quarter of 2016? Put your answer here: Question 10 In 2016, what were total sales (in dollars) of Futons and Coffee Tables to ABC Designs, Inc. in the North East region only? Put your answer here: GRADING RUBRIC A table with filters is located in a separate worksheet from the original data worksheet for each question. Table includes a total row with the total units and total sales in dollars shown (within the Table, not separate from the Table) Cell formats are correct (all numbers and dollar amounts are presented in the correct measurment)
Hi there! Click one of our representatives below and we will get back to you as soon as possible.