All Free Computer Science and IT MCQs with Answers

541. In a computer spreadsheet, SUM, AVERAGE, MIN and MAX are examples of __________ ?

• A. Calculations
• B. Formulas
• C. Functions
• D. Relative addressing

Explanation: SUM, AVERAGE, MIN and MAX are built-in Excel functions that perform standard calculations. A formula may use these functions, but the functions themselves are the named operations.

542. Ctrl+Shift+1 shortcut Keys in excel are used to __________?

• A. Format number in comma format
• B. Format number in currency format
• C. Format number in date format
• D. Format number in time format

Explanation: Ctrl+Shift+1 applies Excel's comma-style number format, normally showing thousands separators and two decimal places. Currency, date and time formats use different shortcuts.

543. Which Shortcut keys are used to strikethrough highlighted selection in Excel?

• A. Ctrl+4
• B. Ctrl+5
• C. Ctrl+6
• D. None of the above.

Explanation: Ctrl+5 applies or removes strikethrough formatting on the selected Excel cells. Ctrl+4 is associated with underline formatting, not strikethrough.

544. What is the smallest and largest font size available in Font Size tool on formatting toolbar?

• A. 6 and 72
• B. 6 and 68
• C. 8 and 72
• D. 7 and 72Quiz Mode Feature

Explanation: The traditional font-size list in Microsoft Office starts at 8 points and goes up to 72 points, although users can type additional sizes manually. Therefore 8 and 72 matches the standard toolbar range described here.

545. Which operation you will perform if you need to move a block of text?

• A. Copy and Paste
• B. Paste and Cut
• C. Cut and Paste
• D. Paste and Delete

Explanation: Cut removes the selected text while placing it on the clipboard, and Paste inserts it at the new location. Copy and Paste would duplicate the text rather than move it.

546. Ctrl + Z Shortcut is used in Microsoft Word to_____________?

• A. Undo the last Action
• B. Redo the last Action
• C. Add the new page
• D. Paste the contents from clipboard

Explanation: Ctrl+Z reverses the most recent action, such as typing, formatting or deleting text. Ctrl+Y is commonly used for redo, so it is not the function of Ctrl+Z.

547. Ctrl + W Shortcut is used in Microsoft Word to_____________?

• A. Save and Print the Document
• B. Save and Close Word Application
• C. Save and Close document
• D. Without Save, Close Document

Explanation: Ctrl+W closes the current document or window; Word asks whether to save if there are unsaved changes. It does not automatically save and print the document.

548. Ctrl + V Shortcut is used in Microsoft Word to_____________?

• A. Paste Texts in the beginning of Document
• B. Paste Images in the beginning of Document
• C. Paste Tables at the middle of Document
• D. None of the above

Explanation: Ctrl+V pastes copied or cut content at the current cursor position, which may be text, images, or tables. None of the options correctly describes this because they restrict the paste to a particular location or content type.

549. What is the function of CTRL+N in Microsoft Word?

• A. Save Document
• B. Open Document
• C. New Document
• D. Close Document

Explanation: Ctrl+N creates a new Word document. Ctrl+S saves, Ctrl+O opens, and Ctrl+W closes the current document.

550. Ctrl + M Shortcut is used in Microsoft Word to____________?

• A. New Document
• B. Close Document
• C. Right Indent
• D. Left Indent

Explanation: In Word, Ctrl+M increases a paragraph's left indentation, moving it farther from the left margin. It does not create or close a document.