Free MS Office MCQs with Answers

640 MS Office MCQs from Computer Science and IT, each with the correct answer and a written explanation of why it is correct. Free and unlimited, with no account needed.

MS Office covers the main tools and features of Word, Excel, PowerPoint and Access. Content includes document formatting, mail merge, formulas and functions, charts, worksheets, presentations, database tables, queries and reports, along with common file extensions, shortcuts and the difference between workbook, worksheet, slide and document concepts.

Last updated

640 questions · page 2 of 32

Fairly easy
  • A. Home Bar
  • B. Status Bar
  • C. Title Bar
  • D. Ribbon
  • E. None of these

Explanation: The title bar identifies the active Word document, commonly showing its filename along with Microsoft Word.

Correct answer: Title Bar
Fairly easy
  • A. to view the data from left to the right
  • B. to view the data in Excel from up and down
  • C. to view the data from right to the left
  • D. None of these

Explanation: A horizontal scroll bar moves across worksheet columns, allowing data to be viewed from left to right or back again.

Correct answer: to view the data from left to the right
Fairly easy
  • A. CTRL+R
  • B. CTRL+Z
  • C. CTRL+Y
  • D. CTRL+ O

Explanation: Ctrl+Y repeats or redoes the most recently undone action in PowerPoint and other Microsoft Office programs.

Correct answer: CTRL+Y
Moderate
  • A. Ctrl + S
  • B. Ctrl + Q
  • C. Ctrl + E
  • D. Ctrl + LMS Word templates

Explanation: Ctrl+Q removes direct paragraph formatting in Word and returns the paragraph to its style formatting.

Correct answer: Ctrl + Q
Easy
  • A. underline
  • B. italic
  • C. bold
  • D. none

Explanation: Ctrl+U toggles underline formatting for selected text or for text typed next. Ctrl+I is italic and Ctrl+B is bold.

Correct answer: underline
Easy
  • A. MS Excel
  • B. MS Word
  • C. MS Access
  • D. None

Explanation: MS Word is designed for creating and formatting text documents such as letters and reports.

Correct answer: MS Word
Easy
  • A. Ctrl+V
  • B. Ctrl+X
  • C. Alt+X
  • D. Shift+Alt+X
  • E. Ctrl+C

Explanation: Ctrl+V pastes content from the Clipboard into the document. Ctrl+C copies content and Ctrl+X cuts it, so neither performs the paste…

Correct answer: Ctrl+V
Fairly easy
  • A. Windows
  • B. Excel
  • C. Power Point
  • D. Access
  • E. Word

Explanation: The .xls extension identifies the older binary workbook format used by Microsoft Excel.

Correct answer: Excel
Fairly easy
  • A. F1
  • B. F2
  • C. F3
  • D. F4

Explanation: F1 opens the Help system in Windows and in most Microsoft Office applications.

Correct answer: F1
Moderate
  • A. Alt + =
  • B. Ctrl + Shift
  • C. Alt + F1
  • D. Ctrl + =

Explanation: In Excel, Alt + = inserts the AutoSum formula and usually selects the adjacent range automatically.

Correct answer: Alt + =
Moderate
  • A. Right
  • B. Center
  • C. Left
  • D. Top

Explanation: Left, right, and top are standard page-margin positions. Center is an alignment position, not a page margin.

Correct answer: Center
Very hard
  • A. 42767
  • B. 32767
  • C. 52755
  • D. unlimited

Explanation: A Microsoft Word table can contain up to 32,767 rows. This is a fixed Word table limit, not an unlimited value.

Correct answer: 32767
Moderate
  • A. Reference Tab
  • B. View Tab
  • C. Review Tab
  • D. Layout Tab

Explanation: New Window, Arrange All, and Split are window-management commands found on Word's View tab.

Correct answer: View Tab
Hard
  • A. add the selected text to the Index.
  • B. add the selected text to the Table of Authorities
  • C. add the selected text to the Level 01
  • D. None of these

Explanation: Mark Entry marks selected text as an index entry, allowing Word to include it in the document's index.

Correct answer: add the selected text to the Index.
Hard
  • A. Minimise one Windows click on another
  • B. Zoom bar > Click on Read mode
  • C. Review>> Compare
  • D. View>>Windows gallery>> View Side by Side

Explanation: View > Window > View Side by Side displays two open Word documents beside each other for comparison or simultaneous reading.

Correct answer: View>>Windows gallery>> View Side by Side
Moderate
  • A. Mailings Tab
  • B. Review Tab
  • C. File menu
  • D. Reference Tab

Explanation: Restrict Editing is available on Word's Review tab, where permissions and editing restrictions can be configured.

Correct answer: Review Tab
Hard
  • A. Preview Window
  • B. Options Menu
  • C. Page layout tab
  • D. Backstage view

Explanation: The Backstage view, opened through the File tab, contains document information, properties, inspection, and other file-management…

Correct answer: Backstage view
Moderate
  • A. To Clear all shapes
  • B. To Clear all data
  • C. Clear the formatting from the text
  • D. To Clear text

Explanation: Clear Formatting removes applied font and paragraph formatting while leaving the actual text in place.

Correct answer: Clear the formatting from the text
Moderate
  • A. Styles Gallery
  • B. Font Gallery
  • C. Editing Gallery
  • D. None

Explanation: Strikethrough is a character-formatting command in the Font group, alongside bold, italic, underline, and related effects.

Correct answer: Font Gallery
Hard
  • A. Title Bar
  • B. Customize Quick Access Toolbar
  • C. Tabs Bar
  • D. Status Bar

Explanation: Undo, Redo, and Save are commonly placed on the Quick Access Toolbar, which can be customized with frequently used commands.

Correct answer: Customize Quick Access Toolbar