(1) You are asked to complete an aging schedule in the following table. Use the =IF() function to identify past due invoices and # of days past due. Use the =IF(AND() function for the aging schedule. Past Due Amount: 1-30 days 3 1-60 days 61-90 days Over 90 days Aging schedule Invoice # Csustomer Type 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 Total 2) Prepare an analysis of accounts receivable using Pivot table: In your report, you should present an aging schedule by the types of customers (X, Y, and Z). (3) Prepare an analysis of accounts receivable using Pivot chart: In your chart, you should present an aging schedule by the types of customers (X, Y and Z). (1) You are asked to complete an aging schedule in the following table. Use the =IF() function to identify past due invoices and # of days past due. Use the =IF(AND() function for the aging schedule. Past Due Amount: 1-30 days 3 1-60 days 61-90 days Over 90 days Aging schedule Invoice # Csustomer Type 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 Total 2) Prepare an analysis of accounts receivable using Pivot table: In your report, you should present an aging schedule by the types of customers (X, Y, and Z). (3) Prepare an analysis of accounts receivable using Pivot chart: In your chart, you should present an aging schedule by the types of customers (X, Y and Z)