Quizalize logo
placeholder image to represent content

MS EXCEL BASICS

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
12 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
    A ______________ is an expression which calculates the value of a cell.
    Slide
    Formula
    Cell
    Functions
    60s
  • Q9
    What is the name given to the intersectioin of a row and a column in a spreadsheet?
    Square
    Cube
    Block
    Cell
    60s
  • Q10
    An example of a cell address is:
    A4
    A16:A29
    4B
    4A
    60s
  • Q11
    How are rows designated/identified?
    Stars
    Letters
    Numbers
    Circles
    60s
  • Q12
    How are columns designated/identified?
    Numbers
    Circles
    Letters
    Stars
    60s

Teachers give this quiz to your class