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
- 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- 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 right23. In a windows pc, the shortcut key for redoing the last action in Microsoft PowerPoint is __________?
- 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- 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- 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- 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- 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- 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- 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- 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 + =- 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- 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- 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- 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.- 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- 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- 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- 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- 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- 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