placeholder image to represent content

Excel Lesson 5

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

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

Correct quiz answers unlock more play!

New Quizalize solo game modes
16 questions
Show answers
  • Q1
    Which group on the Formulas Ribbon contains the command that checks for common errors found in a formula?
    Formula auditing
    Calculation
    Defined names
    Function library
    45s
    Edit
    Delete
  • Q2
    Where can you find the Insert Function button in Microsoft Excel?
    Shortcut menu
    Quick access toolbar
    Formula bar
    Status bar
    45s
    Edit
    Delete
  • Q3
    What is a prewritten formula that is built into Microsoft Excel called?
    Formula
    Function
    Statement
    Procedure
    45s
    Edit
    Delete
  • Q4
    When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?
    Absolute reference
    Certain reference
    Mixed reference
    Relative reference
    45s
    Edit
    Delete
  • Q5
    Which command on the Home Tab displays the total of the selected cells directly after the selected cells?
    Add
    Autosum
    Calculate
    Total
    45s
    Edit
    Delete
  • Q6
    Which group on the Formulas Ribbon enables a user to specify when a formula is computed?
    Calculation
    Formula Auditing
    Defined Names
    Function Library
    45s
    Edit
    Delete
  • Q7
    Which group on the Formulas Ribbon contains a command that allows a user to create names for cells to use in a formula?
    Formula Auditing
    Calculation
    Function Library
    Defined Names
    45s
    Edit
    Delete
  • Q8
    What do you call it when you reference cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address?
    Name Reference
    Sheet Name
    Calling the Sheet
    Worksheet Reference
    45s
    Edit
    Delete
  • Q9
    Which function do you use to insert today's date in a worksheet so that it automatically updates each time the worksheet is opened?
    CurrentDate
    Today
    Date
    Weekday
    45s
    Edit
    Delete
  • Q10
    What type of formula cell reference instructs Microsoft Excel to keep the cell reference constant in the formula as it copies it to the destination area?
    Mixed
    Unconditional
    Relative
    Absolute
    45s
    Edit
    Delete
  • Q11
    Which of the following are valid Microsoft Excel functions?
    MAX, MIN, and WEEK
    WEEKDAY, MAX, and CLOSE
    AVERAGE, MAX, and MIN
    AVERAGE, MAX, and NUM
    45s
    Edit
    Delete
  • Q12
    Which command group on the Formulas Ribbon allows a user to choose from various categories of functions to use in a worksheet?
    Formula Auditing
    Calculation
    Function Library
    Defined Names
    45s
    Edit
    Delete
  • Q13
    Madison is calculating her GPA. If she uses "=(A1+A2+A3+A4)/4", this is an example of which type of entry?
    Function
    Formula
    Values
    Labels
    45s
    Edit
    Delete
  • Q14
    Chelsea has created a spreadsheet containing student grades. Which function would she use to return the current date in cell F1?
    If
    Count
    Now
    Today
    45s
    Edit
    Delete
  • Q15
    Jordan is calculating her average sales for the past four months. If she uses "=AVERAGE(A1:A7)", this is an example of which type of entry?
    Formulas
    Labels
    Functions
    Values
    45s
    Edit
    Delete
  • Q16
    Which of the following is made up of two values and a relational operator, and is true or false for each cell in the range?
    Restriction
    Logic
    Condition
    State
    45s
    Edit
    Delete

Teachers give this quiz to your class