# Chapter 6 BIM 1-13

## Quiz by Carol Luttmer

Feel free to use or edit a copy

includes Teacher and Student dashboards

### Measure skillsfrom any curriculum

Measure skills

from any curriculum

Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.

With a free account, teachers can

- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet

12 questions

Show answers

- Q1Performs a calculation that results in a single valuefunctionargumentschronological orderamortization45s
- Q2A 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 columnIF functionamortization tableabsolute cell reference45s
- Q3A method for computing equal periodic payments for an installment loan.descending orderamortizationfunctioninstallment loan45s
- Q4The column that contains the values that a sort is based on.absolute cell referenceargumentsIF functionkey sort column45s
- Q5Ascending orderalphabetical orderfunctiondescending orderfunction45s
- Q6Loan that is repaid in a series of periodic paymentsinstallment loanfunctionchronological orderAVERAGE function45s
- Q7Displays the interest and principal amounts for each payment of an installment loan.amortization tablefunctionkey sort columnarguments45s
- Q8In 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 orderfunctionabsolute cell referenceascending order45s
- Q9The data required by a function.functionabsolute cell referenceargumentsinstallment loan45s
- Q10Function that is used to make a decision based on a comparison.AVERAGE functionIF functionfunctionkey sort column45s
- Q11Function that adds the values in a range of cells and then divides the result by the number of cells in the range.amortizationIF functionAVERAGE functionascending order45s
- Q12In order from highest to lowest.argumentsdescending orderascending orderamortization45s