I

I need help with each question, if you could explain just what formulas to do for part a because I know you don't have access to the excel file but a picture thank you.

14.4 Download the spreadsheet from the course website and perform the following tasks. 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. Excel File Edit View Insert Format Tools ** 18%D Sun 5:45 PM Q OOO AutoSave OFF Data Window Help Spreadsheet for problem 14-4 Review View Developer Tell me a Home Insert Draw Page Layout Formulas Data Share Comments Work Sans W 16 v v AP A Wran Text General Insert - Delete Format YO 4 LE Peste B 1 Uw ORA = = Merge & Center Y Conditional Format Cell Formatting as Table Styles Sort Filter Find & Select Sensitvity Analyze Data 1 L P R - 11 V Y Group Aye dayal 0-35 31-90 61 90 Grap 0-30 11-10 51 90 11:19 F4 + Xfx c n F 1 Apr Date2020 2 Curierar | Haglandenpunon Bduncu estou Dele All 4 List 435.22 94/2020 5 B B 59.55 2020 6 3 rt 12455 9102029 4 What L 8 S No E 945.00 9/2/2020 OSAS 23.44 10 7 West C 728.95 9/2/2020 11 362.59 acae 12 9 No 333.79 9/10/20 1 10 16-1.65 M2 14 11 Sou, C 299.99 B/A5/2010 15 12 499.99 97117020 16 13 st E 399.99 6/30/2020 17 14 A F 259.95 0712,7070 18 15 N 6 264.25 0.02 19 16 Saus H GAG 0721.7070 17 Suus 44444 20 21 19 R 23456 9/17/2020 22 32 C 34.47 bezo 23 20 Arst C 456.78 9/18/2020 11 A 52292 25 22 Gost F 987.65 $17/2020 33 Nors c 27 24 SOU F 76543 815/2020 311 35 135.29 30 29 B 245.20 903/2020 10 37 c 107.9 1.2020 28 Bit D 259.35 943 97 79 A 466 115.2020 20 554.33 30/2020 34 21 Art G 25 42 :.1 11:..1 991/2020 13 A 42799 100 32 94 bat A 44144 2020 25 NO B 553.55 9/23/2020 99 C 04.46 Davao 40 37 Alest C 772.77 9/20/2020 41 29 No E 222.55 9413/2020 13 962:45 03 44 41 last E 975.31 9/20/2020 15 12 F 161.20 0.2020 46 43 Nora G 24..26 9/20/2020 14 157.90 0,19,2020 45 Sol F 63.22 21/2020 49 46 Post A 76149 42.2020 47 at 353.05 9:20/2020 51 19 AV R 24499 721220 52 ha! C LES. Wczo 53 50 Alest 98 99 100 *** Sheet2 Sheet1 11.1 .1 Ready 1 THI 77%