Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
Give this quiz to my class
Q 1/12
Score 0
Performs a calculation that results in a single value
45
function
arguments
chronological order
amortization
Q 2/12
Score 0
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.
45
key sort column
IF function
amortization table
absolute cell reference
12 questions
Q.
Performs a calculation that results in a single value
1
45 sec
Q.
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.
2
45 sec
Q.
A method for computing equal periodic payments for an installment loan.
3
45 sec
Q.
The column that contains the values that a sort is based on.
4
45 sec
Q.
Ascending order
5
45 sec
Q.
Loan that is repaid in a series of periodic payments
6
45 sec
Q.
Displays the interest and principal amounts for each payment of an installment loan.
7
45 sec
Q.
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.
8
45 sec
Q.
The data required by a function.
9
45 sec
Q.
Function that is used to make a decision based on a comparison.
10
45 sec
Q.
Function that adds the values in a range of cells and then divides the result by the number of cells in the range.
