Microsoft Excel Trivia
From PivotTable wizardry to the dark arts of VLOOKUP, prove you're not just another person who puts 'proficient in Excel' on their resume.
EXAMPLE QUESTIONS
Before you can calculate a sum or perform a lookup in a spreadsheet, every formula must begin with which punctuation mark?
Equal sign
When you open a brand-new workbook, what is the default name assigned to the very first worksheet tab?
Sheet1
Instead of using the plus sign for addition, which basic function is recommended to avoid errors by automatically ignoring text entries in a range?
SUM
When importing data, which specific column format should you select to prevent leading zeros from being removed in values like ZIP codes?
Text
In a Microsoft Excel spreadsheet, what specific shape and color appears in the upper-right corner of a cell to indicate that it contains a note or comment?
Red triangle