Microsoft Office
0Loading crowd target
0Loading crowd target
6correct to beat the crowd
50 free Microsoft Office trivia questions with answers — science & nature quiz, new questions added Oct 2026.
Microsoft Office has been part of working life for more than three decades. Most people open Word, Excel or PowerPoint every week, yet few know where the suite came from, what its keyboard shortcuts really do, or why a spreadsheet once pushed scientists to rename part of the human genome. This quiz covers the whole family. Expect questions on everyday tools in Word, formulas and error messages in Excel, presentation tricks in PowerPoint, email in Outlook and the newer Office 365 apps, along with the history of the suite, its famous animated helper and a few hidden surprises. It suits students revising for a computer class, teachers who need a ready-made quiz, and colleagues planning a trivia round at work. Every question comes with the answer and a short explanation, so you pick up a new trick even when you miss one.
30 of 50 questions with answers and explanations. Play the quiz
Q 01Microsoft Office first went on sale in 1989 for which computer, a year before its Windows version?
Macintosh
Macintosh users got the suite first, in a 1989 bundle of Word, Excel, PowerPoint and Mail that began as a limited-time promotion before becoming a regular product.
Q 02Clippy, the paperclip helper that arrived with Office 97, was officially given which name?
Clippit
Clippit was the name in every version of Office that had the helper, but the public's nickname stuck so firmly that Microsoft's own marketing later borrowed it.
Q 03In 2020 scientists renamed 27 human genes because Microsoft Excel kept converting their names into what?
Dates
Dates were the trouble: Excel read the gene MARCH1 as 1 March and SEPT1 as 1 September, so the naming committee changed them to MARCHF1 and SEPTIN1.
Q 04Which kind of hidden game did programmers tuck inside Microsoft Excel 97 as a secret Easter egg?
A flight simulator
A flight simulator sat hidden in the spreadsheet, and the same Office 97 release tucked a pinball game inside Word and a Magic 8 Ball inside its database program.
Q 05Which webmail service, bought by Microsoft in 1997, was fully replaced by Outlook.com in 2013?
Hotmail
Hotmail cost Microsoft an estimated $400 million and had been running since 1996, long enough to carry the MSN and Windows Live brands before its final rename.
Q 06Microsoft's OneDrive had to drop its original name after a trademark case won by which broadcaster?
Sky
Sky won a High Court ruling in 2013 that the name SkyDrive breached its trademark, and the service relaunched under its new name in February 2014.
Q 07Which AI assistant did Microsoft announce in March 2023 to draft and summarise work in Office apps?
Copilot
Copilot began as a work version of Bing Chat, and within two years Microsoft had renamed the whole Microsoft 365 app and website after it.
Q 08Office 2007 replaced the old menu bars and toolbars with which tabbed strip of commands?
The Ribbon
The Ribbon arrived as part of what Microsoft called the Fluent User Interface, and Office 2010 made it the main interface of every program in the suite.
Q 09Which Microsoft app gradually replaced Skype for Business as the chat hub of Office 365?
Teams
Teams was announced in November 2016 as a direct competitor to Slack, a company Microsoft had considered buying for $8 billion earlier that year.
Q 10Microsoft Excel deliberately treats 1900 as a leap year to match which older rival spreadsheet?
Lotus 1-2-3
Lotus 1-2-3 had the bug first, put there, it is thought, as a shortcut for handling leap years, and Excel copied it so that old files would calculate the same way.
Q 11Which Microsoft Word pioneer later paid his own way to the International Space Station twice?
Charles Simonyi
Charles Simonyi began the word processor in 1981 after building Bravo at Xerox PARC, then flew to the station aboard Soyuz craft in 2007 and 2009.
Q 12Which typeface replaced Calibri as the default font across Microsoft Office in 2023?
Aptos
Aptos beat four rival candidates and was first called Bierstadt, after a mountain in Colorado, before being renamed for a place in California.
Q 13Which serif typeface was Microsoft Word's default font before Calibri took over in Office 2007?
Times New Roman
Times New Roman gave way to Calibri in Word, while the same 2007 release dropped Arial as the default in Excel, PowerPoint and Outlook.
Q 21Which symbol, placed before a column letter or row number, makes an Excel cell reference absolute?
Dollar sign
Dollar sign locks whichever part it precedes, so $B$4 stays put when a formula is copied, while $B4 or B$4 fixes only the column or only the row.
Q 22Which Excel tool summarises long lists when users drag fields into rows, columns and values?
PivotTable
PivotTable fields default to a SUM in the Values area, but if Excel reads the data as text it quietly switches to a COUNT, a frequent cause of puzzling totals.
Q 23A Microsoft Excel cell fills with a row of which symbols when its column is too narrow for a number?
Hash signs
Hash signs, shown as #####, are not a formula fault at all, and they vanish as soon as the column is dragged wide enough to show the full contents.
Q 14PowerPoint was created at which startup, bought by Microsoft for about $14 million in 1987?
Forethought
Forethought had planned to give the program a different name until a trademark check failed, and its purchase was Microsoft's first significant acquisition.
Q 15Which 1999 virus spread through an infected Word document and mailed itself to 50 contacts via Outlook?
Melissa
Melissa overloaded mail servers at more than 300 organisations, pushed Microsoft to suspend its own outgoing email for hours, and cost an estimated $80 million to clean up.
Q 16Since Office 2007, Word and Excel files have been zip-compressed packages of which markup language?
XML
XML explains the x on the end of extensions such as .docx and .xlsx, while an m in that place marks a file that contains macros.
Q 17Which programming language, built into Office since Excel 5.0 in 1993, is used to write macros?
VBA
VBA, short for Visual Basic for Applications, ended an era when each Microsoft program had its own incompatible macro language, such as WordBASIC.
Q 18Which Office app for laying out flyers and newsletters did Microsoft announce in 2024 it would retire?
Publisher
Publisher was pitched at small businesses without designers on staff, and the announcement set 13 October 2026 as the end of a run that began in 1991.
Q 19Which Microsoft Office program is a database manager built around tables, queries and reports?
Access
Access stores its data with an engine originally called Jet and can also link directly to data kept in other programs and databases.
Q 20In Microsoft Excel, every formula typed into a cell must begin with which symbol?
Equal sign
Equal sign is the rule: an entry that starts without one is not a formula and will not be calculated, a slip Microsoft's own help pages call a common mistake.
Q 24Columns in a modern Excel worksheet run from A to which three-letter label, the 16,384th column?
XFD
XFD marks the far-right edge of the grid, a huge jump from the 256 columns ending at IV that the program allowed before its 2007 version.
Q 25Which Excel function did Microsoft announce in 2019 as the successor to the long-serving VLOOKUP?
XLOOKUP
XLOOKUP fixes two old annoyances: it defaults to an exact match, and it can return a value from a column to the left of the one being searched.
Q 26Which Excel command on the View tab keeps header rows in sight while the rest of the sheet scrolls?
Freeze Panes
Freeze Panes locks the rows above and the columns to the left of the selected cell, so labels stay put however far the data runs.
Q 27Which Excel feature recolours cells automatically according to rules about the values they hold?
Conditional Formatting
Conditional Formatting can paint data bars, colour scales and icon sets across a range, which makes patterns and trends far easier to spot.
Q 28Which error value does Microsoft Excel display when a formula points to a cell that has been deleted?
#REF!
Excel's #REF!, short for reference, flags an address that is no longer valid and also appears when cells a formula relied on are pasted over.
Q 29Which Excel what-if tool works backwards from a desired result to find the input a formula needs?
Goal Seek
Goal Seek adjusts a single input until the formula hits its target, for example finding the interest rate that brings a loan payment down to what a borrower can afford.
Q 30Which Microsoft Word feature turns one standard letter into a personalised copy for every name on a list?
Mail Merge
Mail Merge pulls each recipient's details from a data source such as a list, spreadsheet or database, and it can produce labels, envelopes and bulk email as well.