please heip

Completing this activity will help you learn to: 1. use Excel to determine sales by date, by product, by invoice, by customer, or a combination thereof. 2. explain what can be accomplished when analyzing data. Case Scenario: You are working at a startup that sells university merchandise online. The business sells wholesale to six customers: Atianta, Dakota, Madrid, Orlando, Phoenix, and Venice companies. It is December 31 , and you must analyze sales on account from this past year, Accounts receivable data is captured in the attached excel file. Required: Download spreadsheet CaseAccountsRecelvableData-6505ec.xisx Analyze the accounts receivabletjata in the spreadsheet and enter the answers to the questions for a grade. HINT: STEP-BY-STEP WALKTHROUGH 1. How much did Phoenix Company pay on account during the year? 2. What is the total of Madrid's past-due invoices? 3. What is the average amount of all invoices issued in April? Download spreadsheet CaseAccountsReceivableData-6505ec, x|sx Analyze the accounts recelvable data in the spreadsheet and enter the answers to the questions for a grade. HINT: STEP-BY-STEP WALKTHROUGH 1. How much did Phoenix Company pay on account during the year? 2. What is the total of Madrid's past-due invoices? 3. What is the average amount of all invoices issued in April? 4. How many unpaid invoices does Orlando Company in June, July, and August combined? 5. Explain what can be accomplished by analyzing this aging data. The input in the box below will not be graded, but may be reviewed and considered by your instructor. Completing this activity will help you learn to: 1. use Excel to determine sales by date, by product, by invoice, by customer, or a combination thereof. 2. explain what can be accomplished when analyzing data. Case Scenario: You are working at a startup that sells university merchandise online. The business sells wholesale to six customers: Atianta, Dakota, Madrid, Orlando, Phoenix, and Venice companies. It is December 31 , and you must analyze sales on account from this past year, Accounts receivable data is captured in the attached excel file. Required: Download spreadsheet CaseAccountsRecelvableData-6505ec.xisx Analyze the accounts receivabletjata in the spreadsheet and enter the answers to the questions for a grade. HINT: STEP-BY-STEP WALKTHROUGH 1. How much did Phoenix Company pay on account during the year? 2. What is the total of Madrid's past-due invoices? 3. What is the average amount of all invoices issued in April? Download spreadsheet CaseAccountsReceivableData-6505ec, x|sx Analyze the accounts recelvable data in the spreadsheet and enter the answers to the questions for a grade. HINT: STEP-BY-STEP WALKTHROUGH 1. How much did Phoenix Company pay on account during the year? 2. What is the total of Madrid's past-due invoices? 3. What is the average amount of all invoices issued in April? 4. How many unpaid invoices does Orlando Company in June, July, and August combined? 5. Explain what can be accomplished by analyzing this aging data. The input in the box below will not be graded, but may be reviewed and considered by your instructor