On the CarLoan worksheet, in cell G10, use the CUMPRINC function to calculate the cumulative principle paid on the car loan. Use the data in the range E4:E6 when entering the first three arguments in the function. Reference cell A10 as the start and end period arguments. Enter 0 as the type argument. Modify the function to convert the results to a positive value. Make the row references absolute in all arguments except for the end period. Copy the formula down through cell G19.

what is a breakdown of how to complete each of these actions?

Wha

File Home Insert Formulas Data Review View Help JMP Share Comments Data Draw Page Layout Lo Recent Sources L Existing Connections Queries & Connections From Text/CSV Le From Web From Table/Range IA TN 000 8 Clear Te Reapply 21 Z Properties Sort Outline Get Data Stocks Filter Refresh All Geography Text to Columns Co Edit Links Advanced What If Forecast Analysis Sheet Get & Transform Data Queries & Connections Data Types Sort & Filter Data Tools Forecast A1 fx Car Loan A B C D E F H 1 j K L M N O P 0 1 Car Loan 2 3 Payment Details Loan Details 4. Payment 233 Loan $12,124.83 5 APR 5.75% Periodic Rate 0.479% 6 Years 5 # of Payments 60 7 Pmts per Year 12 8 Payment Beginning Payment Principal Cumulative Cumulative 9 Number Balance Amount Interest Paid Repayment Interest Principal 10 1 $12,124.83 233 58.09813185 174.9018681 58.0981319 11 2 $11,949.93 233 57.2600604 175.7399396 115.358192 12 3 $11,774.19 233 56.41797319 176.5820268 171.776165 13 4 $11,597.60 233 55.57185098 177.428149 227.348016 14 5 $11,420.18 233 54.72167443 178.2783256 282.069691 15 6 $11,241.90 233 53.86742412 179.1325759 335.937115 16 7 $11,062.76 233 53.00908053 179.9909195 388.946196 17 8 $10,882.77 233 52.14662404 180.853376 441.09282 18 9 $10,701.92 233 51.28003495 181.7199651 492.372855 19 10 $10,520.20 233 50.40929345 182.5907066 542.782148 20 Totals $ 2,330.00 542.78 $ 1,787.22 June Totals June 2017 AnnualExp HomeLoan CarLoan Stocks + Ready ! EO + 100% File Home Insert Formulas Data Review View Help JMP Share Comments Data Draw Page Layout Lo Recent Sources L Existing Connections Queries & Connections From Text/CSV Le From Web From Table/Range IA TN 000 8 Clear Te Reapply 21 Z Properties Sort Outline Get Data Stocks Filter Refresh All Geography Text to Columns Co Edit Links Advanced What If Forecast Analysis Sheet Get & Transform Data Queries & Connections Data Types Sort & Filter Data Tools Forecast A1 fx Car Loan A B C D E F H 1 j K L M N O P 0 1 Car Loan 2 3 Payment Details Loan Details 4. Payment 233 Loan $12,124.83 5 APR 5.75% Periodic Rate 0.479% 6 Years 5 # of Payments 60 7 Pmts per Year 12 8 Payment Beginning Payment Principal Cumulative Cumulative 9 Number Balance Amount Interest Paid Repayment Interest Principal 10 1 $12,124.83 233 58.09813185 174.9018681 58.0981319 11 2 $11,949.93 233 57.2600604 175.7399396 115.358192 12 3 $11,774.19 233 56.41797319 176.5820268 171.776165 13 4 $11,597.60 233 55.57185098 177.428149 227.348016 14 5 $11,420.18 233 54.72167443 178.2783256 282.069691 15 6 $11,241.90 233 53.86742412 179.1325759 335.937115 16 7 $11,062.76 233 53.00908053 179.9909195 388.946196 17 8 $10,882.77 233 52.14662404 180.853376 441.09282 18 9 $10,701.92 233 51.28003495 181.7199651 492.372855 19 10 $10,520.20 233 50.40929345 182.5907066 542.782148 20 Totals $ 2,330.00 542.78 $ 1,787.22 June Totals June 2017 AnnualExp HomeLoan CarLoan Stocks + Ready ! EO + 100%