Free MS Office MCQs with Answers

636 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.

636 questions · page 3 of 64

21. Where does the file name appear on the MS Word window ?

  • 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. The status bar displays document information such as page and word counts.

Correct answer: Title Bar

22. What is the use of a horizontal Scroll Bar in MS Excel?

  • 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. Vertical movement through rows is handled by the vertical scroll bar.

Correct answer: to view the data from left to the right

23. 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. Ctrl+Z performs the opposite operation by undoing an action.

Correct answer: CTRL+Y

24. Shortcut key to Remove paragraph formatting is_________________________?

  • 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. Ctrl+E centers a paragraph, while Ctrl+S saves the document.

Correct answer: Ctrl + Q

25. Ctrl +U is used for ____________________?

  • 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

26. Which one can be used for creating a document _______________________?

  • 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. Excel is primarily for spreadsheets, and Access is primarily for databases.

Correct answer: MS Word

27. In MS Word, the shortcut for paste command is _________________________?

  • 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 operation.

Correct answer: Ctrl+V

28. The .xls extension is used for _________________________ files?

  • 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. Modern Excel workbooks usually use .xlsx, but .xls remains an Excel extension.

Correct answer: Excel

29. Which short cut key used for help ?

  • A. F1
  • B. F2
  • C. F3
  • D. F4

Explanation: F1 opens the Help system in Windows and in most Microsoft Office applications. F2 through F4 perform different application-specific commands and are not the standard Help key.

Correct answer: F1

30. Which shortcut key is for auto sum ?

  • 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. The other shortcuts do not directly invoke AutoSum.

Correct answer: Alt + =