Quizalize logo
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
  • view complete results in the Gradebook and Mastery Dashboards
  • automatically assign follow-up activities based on students’ scores
  • assign as homework
  • share a link with colleagues
  • print as a bubble sheet
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
    Edit
    Delete
  • 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
    Edit
    Delete
  • 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
    Edit
    Delete
  • 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
    Edit
    Delete
  • 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
    Edit
    Delete
  • 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
    Edit
    Delete
  • 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
    Edit
    Delete
  • 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
    Edit
    Delete
  • 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
    Edit
    Delete
  • 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
    Edit
    Delete
  • 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
    Edit
    Delete
  • 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
    Edit
    Delete
  • 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
    Edit
    Delete
  • 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
    Edit
    Delete
  • 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
    Edit
    Delete
  • Q16
    Which command do you use to remove manual page breaks from a worksheet area?
    Select break, press Remove Page Break from Shortcut Menu
    Select break, press Backspace on keyboard
    Select break, press Delete on keyboard
    Select Remove Page Break from the Breaks drop-down area
    45s
    Edit
    Delete
  • Q17
    Which command do you use to format a cell or selected cells quickly by choosing from a defined list of styles?
    Cell style
    Conditional formatting
    Form
    Format as table
    45s
    Edit
    Delete
  • Q18
    Trey would like to apply a rule to the data in cell range A1:F20 that will highlight numbers greater than 50,000 with a yellow fill color and dark yellow text. Which formatting style should he select?
    Borders
    Conditional Formatting
    Cell Style
    Format as Table
    45s
    Edit
    Delete
  • Q19
    Column B in a spreadsheet contains information about regional sales. Which formatting would be most appropriate for the data in column B?
    Number
    Text
    Date
    Currency
    45s
    Edit
    Delete

Teachers give this quiz to your class