Office Suite Showdown

Microsoft Word

100

Which shortcut key is used to save a document in Microsoft Word?

CTRL+S

200

Under which Tab in MS Word do you find a command to create a  Table of Contents for your documents?

Reference

300

Which feature in Word allows you to automatically format a document with consistent headings, titles, and text styles?

Styles

400

In which Tab in MS Word gives you a portrait or a landscape layout of the paper?

Layout Tab

Microsoft Excel

100

Which function in Excel is used to add the values in a range of cells?

SUM

200

Which Excel feature allows you to summarize data with simple drag-and-drop operations?

Pivot

300

What do you call that MS-Excel feature that ensures the data entered into a cell meets specific criteria or rules?

Data Validation

400

In the Review Tab, this feature prevents unwanted changes from others by limiting the ability to edit the worksheet.

Protect Sheet

Microsoft Powerpoint

100

Which shortcut key is used to start the slideshow from the beginning in PowerPoint?

F5

200

Which feature allows you to apply a consistent look across all slides in a PowerPoint presentation?

Slide Master

300

In what Tab in MS PowerPoint can you find the feature where you can rehearse and record a narration for your presentation?

Slide Show Tab

400

In MS PowerPoint, these visual effects occur when you move from one slide to the next during a presentation.

Transitions

General Office Features

100

What is the name of the feature in Microsoft Office that allows you to find and insert pre-designed templates?

Templates

200

Which Microsoft Office feature allows you to access and edit documents from anywhere, on any device?

OneDrive

300

Which feature in Microsoft Office allows you to translate text into different languages?

Translator

400

What feature allows you to automate repetitive tasks across different Microsoft Office applications using scripts?

VBA or Office Script

Productivity Tips

100

What keyboard shortcut can be used to copy selected text or objects in any Microsoft Office application?

CTRL + C

200

What shortcut key combination can you use to switch between open applications in Windows, including Office apps?

Alt + Tab

300

What keyboard shortcut allows you to duplicate a slide in MS Powerpoint?

CTRL + D

400

To automatically highlight important data in MS Excel, what feature should you use?

Conditional formatting