placeholder image to represent content

Excel

Quiz by Akshith Dutt

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
7 questions
Show answers
  • Q1
    Which Excel function would you use to find the average of a range of cells?
    AVERAGE
    MAX
    SUM
    COUNT
    30s
  • Q2
    What function would you use in Excel to concatenate two strings of text?
    MERGE
    CONCATENATE
    COMBINE
    JOIN
    30s
  • Q3
    Which Excel feature allows you to automatically fill a series of numbers or dates?
    AutoFill
    Data Validation
    Flash Fill
    Conditional Formatting
    30s
  • Q4
    What would you use to create a dropdown list in Excel?
    Pivot Table
    VLOOKUP
    Conditional Formatting
    Data Validation
    30s
  • Q5
    Which function would you use to search for a specific value in a column and return a corresponding value from another column in Excel?
    HLOOKUP
    MATCH
    INDEX
    VLOOKUP
    30s
  • Q6
    In Excel, which symbol is used to indicate an absolute cell reference?
    &
    @
    #
    $
    30s
  • Q7
    What is the purpose of the IF function in Excel?
    To calculate averages
    To create charts
    To sort data
    To perform conditional logic
    30s

Teachers give this quiz to your class