Information and Communication Technology MCQ

201. Which command on the Ribbon enables the document to be viewed as it would appear on a webpage?

Correct Answer: Correct answer is: (B) Web Layout.

Exam Relevance: Microsoft Office Certification, Google Workspace Certification

Difficulty: Easy

Concept notes: The Web Layout view in document editing software allows users to see how a document will appear when viewed as a webpage.

Common Mistakes: Students may confuse Web Layout with Internet Layout, which is not a standard option in most document editing software.

Explanations: The Web Layout view is specifically designed to show how a document will look when converted to a webpage. This feature is useful for ensuring that the formatting and layout of the document are appropriate for web viewing.

Option Analysis:

Option A: Internet Layout is not a standard view option in document editing software.
Option B: Web Layout is the correct view to see how a document will appear on a webpage.
Option C: None of the Above is incorrect because Web Layout is a valid option.
Option D: All the above is incorrect because only Web Layout is the correct option.

Mnemonic: W for Web, W for Webpage

202. This is used to manipulate text documents and text entered via a keyboard; the software has such features as editing, saving and manipulating text; copy-paste; spell checker and thesaurus; importing photos, text and spreadsheets; translation of the text into other languages.

Correct Answer: Correct answer is: (A) Word Processor.

Exam Relevance: SAT, ACT, AP Computer Science Principles

Difficulty: Easy

Concept notes: A word processor is a software application used for creating, editing, and manipulating text documents. It includes features such as editing, saving, copy-paste, spell checking, thesaurus, importing photos and spreadsheets, and text translation.

Common Mistakes: Students may confuse a word processor with other software applications like command-line interfaces or operating systems, which do not have the same text manipulation and editing features.

Explanations: A word processor is specifically designed to handle text documents and includes features such as editing, saving, copy-paste, spell checking, thesaurus, importing photos and spreadsheets, and text translation. These features make it the correct choice for the described functionalities.

Option Analysis:

Option A: Word Processor is the correct choice as it includes all the mentioned features.
Option B: Command-line interface is used for executing commands and does not have text manipulation features.
Option C: Operating systems manage computer hardware and software resources but do not include text editing features.
Option D: HDD/SSD are storage devices and do not have text manipulation capabilities.

203. EBCDIC is

Correct Answer: Correct answer is: (C) 8-bit coding system.

Exam Relevance: Computer Science Exams, Information Technology Exams

Difficulty: Easy

Concept notes: EBCDIC (Extended Binary Coded Decimal Interchange Code) is an 8-bit character encoding used primarily in IBM mainframe and IBM midrange computer operating systems.

Common Mistakes: Students may confuse EBCDIC with ASCII, which is a 7-bit coding system.

Explanations: EBCDIC is an 8-bit coding system, meaning each character is represented by 8 bits. This allows for a larger set of characters compared to 7-bit systems like ASCII. The 8-bit structure is essential for the encoding scheme used in EBCDIC, which is designed to support a wide range of characters and symbols.

Option Analysis:

Option A: EBCDIC is not a 6-bit coding system. It uses 8 bits per character.
Option B: EBCDIC is not a 7-bit coding system. It uses 8 bits per character.
Option C: EBCDIC is an 8-bit coding system, which is correct.
Option D: EBCDIC is not a 9-bit coding system. It uses 8 bits per character.

Mnemonic: EBCDIC: Eight Bits Code Decimal Interchange Code

204. The 2's complement of a binary no. is obtained by adding.....to its 1's complement.

Correct Answer: Correct answer is: (B) 1.

Exam Relevance: Computer Science Exams, Digital Logic Exams, Electrical Engineering Exams

Difficulty: Easy

Concept notes: The 2's complement of a binary number is obtained by adding 1 to its 1's complement.

Common Mistakes: Students often confuse 1's complement and 2's complement, leading to errors in binary arithmetic.

Explanations: The 1's complement of a binary number is obtained by flipping all the bits (changing 0s to 1s and 1s to 0s). To get the 2's complement, you add 1 to the 1's complement. This process is used to represent negative numbers in binary arithmetic.

Option Analysis:

Option A: Adding 0 to the 1's complement does not change the value, so it is incorrect.
Option B: Adding 1 to the 1's complement correctly gives the 2's complement.
Option C: Adding 10 (binary for 2) is not the correct method for obtaining the 2's complement.
Option D: Adding 12 (binary for 1100) is not the correct method for obtaining the 2's complement.

205. Which of the following keyboard shortcut is used to edit existing Excel data?

Correct Answer: Correct answer is: (A) F2.

Exam Relevance: Microsoft Office Specialist, High School Computer Science Exams

Difficulty: Very Easy

Concept notes: The F2 key is used to edit existing data in Excel.

Common Mistakes: Students may confuse F2 with other function keys, such as F4, which repeats the last action, or F5, which opens the Go To dialog box.

Explanations: In Excel, pressing the F2 key allows you to edit the content of a cell directly. This is a quick way to modify existing data without having to click inside the cell and then edit the formula bar.

Option Analysis:

Option A: Correct. F2 is used to edit existing data in Excel.
Option B: Incorrect. F1 is used to access Excel's help system.
Option C: Incorrect. F4 is used to repeat the last action or to cycle through cell references in a formula.
Option D: Incorrect. F5 is used to open the Go To dialog box.

Mnemonic: F2 for Fix, as in fixing or editing existing data.

206. Which of the following is not a logic gate?

Correct Answer: Correct answer is: (D) NAT.

Exam Relevance: SAT, ACT, AP Computer Science Principles

Difficulty: Very Easy

