placeholder image to represent content

Excel Unit 6

Quiz by Jennifer Michaels

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
4 questions
Show answers
  • Q1
    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?
    B4
    B4*12
    B4/12
    -B4
    30s
  • Q2
    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?
    -B5
    B5
    B5*12
    B5/12
    30s
  • Q3
    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?
    Size
    Print Area
    Background
    Print Titles
    30s
  • Q4
    What Conditional Formatting option lets you put a little bar chart in each cell?
    Data Bars
    Highlight Cells
    Color Scales
    Top/Bottom Rules
    30s

Teachers give this quiz to your class