Quizalize logo
placeholder image to represent content

Excel 3 & 4

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
16 questions
Show answers
  • Q1
    Joshua created a budget workbook that contains the formula =(Summary!B3). "Summary" is an example of a(n):
    External reference
    Scope
    Named range
    Names manager
    45s
    Edit
    Delete
  • Q2
    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
    Function library
    Calculation
    Defined names
    45s
    Edit
    Delete
  • Q3
    John's workbooks includes 3 worksheets. Which option should he choose to print them?
    Print selection
    Print entire workbook
    Fit to one page
    Print active sheet
    45s
    Edit
    Delete
  • Q4
    What area contains the command used to customize the print options in Microsoft Excel?
    Home ribbon
    Quick access toolbar
    File tab
    Page layout ribbon
    45s
    Edit
    Delete
  • Q5
    Which is a special workbook a user can create and then use as a pattern to create new, similar workbooks or worksheets?
    Smart sheet
    Template
    Form
    Boilerplate
    45s
    Edit
    Delete
  • Q6
    Which group on the Formulas Ribbon enables a user to specify when a formula is computed?
    Function library
    Define names
    Calculation
    Formula auditing
    45s
    Edit
    Delete
  • Q7
    Steve would like to print only the worksheet he is currently working on. What print option should he choose?
    Quick print
    Print area
    Entire workbook
    Active sheets
    45s
    Edit
    Delete
  • Q8
    When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?
    Absolute reference
    Variable reference
    Certain reference
    Relative reference
    45s
    Edit
    Delete
  • Q9
    Sara is calculating her GPA. If she uses "(A1+A2+A3+A4)/4", this is an example of which type of entry?
    Values
    Formulas
    Labels
    Functions
    45s
    Edit
    Delete
  • Q10
    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
    Calling the sheet
    Sheet name
    Worksheet reference
    45s
    Edit
    Delete
  • Q11
    Mike created a monthly sales workbook that contains the formula =SUM(Sales). "Sales" is an example of a(n):
    External reference
    Names manager
    Scope
    Named range
    45s
    Edit
    Delete
  • Q12
    How is a cell reference in a formula and its corresponding location in a worksheet identified?
    Cell reference and cell location are circled
    Cell reference and cell location are outlined in matching colors
    Arrows pointing from the formula to the location
    Lines connect from the formula to the location
    45s
    Edit
    Delete
  • Q13
    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
    Absolute
    Unconditional
    Relative
    45s
    Edit
    Delete
  • Q14
    What method is the MOST EFFICIENT way to copy five separate formulas to adjacent cells simultaneously?
    Copy method from Shortcut Menu
    Copy using the Quick Access Toolbar
    Copy from the Home Ribbon
    Copy using the Fill Handle
    45s
    Edit
    Delete
  • Q15
    Ralph would like to print only the cell range A1:F20. What page setup option should he change?
    Print titles
    Print area
    Orientation
    Page break
    45s
    Edit
    Delete
  • Q16
    Alan created a monthly sales workbook that contains the formula =(January!B3). "January" is an example of a(n):
    Named range
    Names manager
    External reference
    Scope
    45s
    Edit
    Delete

Teachers give this quiz to your class