Tip

Tap
a student's name
below to see what they need help with
Quizalize logo
placeholder image to represent content

Excel Unit 6

Quiz by Jennifer Michaels

Feel free to use or edit the questions

includes Teacher and Student dashboards

Measure skills
from any curriculum

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

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

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?
4
30 sec

Give this quiz to my class