Quizalize logo
placeholder image to represent content

Excel

Quiz by ALVIN D LABAN

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
50 questions
Show answers
  • Q1
    What function is used to calculate the average of a set of numbers in Excel?
    SUM
    AVERAGE
    COUNT
    MAX
    30s
  • Q2
    Which of the following is a valid Excel formula for finding the largest number in a range?
    HIGHEST(A1:A10)
    BIGGEST(A1:A10)
    LARGEST(A1:A10)
    MAX(A1:A10)
    30s
  • Q3
    What symbol is used in Excel to start a formula?
    =
    @
    %
    $
    30s
  • Q4
    What feature in Excel allows users to sort data in ascending or descending order?
    Group
    Pivot
    Sort
    Filter
    30s
  • Q5
    Which function would you use to count the number of cells that contain numbers in a range?
    COUNTA
    AVERAGE
    SUM
    COUNT
    30s
  • Q6
    What is the primary purpose of using cell references in Excel formulas?
    To change the font size
    To dynamically use values from other cells
    To insert images
    To create text labels
    30s
  • Q7
    Which function would you use to find a specific value within a column and return a value from a different column in the same row?
    HLOOKUP
    VLOOKUP
    INDEX
    MATCH
    30s
  • Q8
    What does the 'Freeze Panes' feature allow you to do in Excel?
    Change the color of cells
    Keep specific rows or columns visible while scrolling
    Delete data from the worksheet
    Protect cells from editing
    30s
  • Q9
    What does the CONCATENATE function do in Excel?
    Joins two or more text strings together
    Finds the average of values
    Searches for a specific term
    Calculates the sum of numbers
    30s
  • Q10
    Which feature allows you to visually represent data trends over time in Excel?
    Chart
    Table
    Filter
    Cell
    30s
  • Q11
    What keyboard shortcut is used to save a workbook in Excel?
    Ctrl + P
    Ctrl + O
    Alt + F4
    Ctrl + S
    30s
  • Q12
    Which function in Excel is used to calculate the average of a range of cells?
    SUM
    MAX
    AVERAGE
    COUNT
    30s
  • Q13
    Which of the following features allows you to visually represent data in Excel?
    Charts
    Formulas
    Cells
    Tables
    30s
  • Q14
    What does the VLOOKUP function do in Excel?
    It searches for a value in the first column of a table and returns a value in the same row from a specified column.
    It formats cells
    It creates a pivot table
    It calculates variance
    30s
  • Q15
    Which of the following functions is used to round numbers in Excel?
    CEILING
    FLOOR
    ROUND
    TRUNC
    30s

Teachers give this quiz to your class