Warehouse Loan and Lookup Form

create a named range and use it to set data validation. You will use a PMT function to calculate a value and then use it in a two-variable data table. You will also enter VLOOKUP functions to return values from a table, and format cells in the workbook. You will also audit a worksheet and correct errors. 1 Start Excel. Download and open the workbook named 0 GO_eo4_Grader_a3_start.xlsx. Click the Warehouse Payment Table sheet. In cell B8, enter a PMT 2 function using cell B4 divided by 12 as the rate, BB as the number of 10 payment periods, and 82 as the present value of the loan. Display the result as a positive number. 3 In the range B8:H16, create a two-variable data table. Set BB as the row 10 input cell, and B4 as the column input cell. 4 Apply the Currency number format to cells C9:H16. Apply the cell style 5 Note to the payment in cell D14.