Quizalize logo
placeholder image to represent content

Formula Basics

Quiz by Lisette Ngui

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
15 questions
Show answers
  • Q1
    A formula always starts with a / an
    =
    -
    ()
    ,
    30s
    Edit
    Delete
  • Q2
    Formulas can be entered into a worksheet using how many methods?
    2
    1
    3
    4
    30s
    Edit
    Delete
  • Q3
    Cell referencing is used so the formula won't have to be re - typed
    Question Image
    true
    false
    30s
    Edit
    Delete
  • Q4
    Formulas can be edited only in the cell to be edited
    false
    true
    30s
    Edit
    Delete
  • Q5
    Formulas can be entered using the fill handles
    false
    true
    30s
    Edit
    Delete
  • Q6
    Formulas can be entered manually only
    false
    true
    30s
    Edit
    Delete
  • Q7
    Cell address is used to identify the location of a cell
    Question Image
    false
    true
    30s
    Edit
    Delete
  • Q8
    Excel updates your answers through automatic recalculation
    false
    true
    30s
    Edit
    Delete
  • Q9
    The point and click method can be used to enter formulas
    false
    true
    30s
    Edit
    Delete
  • Q10
    Excel and Mathematics share the same operators
    false
    true
    30s
    Edit
    Delete
  • Q11
    The multiplication sign is represented by an 'x'
    true
    false
    30s
    Edit
    Delete
  • Q12
    Complex formulas contain more than one mathematical operator.
    true
    false
    30s
    Edit
    Delete
  • Q13
    The order of operations should not be followed.
    true
    false
    30s
    Edit
    Delete
  • Q14
    If you follow the order of operations, you calculate what is contained in the parentheses first.
    false
    true
    30s
    Edit
    Delete
  • Q15
    The symbol for exponential is a caret
    ^
    >
    <
    30s
    Edit
    Delete

Teachers give this quiz to your class