Question 1

The ________ is the number of payments over the life of a loan.

Accepted Answer

The answer of The ________ is the number of payments...

Question 2

The ________ value is a reference to a cell containing a value to look up for a function.

Accepted Answer

The answer of The ________ value is a reference to...

Question 3

The ________ is the periodic interest or a loan.

Accepted Answer

The answer of The ________ is the periodic interest or...

Question 4

You can use ________ names in formulas instead of cell references.

Accepted Answer

The answer of You can use ________ names in formulas...

Question 5

The V________ function looks up a value in a table and returns a result from a specified column in the table.

Accepted Answer

The answer of The V________ function looks up a value...

Question 6

A ________ name is a word or string of characters that represent one or more cells.

Accepted Answer

The answer of A ________ name is a word or...

Question 7

The H________ function looks up a value in a horizontal table and returns a result from a row in the table.

Accepted Answer

The answer of The H________ function looks up a value...

Question 8

The ________ function calculates the periodic payment for a loan with interest.

Accepted Answer

The answer of The ________ function calculates the periodic payment...

Question 9

The ________ is the Present Value of a loan or in other words; how much was borrowed.

Accepted Answer

The answer of The ________ is the Present Value of...

Question 10

The ________ test formula is one that tests for true or false.

Accepted Answer

The answer of The ________ test formula is one that...

Quiz 12: Excel: Relational Databases and Queries

The ________ is the number of payments over the life of a loan.