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