26 Enter a formula in cell F12 to calculate the remaining balance after the current payment. The 4 remaining balance is calculated by subtracting the principal payment from the balance in column B. 27 Use the CUMIPMT function in cell G12 to calculate the cumulative interest paid on the first 4 payment. Use the loan details information (E6:E9) as needed for inputs. Be sure to use the appropriate absolute, relative, or mixed cell references. All results should be formatted as positive values. 28 Enter a function in cell H12 based on the payment and loan details that calculates the amount 4 of cumulative principal paid on the first payment. Be sure to use the appropriate absolute, relative, or mixed cell references. All results should be formatted as positive numbers. 29 Enter a reference to the remaining balance of payment 1 in cell B13. Use the fill handle to 4 copy the functions created in the prior steps down to complete the amortization table. Expand the width of columns D:H as needed. 30 Use PowerQuery to connect and open the Orders table in the eApp_Cap_Orders.accdb 4 database. Use the Query editor to format column A with Date number format and load the table. Rename the worksheet Orders. 31 Adapt the previous step to connect and load the Warehouse table. 2 32 Connect to, but don't load the Inventory table from the eApp_Cap_Orders. accdb database. 0 33 Create the following relationships. 3 Relationship 1 Table Name Inventory Column (Foreign) Warehouse Table Warehouse Column (Primary) Warehouse Relationship 2 Table Orders Column (Foreign) Item_Number Table Inventory Column (Primary) Item_Number 34 Use PowerPivot to create a blank PivotTable on a new worksheet. Add the following fields to 4 the PivotTable