ACCT 43. Arlenment Marketing Data celowed SUMI and SUS Need statement AND MORE CON Formatting You are the Cro for medium to the West not proficient with data analysis and the same wher February 2001 sales She has the following questions 1. What are the total sales by leal 2. How many high volume customers are served wychofthews UMWI, WWE and DEX) How many non.high volume customers were each of the (Customers are high volume if quantities of the use or do total or more 3. How many customers are local tlocat defined as having town of Sacrament. We Sacramento, or elk Grove How many customers are welcal total revenue from sales of Standard products to nonlocal customers! 4. What is the total revenue from sales of Standard products on www.th 5. What is the total revenue from sales of Deluxe products to local customen? Wat the revenue from sales of Deluxe products to nonlocal customers 6. Which sales rep had the most customers that purchased both Dhe und Standard prots? Required: 1. Download the SALES DATA workbook available on Canvas Swe MAKITA DATA_YOUR NAME (Use your own name-first initial and last name. The data with Includes the basic data you need 2. Copy the data to a new worksheet. Name the worksheet "panded Date Format the worksheet. Then you will be adding four new columns to the right of the data a. In the first new column, display the total revenue for each customer. You need to the two products together. b. In the second new column, indicate which products the customer purchased. Den Standard, or Both) 1. You must use a nested IF statement which includes the AND function il. Use the strategy that we used in the Practice Assignment to lay out how together this nested IF statement formula ACCT 43. Arlenment Marketing Data celowed SUMI and SUS Need statement AND MORE CON Formatting You are the Cro for medium to the West not proficient with data analysis and the same wher February 2001 sales She has the following questions 1. What are the total sales by leal 2. How many high volume customers are served wychofthews UMWI, WWE and DEX) How many non.high volume customers were each of the (Customers are high volume if quantities of the use or do total or more 3. How many customers are local tlocat defined as having town of Sacrament. We Sacramento, or elk Grove How many customers are welcal total revenue from sales of Standard products to nonlocal customers! 4. What is the total revenue from sales of Standard products on www.th 5. What is the total revenue from sales of Deluxe products to local customen? Wat the revenue from sales of Deluxe products to nonlocal customers 6. Which sales rep had the most customers that purchased both Dhe und Standard prots? Required: 1. Download the SALES DATA workbook available on Canvas Swe MAKITA DATA_YOUR NAME (Use your own name-first initial and last name. The data with Includes the basic data you need 2. Copy the data to a new worksheet. Name the worksheet "panded Date Format the worksheet. Then you will be adding four new columns to the right of the data a. In the first new column, display the total revenue for each customer. You need to the two products together. b. In the second new column, indicate which products the customer purchased. Den Standard, or Both) 1. You must use a nested IF statement which includes the AND function il. Use the strategy that we used in the Practice Assignment to lay out how together this nested IF statement formula