Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
Loading...
Loading...
Loading...
Give this quiz to my class
Q 1/4
Score 0
If I am using a PMT function and I want to calculate the monthly payment but I have an APR (Annual Percentage Rate) interest in cell B4, how do I enter it into the formula?
30
B4
B4*12
B4/12
-B4
Q 2/4
Score 0
If I am using a PMT function and I want to calculate the monthly payment but I have the number of years in the loan in cell B5, how do I enter it into the formula?
30
-B5
B5
B5*12
B5/12
4 questions
Q.
If I am using a PMT function and I want to calculate the monthly payment but I have an APR (Annual Percentage Rate) interest in cell B4, how do I enter it into the formula?
1
30 sec
Q.
If I am using a PMT function and I want to calculate the monthly payment but I have the number of years in the loan in cell B5, how do I enter it into the formula?
2
30 sec
Q.
What button on the Print Layout bar do you use if you want row 1 to repeat at the top of every page when you print?
3
30 sec
Q.
What Conditional Formatting option lets you put a little bar chart in each cell?
