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
What specific mathematical symbol must be typed first to signal that a cell contains a formula rather than plain text?
Equal sign
What powerful Excel tool allows users to quickly summarize and analyze large datasets in a cross-tabulated report?
PivotTable
What function, whose name is short for "vertical lookup," searches for a specific value in the first column of a table and returns data from the same row?
VLOOKUP
If you want to display data as slices that make up a single whole, which familiar chart type would you insert?
Pie chart
What is the name of the visual, button-based filter panel that allows users to quickly narrow down data within a PivotTable or table?
Slicer