placeholder image to represent content

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!

New Quizalize solo game modes
12 questions
Show answers
  • 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