D N Current Date Days Past Du Current 1-0 days 5 Invoice Numb Invoice Date Company 10273 5/28/17 Consortium for Oonan Leadership 10282 6/9/17 MRSI Group, Inc 10283 6/12/17 Natural Environment Research Co 10321 5/5/17 Alpharma.inc 10323 5/8/17 Cardio Tech International Inc 10329 6/27/17 Image Acoustics, Inc 10 10358 6/2/17 Ocean Dynamics Inc Invoice Sales Hep Sales Commiss Amount Johnson 128.54 $ 2.142.40 Boehmer IS 2 $ 155.40 Lesure 5 5 141480 Lesure N/A $ 144.00 Boehmer N/A 5 164.40 Lesure INA $ 4,819.40 Boehmer N/A 5 45200 You are given this spreadsheet to correct issues for problems and missing information. Please answer the following questions to resolve the issues. Eac 1. What function would you insert in cel B2 od that today's day or the current date is always displayed? This field will be referenced as the CurrentDate. 2. The formula you entered in EA "VLOOKUPIDA, CommissiontAA:B7,23*F4" was entered incorrectly. Correct the formula so that it will work in the ascending cellsbe 3. Your customers asking you to create a formula In G4 that shows the number of days the customer is past dun. Which formula below will provide the right result A) IF(TODAY0-8330,Currentbate-8330,0) B) Currentbate-B330.Current Date-B3-30.0) CIRCurrentDate-B330.CurrentDate-5330, CurrentDate-8330,0) B) CurrentDate-330.CurrentDate-83 30.08 OF(Current Date 330.Current Date:03 Using the function create a formula that uses the cell references 6 days past due) and involce Amount to show the display nothing or blank if overdueline: This form should return the number of days) 5. What formula is needed in cell 147 Create a nested IF formule using an AND statement that uses the cell references days past due anaven between 1-30 days, which will display the balance amount of the overdue account for accounts between t. 30 days and display thing or blank current value) BAX BEEG C D 1 2 Current Date Company . Lesure 3 Involce Numb-Involce Date Invoice 10273 5/28/17 Consortium for Ocean Leadership Sales Rep Sales Commiss Amount Days Past Due Johnson Current 5 10282 $ 128.54 5 2,142.40 6/9/17 MRSI Group, Inc Boehmer $ 2 $ 155.40 3 6 10283 6/12/17 Natural Environment Research Co $ $ 1.4160 7 10321 5/5/17 Alpharma Inc Lesure N/A $ 144.00 8 10323 5/8/17 Cardio Tech International Inc Boehmer N/A S 164 40 9 10329 6/27/17 Image Acoustics, Inc. Lesure #N/A $ 4,81940 10 10358 6/2/17 Ocean Dynamics Inc. Boehmer N/A S 452.00 You are given this spreadsheet to correct issues for problems and missing information. Please answer the following questions to resol 1. What function would you insert in cell B2 so that today's day or the current date is always displayed? This field will be referenced as the curre 2. The formula you entered in E4 "=VLOOKUP(D4, Commission A4:87,2*F** was entered incorrectly. Correct the formula so that it will work in the 3. Your customer is asking you to create a formula in G4 that shows the number of days the customer is past due. Which formula below will prow A) IF(TODAYO-B3>30, CurrentDate-B3>30,0) B) =IF(CurrentDate-B3>30, CurrentDate-B3-30.0) C) =IF(CurrentDate-B3>30, CurrentDate-B330, CurrentDate-33-30, "Yes") 4. What formula is needed in cell H47 Using the IF function, create a formula that uses the cell references ca (days past due) and 3 Invoice Amo display nothing or blank if overdue. (Hint: This formula should return the number of days) 5. What formula is needed in cell 147 Create a nested IF formula using an AND statement that uses the cell references ay durland Fan between 1-30 days, which will display the balance amount of the overdue account for accounts between 1 -30 days and aning or blank value) Tag question D Sales Sales Comme Amount Dua Past Due Current 1-10 days Mandera 2050 2102,40 WA MGONGA Boehmer 2 5 155.40 5 Nature Tere $ 1414 10 re NA $ 144.00 Technine NA $ 16440 Lasure ANA $ 4,819.40 NA 452.00 adsheet to correct issues for problems and missing Information. Please answer the following questions to resolve the issues. Each question is worth 3 pts. ourse in 2 so that today's day or the current date is always displayed? This field will be referenced as the Current Date din WLOOKUPCommi87.21**** we entered incorrectly. Correct the formula so that it will work in the ascending cells below E3:010 you to create a formula in that shows the number of days the customer is past due. Which formula below will provide the right result? current 30.00 Current 3.500) Current Date- Bote) Debate 3 30.7" incel the of function create a formula that uses the cell references 63 days past due) and F3 (Involce Amount) to show the customer's CURRENT BALANCE and vertint This formula should return the number of days) Create a nested IF formule using an AND statement that uses the cell references 3 days past due) and 3 (invoice Amount to show if a customer is PAST DUE duplay out balance amount of the overdue account for accounts between 1-3 days and display nothing or blank if current (Hint: This formula should return a dollar