placeholder image to represent content

Excel Lesson 7

Quiz by Lisa DeCastillia

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
19 questions
Show answers
  • Q1
    Which ribbon contains the command to apply a theme to a worksheet in Microsoft Excel?
    Page layout
    Home
    Data
    Hide
    45s
  • Q2
    Jack would like the data in Row 10 not to display on his spreadsheet. Which option should he select?
    Scale
    Header
    Freeze
    Hide
    45s
  • Q3
    What command do you use to insert information into a worksheet that will display at the top and bottom edges of the printed page?
    Margins
    Print titles
    Header & Footer
    Page setup
    45s
  • Q4
    Which term describes the blank portions of a page that fall outside the main body of the printed document?
    Margins
    Frames
    Edges
    Borders
    45s
  • Q5
    Joan is showing her spreadsheet to a customer and does not want the customer to be able to see the wholesale prices column. What option should she choose?
    Page Break
    Freeze
    Split
    Hide
    45s
  • Q6
    John's spreadsheet includes multiple pages of records. If John wants to view his headings while scrolling through his spreadsheet what should he do?
    Freeze Panes
    Hide
    Split
    Unhide
    45s
  • Q7
    Which command on the Home Ribbon do you use to format row height and column width, organize sheets, and protect or hide cells in a worksheet?
    Insert
    Format
    Sort & Filter
    Form
    45s
  • Q8
    Jim would like the data in Row 1 of his spreadsheet to repeat on every page of his printout. What page setup option should he change?
    Orientation
    Print area
    Print titles
    Page break
    45s
  • Q9
    Jack would like to force the data in his spreadsheet to fit on one page when printed. Which option should he select?
    Header
    Freeze
    Hide
    Scale
    45s
  • Q10
    Which command on the Home Ribbon do you use to remove cells, rows, or columns from a worksheet or table?
    Remove
    Delete
    Format as Table
    Format
    45s
  • Q11
    Which command group on the Page Layout Ribbon controls the presence of gridlines and headings on a worksheet?
    Sheet options
    Page setup
    Arrange
    Themes
    45s
  • Q12
    John notices that column D is not showing on his spreadsheet. What action does he need to take to view column D?
    Unhide
    Split
    Hide
    Freeze panes
    45s
  • Q13
    Which set of formatting choices includes a set of colors, fonts, and effects that you can apply to a worksheet to enhance its appearance?
    Design
    Layout
    Theme
    Template
    45s
  • Q14
    In Microsoft Excel, what do you use to emphasize certain entries and make the worksheet easier to read and understand?
    Configuring
    Printing
    Formatting
    Arranging
    45s
  • Q15
    Which command on the Page Layout Ribbon enables a user to mark where a new page will begin on the printed copy?
    Print area
    Background
    Effects
    Breaks
    45s

Teachers give this quiz to your class