# Chapter 6 BIM 1-13

## Quiz by Carol Luttmer

### Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

12 questions
• Q1
Performs a calculation that results in a single value
function
arguments
chronological order
amortization
45s
• Q2
A cell reference that does not change when copied because a dollar sign has been placed in front of both the column letter and row number, such as \$A\$5.
key sort column
IF function
amortization table
absolute cell reference
45s
• Q3
A method for computing equal periodic payments for an installment loan.
descending order
amortization
function
installment loan
45s
• Q4
The column that contains the values that a sort is based on.
absolute cell reference
arguments
IF function
key sort column
45s
• Q5
Ascending order
alphabetical order
function
descending order
function
45s
• Q6
Loan that is repaid in a series of periodic payments
installment loan
function
chronological order
AVERAGE function
45s
• Q7
Displays the interest and principal amounts for each payment of an installment loan.
amortization table
function
key sort column
arguments
45s
• Q8
In order from lowest to highest. Also called alphabetical order when the data is text and chronological order when the data is times or dates.
descending order
function
absolute cell reference
ascending order
45s
• Q9
The data required by a function.
function
absolute cell reference
arguments
installment loan
45s
• Q10
Function that is used to make a decision based on a comparison.
AVERAGE function
IF function
function
key sort column
45s
• Q11
Function that adds the values in a range of cells and then divides the result by the number of cells in the range.
amortization
IF function
AVERAGE function
ascending order
45s
• Q12
In order from highest to lowest.
arguments
descending order
ascending order
amortization
45s

Teachers give this quiz to your class