Free MS Office MCQs with Answers

521. In Excel which key is used for format number in date format?

• A. Ctrl+Shift+6
• B. Ctrl+Shift+4
• C. Ctrl+Shift+3
• D. Shift+1

Explanation: Ctrl+Shift+3 applies the Date format in Excel. Ctrl+Shift+4 is used for currency formatting, so it is not the correct shortcut here.

522. In Excel which key is used for format number in currency format?

• A. Ctrl+Shift+1
• B. Ctrl+Shift+4
• C. Ctrl+1
• D. Shift+1

Explanation: Ctrl+Shift+4 applies Currency formatting in Excel, usually displaying a currency symbol and two decimal places. Ctrl+1 opens formatting options rather than directly applying this format.

523. In Excel which key is used for format number in comma format?

• A. Ctrl+Shift+1
• B. Ctrl+Shift+4
• C. Ctrl+1
• D. Shift+1

Explanation: Ctrl+Shift+1 applies Excel's comma-style number format with two decimal places. Ctrl+Shift+4 applies currency formatting, while Ctrl+1 opens the Format Cells dialog.

524. In Excel which key is used for create a formula to sum all of the above cells?

• A. Ctrl+=
• B. Alt+-
• C. Alt+=
• D. Ctrl+-

Explanation: Alt+= inserts Excel's AutoSum formula, normally adding the contiguous numeric cells above the active cell. The Ctrl+= combination is not the standard AutoSum shortcut.

525. In Excel which key is used to open the excel formula window?

• A. Shift+F6
• B. Shift+F3
• C. Alt+Shift+F3
• D. Alt+Shift+F6

Explanation: Shift+F3 opens Excel's Insert Function dialog, which helps users search for and build formulas. It is therefore the closest match to opening the formula window among these choices.

526. Which shortcut key is used to Fill Down?

• A. CTRL+D
• B. CTRL+T
• C. ALT+D
• D. ALT+D

Explanation: Ctrl+D uses Excel's Fill Down command to copy the contents or formula from the top cell of a selected range into the cells below. Ctrl+T creates a table instead.

527. Which key is used to insert new worksheet in excel?

• A. Alt+F2
• B. Alt+F1
• C. Alt+Shift+F1
• D. Alt+Shift+F2

Explanation: Alt+Shift+F1 inserts a new worksheet in Excel, equivalent to the commonly used Shift+F11 shortcut. Alt+F1 creates an embedded chart rather than a worksheet.

528. In Microsoft Word, Ctrl+1 is used for which of the following?

• A. To set 1.5 line spacing
• B. To set 0.5 line spacing
• C. Double line spacing
• D. Single line spacing

Explanation: In Microsoft Word, Ctrl+1 applies single line spacing to the selected paragraph or paragraphs. Ctrl+5 applies 1.5 spacing and Ctrl+2 applies double spacing.

529. Which key is used for find in excel?

• A. CTRL+C
• B. CTRL+F
• C. ALT+SHIFT+D
• D. ALT+SHIFT+F

Explanation: Ctrl+F opens Excel's Find dialog, allowing text, numbers, or formulas to be searched within the worksheet. Ctrl+C copies selected content rather than finding it.

530. Which key is used to create chart from selected data in excel?

• A. F11
• B. F1
• C. F10
• D. Both A & B

Explanation: F11 creates a chart from the selected data and places it on a separate chart sheet in Excel. Alt+F1 is the shortcut for placing a chart within the current worksheet.