50 Fun Facts About Microsoft Office

Microsoft Office first went on sale in 1989 for which computer, a year before its Windows version?

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.

Clippy, the paperclip helper that arrived with Office 97, was officially given which name?

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.

In 2020 scientists renamed 27 human genes because Microsoft Excel kept converting their names into what?

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.

Which kind of hidden game did programmers tuck inside Microsoft Excel 97 as a secret Easter egg?

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.

Which webmail service, bought by Microsoft in 1997, was fully replaced by Outlook.com in 2013?

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.

Microsoft's OneDrive had to drop its original name after a trademark case won by which broadcaster?

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.

Which AI assistant did Microsoft announce in March 2023 to draft and summarise work in Office apps?

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.

Office 2007 replaced the old menu bars and toolbars with which tabbed strip of commands?

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.

Which Microsoft app gradually replaced Skype for Business as the chat hub of Office 365?

Teams was announced in November 2016 as a direct competitor to Slack, a company Microsoft had considered buying for $8 billion earlier that year.

Microsoft Excel deliberately treats 1900 as a leap year to match which older rival spreadsheet?

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.

Which Microsoft Word pioneer later paid his own way to the International Space Station twice?

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.

Which typeface replaced Calibri as the default font across Microsoft Office in 2023?

Aptos beat four rival candidates and was first called Bierstadt, after a mountain in Colorado, before being renamed for a place in California.

Which serif typeface was Microsoft Word's default font before Calibri took over in Office 2007?

Times New Roman gave way to Calibri in Word, while the same 2007 release dropped Arial as the default in Excel, PowerPoint and Outlook.

PowerPoint was created at which startup, bought by Microsoft for about $14 million in 1987?

Forethought had planned to give the program a different name until a trademark check failed, and its purchase was Microsoft's first significant acquisition.

Which 1999 virus spread through an infected Word document and mailed itself to 50 contacts via Outlook?

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.

Since Office 2007, Word and Excel files have been zip-compressed packages of which markup language?

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.

Which programming language, built into Office since Excel 5.0 in 1993, is used to write macros?

VBA, short for Visual Basic for Applications, ended an era when each Microsoft program had its own incompatible macro language, such as WordBASIC.

Which Office app for laying out flyers and newsletters did Microsoft announce in 2024 it would retire?

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.

Which Microsoft Office program is a database manager built around tables, queries and reports?

Access stores its data with an engine originally called Jet and can also link directly to data kept in other programs and databases.

In Microsoft Excel, every formula typed into a cell must begin with which symbol?

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.

Which symbol, placed before a column letter or row number, makes an Excel cell reference absolute?

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.

Which Excel tool summarises long lists when users drag fields into rows, columns and values?

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.

A Microsoft Excel cell fills with a row of which symbols when its column is too narrow for a number?

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.

Columns in a modern Excel worksheet run from A to which three-letter label, the 16,384th column?

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.

Which Excel function did Microsoft announce in 2019 as the successor to the long-serving VLOOKUP?

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.

Which Excel command on the View tab keeps header rows in sight while the rest of the sheet scrolls?

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.

Which Excel feature recolours cells automatically according to rules about the values they hold?

Conditional Formatting can paint data bars, colour scales and icon sets across a range, which makes patterns and trends far easier to spot.

Which error value does Microsoft Excel display when a formula points to a cell that has been deleted?

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.

Which Excel what-if tool works backwards from a desired result to find the input a formula needs?

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.

Which Microsoft Word feature turns one standard letter into a personalised copy for every name on a list?

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.

Which Microsoft Word feature strikes through every deletion so a reviewer can accept or reject it?

Track Changes also underlines every addition and gives each author a different colour, so it is always clear who altered what.

Which Office tool on the Home tab copies the font, colour and size of one piece of text onto another?

Format Painter normally works for one use only, but double-clicking its paintbrush keeps it switched on for several selections until Esc is pressed.

Which page orientation in Microsoft Word turns the sheet on its side, wider than it is tall?

Landscape takes its name from painting, where a canvas with more width than height was needed to capture the horizon within the artist's view.

In Microsoft Word, a red squiggly line under a word flags a possible mistake in what?

Spelling slips get the red squiggle while possible grammar problems are marked in another colour, and both kinds of underline can be switched off.

In Microsoft Word, which margin adds extra space where the pages of a document will be bound?

Gutter space keeps text from being hidden by the binding, and Word can add it at the side, at the top or along the inside edges of facing pages.

In PowerPoint, what is the name for the special effect that plays as one slide gives way to the next?

A transition belongs to a whole slide, whereas an animation is applied to a single element on it, such as a shape, an image or a line of text.

Which PowerPoint view lets a single edit to fonts or a logo flow through an entire presentation?

Slide Master edits are best made before any content is added, because slides built earlier need their changed layouts reapplied by hand.

Which PowerPoint mode shows the speaker their notes on a laptop while the audience sees only the slides?

Presenter View also offers a pen and laser pointer for marking up slides, and newer versions switch it on automatically once a second screen is connected.

Which key starts a PowerPoint slide show from the very first slide on a Windows keyboard?

F5 always begins at the opening slide, while holding Shift with the same key starts the show from whichever slide is currently selected.

In Microsoft Word and Excel, which command does the keyboard shortcut Ctrl+Z carry out?

Undo reverses the previous action, and its partner shortcut Ctrl+Y puts the change back again if the reversal turns out to be a mistake.

In Microsoft Word, pressing Ctrl+K with some text selected opens the dialog box for which task?

Insert a hyperlink is also what Ctrl+K does in Excel and PowerPoint, so one shortcut handles links across the main Office programs.

In Microsoft Word, pressing Ctrl+Enter pushes the text that follows onto a new sheet by inserting what?

A page break comes from Ctrl+Enter alone, while adding Shift to the same combination inserts a column break instead.

In Microsoft Word, pressing the F12 key on its own opens which dialog box?

Save As appears when F12 is pressed alone, while Shift+F12 simply saves the document without asking for a new name or location.

Office 2010 introduced which full-window screen, opened from the File tab, for saving and printing?

Backstage view borrows a theatre term for the place where preparation happens out of sight, and it replaced the Office menu of the 2007 release.

Which Office app, first released in 2003, files pages into sections like a digital ring binder?

OneNote was designed to resemble a tabbed ring binder, and in 2015 Microsoft removed almost all of the feature restrictions on its free version.

Which diagramming program joined the Office family after Microsoft bought its maker in 2000?

Visio first shipped in 1992 from a company called Shapeware, which renamed itself after its own product three years later to trade on the name's recognition.

Which Office 365 app, launched in 2016, lets teachers build surveys and quizzes that mark themselves?

Forms started out under the name Office 365 Forms, and Microsoft puts a notice beneath every Submit button warning people not to give out a password.

Links, a helper offered alongside Clippy from Office 2000 onwards, was a cartoon of which animal?

A cat it was, sharing the line-up with a dog called Rocky and, from Office XP, a wizard named Merlin.

Which template file opens whenever Microsoft Word starts and holds the default styles for new documents?

Normal.dotm is so central that if it is renamed, damaged or moved, Word automatically builds a fresh copy the next time it starts.

Pressing Ctrl+H in Microsoft Word, one key along from the Go To shortcut, opens which dialog box?

Find and Replace handles more than words, because the same box can also swap specific formatting and special items throughout a document.