excel-assignments-2

answered part one right. But part 2 (on sheet 2) and part 3 (on sheet 3) are incorrect. As I put in the instructions, in part 2, you should use PIVOT Table to present a table which shows the ages of accounts receivable by the customer types (X,Y and Z). For example, the table columns would be 0-30 days, 31-60 days, 61-90 days and over 90 days. The rows are the types of customers X, Y and Z. In the table content, you present the total dollar amounts. Similarly, you would use PIVOT Chart to present the same information on sheet 3.