Quizalize logo
placeholder image to represent content

Spreadsheets using Excel

Quiz by Adam Masters

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
18 questions
Show answers
  • Q1
    In Excel, what function is used to calculate the average of a set of numbers?
    MAX
    AVERAGE
    SUM
    COUNT
    30s
  • Q2
    What feature in Excel allows you to visually represent your data with bars, lines, or pie slices?
    Cell
    Macro
    Chart
    Formula
    30s
  • Q3
    Which function would you use in Excel to find the highest number in a range of cells?
    AVERAGE
    MIN
    COUNT
    MAX
    30s
  • Q4
    In Excel, what symbol is used to start a formula?
    #
    @
    =
    $
    30s
  • Q5
    Which Excel function would you use to count the number of cells that contain numerical data?
    COUNTA
    COUNT
    AVERAGE
    SUM
    30s
  • Q6
    What does the VLOOKUP function do in Excel?
    Counts the number of rows
    Sorts data in ascending order
    Finds the maximum value
    Looks up a value in a table and returns a corresponding value
    30s
  • Q7
    In Excel, what does the '$' symbol do when used in a cell reference?
    It formats the cell as currency
    It makes the reference relative
    It creates an absolute reference
    It adds a comment to the cell
    30s
  • Q8
    What is a pivot table used for in Excel?
    To format cells
    To write formulas
    To summarize and analyze complex data
    To create charts
    30s
  • Q9

    What is the symbol used when writing a formula to multiply?

    *

    +

    x

    X

    30s
  • Q10

    What is a "worksheet"?

    A page in a spreadsheet

    A single column in a spreadsheet

    A header in a spreadsheet

    A formula in a spreadsheet

    30s
  • Q11

    What is a label?

    A piece of text that identifies cell content

    A formula

    A chart title

    A numeric value

    30s
  • Q12

    What formula should you use when adding up a lot of numbers?

    =MULTIPLY

    =SUM

    =AVERAGE

    =ADD

    30s
  • Q13

    Money in cells should be formatted as what?

    Text

    Currency

    General

    Percentage

    30s
  • Q14

    How can you draw attention to a table by formatting it?

    Use text wrapping

    Use borders and background colors

    Use headers

    Use formulas

    30s
  • Q15

    You can join a number of cells together. This is called what?

    Wrapping text

    Merging cells

    Auto fill

    Formatting cells

    30s

Teachers give this quiz to your class