
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.
Microsoft Excel trivia questions and answers
When a formula is copied, what type of reference changes its row and column automatically to match its new position?
Show answerHide answer
Relative reference
A reference such as A1 is relative by default. Copying it one column to the right changes it to B1.
What is the standard notation for a reference that locks both the column and the row when a formula is copied?
Show answerHide answer
$A$1
The dollar signs make both parts of the reference absolute, so copying the formula does not shift either part.
What kind of cell reference locks either the column or the row, but not both?
Show answerHide answer
Mixed reference
Examples include $A1, which locks the column, and A$1, which locks the row.
Which built-in function adds the values in a specified range of cells?
Show answerHide answer
SUM
A formula such as =SUM(B2:B10) totals every numeric value in that range.
Which built-in function calculates the arithmetic mean of a group of numbers?
Show answerHide 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.

