All Free Computer Science and IT MCQs with Answers

461. Format painter in PowerPoint?

• A. To paint pretty pictures on your slides
• B. To copy formatting from one object or piece of text and then apply it elsewhere
• C. To change the background color of your slides
• D. To paint pretty pictures on background of slides

Explanation: Format Painter copies formatting such as font, colour, size and effects from one object or text selection to another. It does not create drawings or change a slide's background.

462. Letters in Excel denote: ______________?

• A. Columns
• B. rows
• C. numbers
• D. reference

Explanation: Excel labels columns with letters such as A, B and C, while rows are labelled with numbers. A cell reference combines both, such as B4.

463. Short cut key ctrl + A use for __________?

• A. To Select All Text
• B. To copy
• C. To paste
• D. None

Explanation: Ctrl+A selects all content in the active context, such as all text in a document or all cells in a worksheet region. Ctrl+C and Ctrl+V are the copy and paste shortcuts respectively.

464. Select the correct shortcut key which is used to underline a written paragraph?

• A. CTRL + T
• B. CTRL + U
• C. CTRL + Z
• D. CTRL + B

Explanation: Ctrl+U applies or removes underlining in common word-processing applications. Ctrl+B applies bold, while Ctrl+Z undoes the last action.

465. What is the shortcut key for spelling to check in document ________ ?

• A. F1
• B. F2
• C. F5
• D. F7

Explanation: F7 opens the spelling and grammar check in Microsoft Word. F1 opens Help, F2 is used for editing or renaming in several contexts, and F5 commonly opens Go To or starts a presentation.

466. How to use drop cap in MS word?

• A. Go to the Ribbon > Insert tab
• B. Go to the Bar > Insert tab
• C. Both
• D. None

Explanation: In Word, Drop Cap is accessed from the Insert tab, usually through the Text group. “Bar” is not the name of the relevant Word interface element.

467. Which shortcut key is used to print a document?

• A. Ctrl+M
• B. Ctrl+N
• C. Ctrl+P
• D. None of these

Explanation: Ctrl+P opens the Print command in most document and office applications. Ctrl+M and Ctrl+N are commonly used for indentation or creating a new document, depending on the application.

468. What is gutter margin in Ms Word?

• A. Margin that is added to the left margin when printing
• B. Margin that is added to right margin when printing
• C. Margin that is added to the binding side of page when printing
• D. Margin that is added to the outside of the page when printing

Explanation: A gutter is extra space added on the binding side of a printed page so that binding does not cover the text. Its position can be on the left, right, or top depending on the binding layout.

469. How do you display current date and time in MS Excel ?

• A. Date()
• B. Year()
• C. Now()
• D. Time()

Explanation: NOW() returns both the current date and current time in Excel. DATE() constructs a date, while TIME() constructs a time without the current date.

470. Which shortcut key is used to create chart in MS Excel?

• A. F10
• B. F12
• C. F11
• D. None

Explanation: In classic desktop Excel, F11 creates a chart on a separate chart sheet, while Alt+F1 creates a chart within the current worksheet. Therefore F11 is the intended shortcut here.