Free MS Office MCQs with Answers

201. Which short cut key is used to bring up the "Find and Replace" dialog box in Ms word?

• A. Ctrl + J
• B. Ctrl + H
• C. Ctrl + N
• D. Ctrl + M

Explanation: Ctrl+H opens Word's Find and Replace dialog, allowing text or formatting to be searched and substituted. Ctrl+J, Ctrl+N, and Ctrl+M perform different Word commands.

202. What is the shortcut key to display field codes?

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

Explanation: Alt+F9 toggles the display of field codes throughout a Word document. Shift+F9 toggles the selected field, while Ctrl+F9 inserts a new empty field.

203. Comment put on Excel cell which is displayed by taking the Mouse Pointer there, is called__________?

• A. Smart tip
• B. Soft Tip
• C. Web Tip
• D. Cell Tip

Explanation: In older Excel terminology, a cell comment that appears when the pointer is placed over the cell was called a cell tip. The other options are not standard Excel names for this feature.

204. In MS Excel to delete duplicate values which menu is used?

• A. Data
• B. Tools
• C. Formatting
• D. Layout

Explanation: Excel's Remove Duplicates command is located on the Data tab. Tools, Formatting, and Layout do not contain the standard duplicate-removal command.

205. How many rows are in one Microsoft Excel sheet?

• A. 65,536
• B. 16,384
• C. 1,048,576
• D. None of Above

Explanation: Modern Excel worksheets contain 1,048,576 rows, numbered from 1 through 1,048,576. The figure 65,536 applies to older Excel versions before Excel 2007.

206. How many columns are in one Microsoft Excel sheet?

• A. 65,536
• B. 16,384
• C. 1,048,576
• D. None of Above

Explanation: Modern Excel worksheets have 16,384 columns, labelled A through XFD. The 65,536 figure refers to the number of rows in older Excel versions, not current columns.

207. Which among following is not associated with spelling dialogue box?

• A. Edit
• B. Ignore All
• C. Ignore
• D. Change

Explanation: A spelling dialog normally includes commands such as Ignore, Ignore All and Change. Edit is not a standard spelling-dialog command, although it may appear in other editing contexts.

208. Top open an existing workbook, click the open button on the___________toolbar?

• A. form
• B. standard
• C. Drawing
• D. Formatting

Explanation: In classic Microsoft Office, commands such as Open were placed on the Standard toolbar. The Formatting and Drawing toolbars contain formatting and drawing controls instead.

209. If you press ___, the cell accepts your typing as its contents ?

• A. Tab
• B. Ctrl+Enter
• C. Enter
• D. Alt+Enter

Explanation: Pressing Enter confirms the text entered in a cell and moves the selection to the next row. Tab also confirms input but moves to the next column, so the standard expected answer here is Enter.

210. The default style for new data keyed in a new workbook is ___________?

• A. Comma
• B. Normal
• C. Currency
• D. Percent

Explanation: Normal is Excel's default cell style for newly entered data in a new workbook. Comma, Currency and Percent are specialised number formats rather than the default style.