Quizalize logo
placeholder image to represent content

Microsoft Excel Review

Quiz by Sheryl Avery

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
35 questions
Show answers
  • Q1
    A formula that has at least two different mathematical operators is called what?
    simple formula
    function
    complex formula
    complex function
    20s
    Edit
    Delete
  • Q2
    Multiple worksheets within one file are collectively called what?
    excel
    PDF
    workbook
    text
    20s
    Edit
    Delete
  • Q3
    A formula that has just one mathematical operation is called what?
    simple formula
    operator
    complex formula
    function
    20s
    Edit
    Delete
  • Q4
    A single sheet within a workbook that contains data
    table
    workbook
    cell
    worksheet
    20s
    Edit
    Delete
  • Q5
    Cells labeled with numbers going down a worksheet are called what?
    columns
    charts
    tables
    rows
    20s
    Edit
    Delete
  • Q6
    Cells labeled with letters that go across a worksheet are called what?
    tables
    charts
    columns
    rows
    20s
    Edit
    Delete
  • Q7
    The location or name of the cell is called it's what? Example A2
    column
    row
    workbook
    Cell Address
    20s
    Edit
    Delete
  • Q8
    This action allows you to temporarily hide data.
    sparkline
    sort
    filter
    cell range
    20s
    Edit
    Delete
  • Q9
    A reference that used a particular cell over and over again as opposed to changing the cells relative to the position of the formula is what type of reference?
    Absolute reference
    relative reference
    simple reference
    cell reference
    20s
    Edit
    Delete
  • Q10
    Organizing data is called what?
    functions
    filtering
    sorting
    sparklines
    20s
    Edit
    Delete
  • Q11
    A group of cells represented by a colon : is called what? Ex: A5:A8
    function
    absolute reference
    cell range
    sorting
    20s
    Edit
    Delete
  • Q12
    Changing the formula based on a cell's relative position within the worksheet when copying a formula across cells is what type of reference?
    absolute reference
    sparklines
    relative reference
    cell ranges
    20s
    Edit
    Delete
  • Q13
    Miniature charts inserted within just one cell are called what?
    Sparklines
    sortings
    cell ranges
    functions
    20s
    Edit
    Delete
  • Q14
    A predefined formula used to calculate data where you don't need to use any mathematical operator signs.
    cell ranges
    simple formula
    Function
    complex formula
    20s
    Edit
    Delete
  • Q15
    Cells can only contain numbers
    False
    True
    20s
    Edit
    Delete
  • Q16
    To select a group of cells, my cursor should look like a thin, back plus sign.
    False
    True
    20s
    Edit
    Delete
  • Q17
    If #### appear in your cell after inserting a formula, your formula is incorrect.
    True
    False
    20s
    Edit
    Delete
  • Q18
    Grouping worksheets allows a change on one sheet to appear on the other sheet.
    False
    True
    20s
    Edit
    Delete
  • Q19
    Autosum only adds numbers together
    False
    True
    20s
    Edit
    Delete
  • Q20
    I can only sort data alphabetically or numerically.
    True
    False
    20s
    Edit
    Delete

Teachers give this quiz to your class