Concept notes: The question tests the knowledge of basic logic gates.

Common Mistakes: Students might mistakenly think NAT is a logic gate because it sounds similar to NOT.

Explanations: AND, OR, and NOT are well-known logic gates used in digital circuits. NAT is not a recognized logic gate.

Option Analysis:

Option A: AND is a logic gate that outputs true only when all inputs are true.
Option B: OR is a logic gate that outputs true if at least one input is true.
Option C: NOT is a logic gate that inverts the input signal.
Option D: NAT is not a recognized logic gate.

Mnemonic: AND, OR, NOT - NOT NAT

207. Which PowerPoint view displays each slide of the presentation as a thumbnail and is useful for rearranging slides.....

Correct Answer: Correct answer is: (A) Slide sorter.

Exam Relevance: Microsoft Office Specialist, High School Computer Science Exams

Difficulty: Easy

Concept notes: The slide sorter view in PowerPoint allows users to view all slides of a presentation as thumbnails, making it easy to rearrange, duplicate, or delete slides.

Common Mistakes: Students may confuse the slide sorter view with the slide master view, which is used to modify the layout and design of slides.

Explanations: The slide sorter view in PowerPoint displays each slide as a thumbnail, which is useful for rearranging slides, as it provides a bird's-eye view of the entire presentation. This view is specifically designed to facilitate the organization and reordering of slides, making it the correct answer.

Option Analysis:

Option A: Correct. The slide sorter view displays each slide as a thumbnail, which is useful for rearranging slides.
Option B: Incorrect. The slide master view is used to modify the layout and design of slides, not to rearrange them.
Option C: Incorrect. The notes page view is used to add and view notes for each slide, not to rearrange slides.
Option D: Incorrect. This option is not applicable as the correct answer is provided in option A.

Mnemonic: Slide sorter: "Sort slides like a puzzle."

208. Databases are made up of one or more .....

Correct Answer: Correct answer is: (A) Tables.

Exam Relevance: AP Computer Science Principles, IB Computer Science, SAT Subject Test in Computer Science

Difficulty: Easy

Concept notes: Databases are structured collections of data organized into tables.

Common Mistakes: Students may confuse databases with file systems or spreadsheets, which are different types of data storage.

Explanations: Databases are composed of one or more tables. Each table contains rows and columns, where rows represent individual records and columns represent fields or attributes of those records. This structure allows for efficient data storage, retrieval, and management.

Option Analysis:

Option A: Correct. Databases are made up of one or more tables.
Option B: Incorrect. While databases can be stored in files, the term "files" does not accurately describe the internal structure of a database.
Option C: Incorrect. "File types" refer to the format of files, not the structure of a database.
Option D: Incorrect. Spreadsheets are a type of application for organizing data, but they are not the fundamental structure of a database.

Mnemonic: Think "T" for Tables in Databases.

209. Which of the following Shortcut key is used to duplicate the Current Slide in MS PowerPoint?

Correct Answer: Correct answer is: (B) Ctrl + D.

Exam Relevance: CAT, GRE, GMAT, Microsoft Certification Exams

Difficulty: Easy

Concept notes: The shortcut key Ctrl + D is used to duplicate the current slide in MS PowerPoint.

Common Mistakes: Students may confuse this with other common shortcuts like Ctrl + C (copy) or Ctrl + V (paste).

Explanations: In MS PowerPoint, the shortcut key Ctrl + D duplicates the current slide. This is a useful function for quickly creating multiple slides with the same content, which can then be modified as needed. The other options do not perform this specific function: Ctrl + V is for pasting content, Ctrl + E is for centering text, and Ctrl + M is for inserting a new slide.

Option Analysis:

Option A: Ctrl + V is used for pasting content, not duplicating slides.
Option B: Ctrl + D is the correct shortcut for duplicating the current slide.
Option C: Ctrl + E is used for centering text, not duplicating slides.
Option D: Ctrl + M is used for inserting a new slide, not duplicating the current one.

Mnemonic: D for Duplicate, D for Duplicating.

210. Eric finished a meeting early with a client and wants to catch up on his project management tasks. Eric notices that the local coffee shop has free Wi-Fi access. What network hardware is allowing Eric to connect his computer to the Wi-Fi network?

Correct Answer: Correct answer is: (A) Access Point.

Exam Relevance: CCNA, CompTIA Network+, CIW Network Specialist

Difficulty: Easy

Concept notes: An access point is a device that allows wireless devices to connect to a wired network.

Common Mistakes: Students may confuse an access point with a router, which is a device that routes data between networks.

Explanations: An access point is the network hardware that allows Eric to connect his computer to the Wi-Fi network. It provides the wireless connection between Eric's computer and the local network, enabling him to access the internet and other network resources.

Option Analysis:

Option A: Correct. An access point is the device that provides wireless connectivity to a network.
Option B: Incorrect. A router is used to route data between different networks, not to provide wireless access.
Option C: Incorrect. A switch is used to connect multiple devices within a network, but it does not provide wireless access.
Option D: Incorrect. A gateway is a device that connects two different networks, but it does not provide wireless access.

Mnemonic: AP for Access Point, like "APple" for Apple.

⬅ Previous SetSet 21Next Set ➡

3 thoughts on “Information and Communication Technology MCQ - Set 21”

Peter Ross April 8, 2020

The MCQ is quite entertaining and will help in increasing knowledge also.
Reyaz Ahmad khan December 26, 2020

plz help me in regard with current Affairs
Eshita Nandpal April 11, 2021

Plz give make a part of unit wise

3 thoughts on “Information and Communication Technology MCQ - Set 21”

Leave a Reply