Microsoft Excel Trivia Questions

Put your spreadsheet know-how to the test, from formulas and functions to charts and pivot tables. See how much you know about the tool used to organize, analyze, and visualize data.

15 questions · 10 per game

Microsoft Excel trivia questions and answers

  1. When a formula is copied, what type of reference changes its row and column automatically to match its new position?

    Show answer

    Relative reference

    A reference such as A1 is relative by default. Copying it one column to the right changes it to B1.

  2. What is the standard notation for a reference that locks both the column and the row when a formula is copied?

    Show answer

    $A$1

    The dollar signs make both parts of the reference absolute, so copying the formula does not shift either part.

  3. What kind of cell reference locks either the column or the row, but not both?

    Show answer

    Mixed reference

    Examples include $A1, which locks the column, and A$1, which locks the row.

  4. Which built-in function adds the values in a specified range of cells?

    Show answer

    SUM

    A formula such as =SUM(B2:B10) totals every numeric value in that range.

  5. Which built-in function calculates the arithmetic mean of a group of numbers?

    Show answer

    AVERAGE

    Blank cells and text entries in referenced cells are generally ignored by this function.

How to play

  • • Each game has 10 questions. Before each one you see only a hint about its topic.
  • • Choose what it’s worth, from $1 to $20. Each value can only be used once per game.
  • • Type your answer. Small spelling mistakes are fine. Get it right and you win that amount.

Related categories