placeholder image to represent content

Excel Lesson 7

Quiz by Lisa DeCastillia

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