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: Atlanta, 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 CaseAccountsReceivableData$-301082.$xlsx$.$ How much did Phoenix Company pay on account during the year?

fill in the blank $2$

$2.$ What is the total of Madrid's past$-$due invoices?

fill in the blank $3$

$3.$ What is the average amount of all invoices issued in April?

fill in the blank $4$

$4.$ How many unpaid invoices does Orlando Company in June, July, and August combined?