Microsoft Excel 2021365 - Beginner to Advanced - Data Tables: Two Variables

This video tutorial explains how to create a two-variable data table in Excel, focusing on calculating monthly payments based on interest rates and loan amounts. It begins with an introduction to the concept, followed by a detailed setup of the PMT function to calculate payments. The tutorial then demonstrates how to build the data table by linking the PMT calculation and selecting the appropriate inputs. Finally, it covers formatting the table and verifying the accuracy of the calculations.

What is the main difference between a one-variable and a two-variable data table?

• A two-variable data table uses only one input.

• A one-variable data table is more complex.

• A one-variable data table requires no inputs.

• A two-variable data table has two inputs.

In the PMT function, why do we divide the rate by 12?

• To convert the rate to a daily rate.

• To increase the rate for annual payments.

• To adjust the rate for monthly payments.

• To simplify the calculation.

What is the purpose of the minus sign in front of the present value argument in the PMT function?

• To convert the value to a percentage.

• To display the result as a positive value.

• To ensure the result is negative.

• To increase the present value.

What are the row and column inputs in a two-variable data table?

• Both row and column inputs are the loan amount.

• Both row and column inputs are the interest rate.

• Row input is the interest rate, column input is the loan amount.

• Row input is the loan amount, column input is the interest rate.

How can you hide the PMT calculation in the corner of the data table?

• By deleting the cell.

• By using custom formatting with three semicolons.

• By changing the cell size.

• By using a different font color.