Excel Unit 6
Quiz by Jennifer Michaels
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
4 questions
Show answers
- Q1If 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?B4B4*12B4/12-B430s
- Q2If 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?-B5B5B5*12B5/1230s
- Q3What 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?SizePrint AreaBackgroundPrint Titles30s
- Q4What Conditional Formatting option lets you put a little bar chart in each cell?Data BarsHighlight CellsColor ScalesTop/Bottom Rules30s