Quizalize logo
placeholder image to represent content

MS EXCEL

Quiz by Joriel Cruz

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
10 questions
Show answers
  • Q1
    What Microsoft office program is designed to create spreadsheets which can later be used to analyze statistical data?
    MS Word
    MS OneNote
    MS Publisher
    MS Excel
    60s
  • Q2
    What should you type into an empty cell to start a formula?)
    *
    (
    =
    ^
    60s
  • Q3
    To divide 853 by 16 in a formula in Excel, you would use what sign should you use?
    *
    +
    -
    /
    60s
  • Q4
    In figure 1.3, what is the name of the cell where the age of John is located?
    Question Image
    B3
    B2
    B1
    B4
    60s
  • Q5
    What formula will you use in getting the sum of values 4 and 3?
    Question Image
    =B1+C1
    =A1+A2
    =SUM(A1:C1)
    =A1+B1
    60s
  • Q6
    What is the correct average function in computing the average value of number of examinees from the month of January to March ?
    Question Image
    =AVE(B2+B3+B4)/3
    =AVERAGE(B2:B4)/3
    =AVERAGE(B2:B4)
    =AVE(B2+B3+B4/3)
    60s
  • Q7
    How will you compute the total sales ?
    Question Image
    =TOTAL(D4:D13
    =SUM(D4:D13)
    =SUM(D4-D13)
    =SUM(D4+D13)
    60s
  • Q8
    How will you get the number of items under Food category
    Question Image
    =COUNTIF(”Food”,C4:C13)
    =COUNTIF(C4:C13,”Food”)
    =COUNTIF(B4:B13.”Food”)
    =COUNTIF(“Food”)
    60s
  • Q9
    A ______________ is an expression which calculates the value of a cell.
    Slide
    Formula
    Cell
    Functions
    60s
  • Q10
    If you will compute the average sales of Non-food, what will be your range in your AVERAGEIF formula?
    Question Image
    D4:D13
    B4:B13
    C4:C13
    “Non-food”
    60s

Teachers give this quiz to your class