I need all of these REQUIRED answers PLEASE!!!!! :)

Aging Date: 9/24/2020 Age (days)

Age (days)	Group
0-30	0-30
31-60	31-60
61-90	61-90
Over 90	Over 90

REQUIRED

a. Create a formula in column F to calculate how many days a particular invoice has been outstanding. b. Create a formula in column G that attaches the correct label to each invoice (e.g., if the invoice is 030 days old, the label should be 030; if it is 3160 days old, the label should be 3160, etc.) according to the table in the upper right corner of the spreadsheet. c. Create a pivot table that shows the sum, count, and average values for each of the four categories of accounts receivable. d. Create a pivot table that shows total amounts and count of invoices by both category (e.g., 030, 3160, etc.) and region (East, West, North, South). e. Modify the pivot table in step d to be able to filter the results by salesperson.

43North44South45East46East47East48West49West50West51West52West53West54West55West56South57North58North59North60North61North62North63North64NorthGGHAABCCDEEEFGGHAABCCD741.26357.99631.22764.99333.95244.99188.75988.99989.95777.99666.99555.95444.95333.99222.95111.99101.00204.00303.55412.87732.66567.239/20/20209/18/20209/21/20206/7/20209/20/20209/11/20209/13/20209/21/20208/15/20207/15/20207/15/20209/13/20209/22/20209/21/20209/11/20209/13/20209/22/20209/17/20207/15/20209/13/20206/8/20209/20/2020 65North66North67North68North69North70South71South72South73South74East75West76West77East78West79West80East81West82West83North84North85North86SouthEEEFGGHABBBCCDEEFFFFGG367.33399.95370.99951.99505.82777.99111.99222.95333.99449.95501.77666.77777.88888.99444.31333.64111.23222.34555.43123.45123.32876.786/30/20209/13/20209/18/20209/11/20209/17/20209/17/20209/22/20209/18/20209/13/20209/17/20209/22/20209/17/20209/20/20209/17/20209/20/20206/30/20209/22/20209/11/20209/18/20209/13/20209/13/20209/17/2020 87South88East89East90East91West92South93North94North95East96West97South98North99North100EastHHABBBCCDEEFFF987.89444.56555.76777.55888.44222.95267.95832.88157.99743.77905.95959.59595.95777.888/15/20209/22/20209/17/20209/20/20209/17/20209/11/20209/21/20209/17/20209/18/20209/20/20206/6/20207/15/20209/13/20209/17/2020 43North44South45East46East47East48West49West50West51West52West53West54West55West56South57North58North59North60North61North62North63North64NorthGGHAABCCDEEEFGGHAABCCD741.26357.99631.22764.99333.95244.99188.75988.99989.95777.99666.99555.95444.95333.99222.95111.99101.00204.00303.55412.87732.66567.239/20/20209/18/20209/21/20206/7/20209/20/20209/11/20209/13/20209/21/20208/15/20207/15/20207/15/20209/13/20209/22/20209/21/20209/11/20209/13/20209/22/20209/17/20207/15/20209/13/20206/8/20209/20/2020 65North66North67North68North69North70South71South72South73South74East75West76West77East78West79West80East81West82West83North84North85North86SouthEEEFGGHABBBCCDEEFFFFGG367.33399.95370.99951.99505.82777.99111.99222.95333.99449.95501.77666.77777.88888.99444.31333.64111.23222.34555.43123.45123.32876.786/30/20209/13/20209/18/20209/11/20209/17/20209/17/20209/22/20209/18/20209/13/20209/17/20209/22/20209/17/20209/20/20209/17/20209/20/20206/30/20209/22/20209/11/20209/18/20209/13/20209/13/20209/17/2020 87South88East89East90East91West92South93North94North95East96West97South98North99North100EastHHABBBCCDEEFFF987.89444.56555.76777.55888.44222.95267.95832.88157.99743.77905.95959.59595.95777.888/15/20209/22/20209/17/20209/20/20209/17/20209/11/20209/21/20209/17/20209/18/20209/20/20206/6/20207/15/20209/13/20209/17/2020