Quizalize logo
placeholder image to represent content

POP QUIZ ON THE BASICS Excel

Quiz by Kel Jackson

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
21 questions
Show answers
  • Q1
    What function would you use in Excel to find the average of a set of numbers?
    COUNT
    AVERAGE
    SUM
    MAX
    30s
  • Q2
    In Excel, what symbol is used to start a formula?
    =
    @
    $
    #
    30s
  • Q3
    Which feature in Excel allows you to visualize data with graphs?
    Cells
    Tables
    Charts
    Comments
    30s
  • Q4
    What would you use to automatically fill a series of numbers or dates in Excel?
    Insert Function
    AutoFill
    Data Validation
    Format Painter
    30s
  • Q5
    Which of the following is a way to apply formatting to a cell in Excel?
    Cell Styles
    Conditional Formatting
    Data Sorting
    Text Wrap
    30s
  • Q6
    What is the purpose of the IF function in Excel?
    To sort data in ascending order
    To format cells with specific styles
    To perform a logical test and return different values based on the result
    To sum a range of values
    30s
  • Q7
    Which function would you use to find the highest number in a range of cells in Excel?
    MAX
    SUM
    AVERAGE
    MIN
    30s
  • Q8
    What is the function of the SUM formula in Excel?
    Counts the number of cells
    Finds the maximum value in a range
    Calculates the total of a range of cells
    Determines the average of a set of numbers
    30s
  • Q9
    Which of the following is a type of chart you can create in Excel?
    Bar chart
    Table of contents
    Text box
    Folder
    30s
  • Q10
    What is the purpose of cell formatting in Excel?
    To move cells to another sheet
    To delete cells
    To change the appearance of cells
    To automatically calculate data
    30s
  • Q11
    What is a formula in Excel?
    A type of chart
    A way to format text
    A graphic design tool
    A math equation that performs calculations on values in cells
    30s
  • Q12
    What is the purpose of the Freeze Panes feature in Excel?
    To create a backup of the workbook
    To merge multiple cells
    To keep specific rows or columns visible while scrolling
    To delete unwanted data
    30s
  • Q13
    What is the purpose of using conditional formatting in Excel?
    To insert images
    To change the appearance of cells based on specific conditions
    To create formulas
    To merge cells together
    30s
  • Q14
    What does the COUNT function do in Excel?
    Adds all the numbers in a range
    Finds the average of a group of numbers
    Counts all cells, including blanks
    Counts the number of cells that contain numbers
    30s
  • Q15
    Which function is used in Excel to find the average of a set of numbers?
    AVERAGE
    MAX
    SUM
    COUNT
    30s

Teachers give this quiz to your class