All Free Computer Science and IT MCQs with Answers

1001. Shortcut key to double underline the selected text is _______.

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

Explanation: Ctrl+Shift+D applies double underline formatting to selected text in Microsoft Word. The similar Ctrl+U shortcut applies only a single underline.

1002. ____________ is the shortcut key to display active cell in Excel.

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

Explanation: Ctrl+Backspace in Excel scrolls the worksheet so the active cell is brought into view. It does not delete the active cell or move to a different cell.

1003. Shortcut key to insert a new worksheet in Excel is ____________.

• A. Shift + F8
• B. Shift + F9
• C. Shift + F10
• D. Shift + F11

Explanation: Shift+F11 inserts a new worksheet in an Excel workbook. The nearby function-key shortcuts listed do not perform this worksheet-insertion command.

1004. _________ 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.

1005. _________ 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.

1006. 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.

1007. 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.

1008. 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.

1009. 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.

1010. 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.