a. generate a formula in column F to calculate how many days a particular invoice has been outstanding.

b. generate a formula in column G that attaches the correct label to each invoice (e.g., if the invoice is 0-30 days old, the label should be "0-30"; if it is 31-60 days old, the label should be "31-60", etc.) according to the table in the upper right corner of the spreadsheet. (PLEASE USE VLOOKUP)

c. generate a pivot table that shows the sum, count, and average values for each of the four categories of accounts receivable.

d. generate a pivot table that shows total amounts and count of invoices by both category (e.g., 0-30, 31-60, etc.) and region (East, West, North, South).

e. Modify the pivot table in step d to be able to filter the results by salesperson.

Home Insert Draw Page Layout Formulas Data Review View Deve Work Sans 16 A" A - ab w Paste B IUV A = M F4 X fx A B C D E F G H Aging Date: | 9/24/2020 Age ( days) Group 0-30 0-30 W NH Customer Region Salesperson Balance Invoice Date Age (Days) Group 31-60 31-60 1 East A 435.22 9/1/2020 61-90 61-90 2 South 598.55 8/20/2020 Over 90 Over 90 3 East 124.55 9/1/2020 4 West 199.99 7/15/2020 5 North 945.00 9/2/2020 6 South 831.64 9/2/2020 10 7 West 728.95 9/2/2020 11 8 East 362.59 9/3/2020 12 9 North A 333.79 9/10/2020 13 10 North 184.65 6/6/2020 14 11 South 299.99 8/15/2020 15 12 East 499.99 9/11/2020 16 13 West 399.99 6/30/2020 17 14 West 259.95 9/12/2020 18 15 North 784.75 9/13/2020 19 16 South 566.66 9/11/2020 20 17 South 444.44 7/15/2020 21 18 South 234.56 9/17/2020 22 19 East 345.67 6/30/2020 23 20 West 456.78 9/18/2020 24 21 West 567.89 6/6/2020 25 22 East 987.65 9/17/2020 26 23 North 876.54 9/17/2020 27 24 South 765.43 8/15/2020 28 25 South 135.79 9/18/2020 29 26 North 246.80 9/13/2020 30 27 North 147.98 9/18/2020 31 28 East 259.85 9/13/2020 32 29 West 445.66 8/15/2020 33 30 East 554.33 7/15/2020 34 31 West 222.22 9/17/2020 35 32 North 111.11 9/11/2020 36 33 South 427.99 9/11/2020 37 34 East 444.44 9/11/2020 38 35 North 555.55 9/13/2020 39 36 South 666.66 9/17/2020 40 37 West 777.77 9/20/2020 41 38 East 888.88 9/17/2020 42 39 North 222.55 9/13/2020 43 40 South 987.65 8/15/2020 44 11 West 975.31 9/20/2020 in m 45 42 West 864.20 6/30/2020 46 43 North 741.26 9/20/2020 47 44 South 357.99 9/18/2020 48 45 East 631.22 9/21/2020 49 46 East 764.99 6/7/2020 50 47 East 333.95 9/20/2020 51 48 West 244.99 9/11/2020 52 19 West 188.75 9/13/2020 53 50 West 988.99 9/21/2020 ana ar nter hoon Sheet2 Sheet1