Free MS Office MCQs with Answers

551. _________ is the shortcut key to select the entire column in Excel.

• A. Alt + Space bar
• B. Shift + Space bar
• C. Ctrl + Space bar
• D. None

Explanation: Ctrl+Spacebar selects the entire column containing the active cell in Excel. Shift+Spacebar selects the entire row, which is the common paired shortcut and the likely trap.

552. _________ is the shortcut key to select the entire row in Excel.

• A. Alt + Space bar
• B. Shift + Space bar
• C. Ctrl + Space bar
• D. None

Explanation: Shift+Spacebar selects the entire row containing the active cell in Excel. Ctrl+Spacebar performs the corresponding selection for the whole column.

553. Shortcut to insert new slide in the current presentation is ______________.

• A. Ctrl+N
• B. Ctrl+M
• C. Ctrl+O
• D. Ctrl+D
• E. None

Explanation: Ctrl+M inserts a new slide in PowerPoint. Ctrl+N creates a new presentation, while Ctrl+O opens an existing file and Ctrl+D commonly duplicates a selected object or slide.

554. Which shortcut key is used for calculating current sheet in Ms Excel?

• A. Ctrl+F9
• B. Shift+F9
• C. F9
• D. F7

Explanation: Shift+F9 recalculates the active worksheet in Excel. F9 recalculates all open workbooks, while Ctrl+F9 has a different function.

555. Shortcut key to open Font dialog box is ____________.

• A. Ctrl+Shift+D
• B. Ctrl+Alt+ D
• C. Ctrl+D
• D. Alt+D

Explanation: In Microsoft Word, Ctrl+D opens the Font dialog box, where font type, style, size, and effects can be changed. The other shortcuts do not open this dialog.

556. Which language does MS-Word use to create Macros?

• A. Visual C++
• B. Visual Java
• C. Visual Basic
• D. None of the above

Explanation: Microsoft Word macros are created using Visual Basic for Applications, commonly called VBA. VBA is based on Visual Basic, not Visual C++ or Java.

557. Which language is used to create macros in Excel?

• A. Visual Basic
• B. C
• C. Visual C++
• D. Java

Explanation: Excel macros are normally written in Visual Basic for Applications, or VBA. The other listed languages are not Excel's standard macro language.

558. Ctrl+B is used to?

• A. To underline the selected text
• B. To save the text
• C. To Bold the selected text
• D. To itallic the text

Explanation: Ctrl+B applies bold formatting to selected text in MS Word and many other editors. Underlining uses Ctrl+U, saving uses Ctrl+S, and italics uses Ctrl+I.

559. ____________is the process of making changes to a document's existing content.

• A. Creating
• B. Editing
• C. Cutting
• D. Forming

Explanation: Editing means modifying existing document content, including correcting, adding, deleting, or rearranging text. Creating refers to producing a new document, while cutting is only one editing operation.

560. Pressing F8 key for three time selects____________?

• A. A sentence
• B. A paragraph
• C. A word
• D. Entire document

Explanation: In Microsoft Word, repeated presses of F8 expand the selection: after selecting a word, the third press selects the sentence. Further presses extend the selection to a paragraph and then the whole document.