Free MS Office MCQs with Answers

531. In Excel which key is used to Open the Format Cells window?

• A. Ctrl+F10
• B. Ctrl+6
• C. Ctrl+F1
• D. Ctrl+1

Explanation: Ctrl+1 opens Excel's Format Cells dialog, where number formats, alignment, fonts, borders, and protection can be changed. The other shortcuts do not open this window.

532. Which of the following basic action is performed with the help of mouse in the word's environment?

• A. Double click
• B. Drag and point
• C. Single click
• D. All of these

Explanation: Double-clicking, dragging or pointing, and single-clicking are all standard mouse actions in a word-processing environment. Therefore, the inclusive option is correct.

533. Which key is used to edit the selected cell in excel?

• A. F4
• B. F10
• C. F2
• D. Edit

Explanation: F2 puts the selected Excel cell into edit mode, allowing its contents to be modified directly. F4 repeats or cycles references in many Excel contexts, but does not edit a cell.

534. Which key is used to enter the current date in Excel?

• A. Ctrl+:
• B. Ctrl+;
• C. Ctrl+Shift+:
• D. Ctrl+Shift+;

Explanation: Ctrl+semicolon (Ctrl+;) inserts the current date as a fixed value in Excel. Ctrl+Shift+semicolon inserts the current time instead.

535. In Excel which key is used to select entire column?

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

Explanation: Ctrl+Space selects the entire column containing the active cell in Excel. Shift+Space selects the entire row, which is the common shortcut confusion here.

536. In Excel which key is used to select entire row?

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

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

537. You can detect spelling and grammar errors by ___________?

• A. Press Shift + F7
• B. Press Ctrl + F7
• C. Press Alt+ F7
• D. Press F7Fun & Trivia

Explanation: In Microsoft Word, F7 starts the spelling and grammar check. The text appended after F7 appears to be a scraping artifact, but the intended option is still identifiable.

538. What is the maximum number of columns that can be inserted in MS Word Table?

• A. 35
• B. 45
• C. 55
• D. 63
• E. 65Science

Explanation: A Microsoft Word table can contain a maximum of 63 columns. The value is a table-structure limit, not the number of columns visible on a page at one time.

539. In MS Word, What is the maximum scale percentage available in scale drop down box?

• A. 400
• B. 100
• C. 150
• D. 200
• E. 300

Explanation: Word’s character-scale setting can enlarge text up to 200% of its normal width. This setting changes horizontal character width, not font size.

540. How many columns can you insert in a word document in maximum?

• A. 35
• B. 45
• C. 55
• D. 63Windows OS

Explanation: A Word document can contain up to 63 newspaper-style columns. The extra text after option d is irrelevant formatting noise, but option d still gives the correct value.