Quizalize logo
placeholder image to represent content

Excel 2016 Lesson 11

Quiz by Jennifer Gallagher

Feel free to use or edit a copy

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.

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

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

Correct quiz answers unlock more play!

New Quizalize solo game modes
15 questions
Show answers
  • Q1
    What ribbon will your find commands for formulas like RANDBETWEEN?
    Review
    View
    Insert
    Formulas
    30s
  • Q2
    The RAND function does NOT require any arguments.
    False
    True
    20s
  • Q3
    To stop the RANDBETWEEN function from generating a new number each time the workbook opens, copy the cell(s) and paste values.
    True
    False
    30s
  • Q4
    Microsoft can recover the password you add to the worksheet and/or workbook.
    True
    False
    20s
  • Q5
    To protect a worksheet, what ribbon should you go to?
    Insert
    Review
    Formula
    View
    30s
  • Q6
    To protect a workbook, go to the Review Ribbon, then to what group?
    Proofing
    Comments
    Review
    Changes
    30s
  • Q7
    A user can require one password to open/view a workbook and another to modify the data.
    False
    True
    20s
  • Q8
    Protecting the structure of a workbook prevents users from viewing worksheets that you have hidden;
    All of these
    inserting new worksheets
    changing the names of worksheets
    moving, deleting, hiding worksheets
    30s
  • Q9
    What ribbon is the Document Inspector found under?
    Home
    File
    Insert
    Data
    30s
  • Q10
    Mark as document as final is found under the File Ribbon under which section?
    Options
    Info
    Export
    Share
    30s
  • Q11
    Mark as Final is a secure feature preventing the workbook from any changes.
    True
    False
    30s
  • Q12
    What ribbon will you find the track changes and comments commands?
    Data
    Formula
    Home
    Review
    30s
  • Q13
    What color triangle represents an added comment?
    Blue
    Purple
    Green
    Red
    30s
  • Q14
    To change the fill color of a comment box
    Right-click, Format comment
    Home Ribbon, Font color
    Home Ribbon, Fill color
    Right-click, Fill color
    30s
  • Q15
    A comment can be deleted, unless a workbook is protected.
    False
    True
    30s

Teachers give this quiz to your class