Quizalize logo
placeholder image to represent content

Excel 1.04

Quiz by Cherie Young

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
  • 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
12 questions
Show answers
  • Q1
    Jennifer is calculating her GPA. If she uses "=(A1+A2+A3+A4)/4", this is an example of which type of entry?
    values
    labels
    formulas
    30s
  • Q2
    Sandra is creating a formula to subtract the values in cells B4 and C4. Which formula should she use?
    =B4/C4
    =B4-C4
    =B4+C4
    30s
  • Q3
    When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?
    Certain reference
    Relative reference
    Absolute reference
    30s
  • Q4
    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?
    Worksheet Reference
    Calling the Sheet
    Name reference
    30s
  • Q5
    Tyler created a monthly sales workbook that contains the formula =SUM(Sales). "Sales" is an example of a(n):
    external reference.
    scope.
    named range.
    30s
  • Q6
    How is a cell reference in a formula and its corresponding location in a worksheet identified?
    Arrows pointing from the formula to the location
    Cell reference and cell location are outlined in matching colors
    Cell reference and cell location are circled
    30s
  • Q7
    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?
    Unconditional
    Mixed
    Absolute
    30s
  • Q8
    Sandra is creating a formula to multiply the values in cells B4 and C4. Which formula should she use?
    =B4+C4
    =B4*C4
    =B4-C4
    30s
  • Q9
    Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create?
    =1$B$+25
    =B1+25
    =$B$1+25
    30s
  • Q10
    Tyler created a monthly sales workbook that contains the formula =(January!B3). "January" is an example of a(n):
    named range.
    external reference.
    scope.
    30s
  • Q11
    What method is the MOST EFFICIENT way to copy five separate formulas to adjacent cells simultaneously?
    Copy method from Shortcut Menu
    What method is the MOST EFFICIENT way to copy five separate formulas to adjacent
    Copy using the Fill Handle
    Copy using the Quick Access Toolbar
    30s
  • Q12
    Joshua created a budget workbook that contains the formula =(Summary!B3). "Summary" is an example of a(n):
    named range.
    external reference.
    scope.
    30s

Teachers give this quiz to your class