Free MS Office MCQs with Answers

141. Which of these key are used in ms excel to insert current time In workbook.

• A. Ctrl + Shift + ;
• B. Ctrl+!
• C. Ctrl+*
• D. None of these

Explanation: In Excel, Ctrl + Shift + semicolon (;) inserts the current time into the selected cell. The related shortcut Ctrl + ; inserts the current date.

142. Getting data from a cell located In a different sheet is called ___________?

• A. Accessing
• B. Referencing
• C. Updating
• D. Functioning

Explanation: Using data from a cell on another worksheet is called referencing, usually written with a sheet reference such as Sheet2!A1. Updating changes data, while accessing is only a general description.

143. Which is the Shortcut key to Apply the Normal style?

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

Explanation: In Microsoft Word, Ctrl + Shift + N applies the Normal style to selected text or the current paragraph. Ctrl + Shift + M decreases paragraph indentation, so it is a common distractor.

144. Which Shortcut key is used for Bold Command ?

• A. Ctrl + C
• B. Ctrl + B
• C. Ctrl + W
• D. Ctrl + I

Explanation: Ctrl + B toggles bold formatting in common word processors and many text-editing applications. Ctrl + C copies, Ctrl + W closes a window, and Ctrl + I applies italics.

145. Shortcut key 1.5 line spacing ?

• A. Ctrl+ 3
• B. Ctrl+ 4
• C. Ctrl+ 5
• D. Ctrl+6

Explanation: In Microsoft Word, Ctrl + 5 applies 1.5-line paragraph spacing. Ctrl + 3 applies triple spacing, while Ctrl + 1 applies single spacing.

146. This display the positioning of text, tabs, margin, indents, and other elements on the page:

• A. Ruler
• B. Status Bar
• C. Document window
• D. Cursor

Explanation: The ruler displays page margins, tab stops, paragraph indents, and text positioning. The status bar mainly shows document information such as page number and word count.

147. You can edit existing Excel data by pressing the:________ key?

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

Explanation: In Excel, F2 activates the selected cell for editing and places the cursor in its existing contents. F1 opens Help, while F3 and F4 perform other functions.

148. A number of letter that appears little above the normal text is called?

• A. Superscript
• B. Subscript
• C. Supertext
• D. Toptext

Explanation: Superscript places a character or number above the normal text line, as in x². Subscript places it below the line, as in H₂O.

149. Name the Desktop database application that is part of MS Office suit.

• A. MS Access
• B. MS Excel
• C. MS PowerPoint
• D. None of the above

Explanation: Microsoft Access is the desktop relational database application in the Microsoft Office suite. Excel is primarily a spreadsheet, while PowerPoint is used for presentations.

150. Which one is the spreadsheet application that comes with MS Office software group?

• A. MS Word
• B. MS Excel
• C. MS PowerPoint
• D. MS Access

Explanation: Microsoft Excel is the spreadsheet application in the Office suite, designed for cells, formulas, data analysis and charts. Word is for documents, PowerPoint for presentations and Access for databases.