Information and Communication Technology MCQ

61. Where would you find the letters "QWERTY"?

Correct Answer: Correct answer is: (C) Keyboard.

Exam Relevance: SAT, ACT, GED

Difficulty: Easy

Concept notes: The letters "QWERTY" are commonly found on a standard keyboard layout.

Common Mistakes: Students might confuse the QWERTY layout with other input devices or layouts.

Explanations: The QWERTY layout is a standard arrangement of letters on a keyboard. The first six letters on the top left of the keyboard spell out "QWERTY," making it a recognizable pattern. Light pens and numeric pads do not typically feature the QWERTY layout.

Option Analysis:

Option A: Light pens are used for input on computer screens and do not have a QWERTY layout.
Option B: Numeric pads are designed for numerical input and do not include the QWERTY layout.
Option C: Keyboards use the QWERTY layout for letter input.
Option D: Since only keyboards have the QWERTY layout, this option is incorrect.

Mnemonic: QWERTY - Quick Witty Eager Rabbit Taps Yieldingly

62. Choose an example of an Input Device?

Correct Answer: Correct answer is: (C) The Keyboard.

Exam Relevance: SAT, ACT, AP Computer Science Principles

Difficulty: Very Easy

Concept notes: An input device is a hardware component that allows users to enter data or commands into a computer.

Common Mistakes: Students may confuse input devices with output devices, such as speakers or screens, which are used to display or output information from the computer.

Explanations: The keyboard is an input device because it allows users to input data and commands into a computer. It is used to type text, enter commands, and control the computer's functions.

Option Analysis:

Option A: Speakers are output devices, not input devices. They are used to produce sound from the computer.
Option B: The screen is an output device, not an input device. It is used to display visual information from the computer.
Option C: The keyboard is an input device, as it allows users to input data and commands into the computer.
Option D: This option is incorrect because the keyboard is indeed an input device.

63. The cell address A4 in a formula implies that it is a

Correct Answer: Correct answer is: (C) Relative cell reference.

Exam Relevance: SAT, ACT, AP Computer Science Principles

Difficulty: Easy

Concept notes: In spreadsheet software, a relative cell reference changes when a formula is copied to a new location. An absolute cell reference remains constant, and a mixed cell reference has one part that is absolute and one part that is relative.

Common Mistakes: Students often confuse relative and absolute cell references. They may think that A4 is an absolute reference because it specifies a particular cell, but it is actually relative as it changes when the formula is copied.

Explanations: A4 is a relative cell reference because it changes when the formula is copied to a different cell. For example, if a formula in cell B1 references A4 and is then copied to cell B2, the reference will change to A5. This is the behavior of a relative cell reference.

Option Analysis:

Option A: A mixed cell reference would have a $ symbol in it, such as $A4 or A$4, which is not the case for A4.
Option B: An absolute cell reference would be $A$4, which is fixed and does not change when copied.
Option C: A relative cell reference like A4 changes when the formula is copied to a different cell.
Option D: This is incorrect as A4 is a valid cell reference type.

Mnemonic: Remember: "Relative references Relate and change."

64. QWERTY is used with reference to

Correct Answer: Correct answer is: (C) Keyboard.

Exam Relevance: SAT, ACT, GED

Difficulty: Very Easy

Concept notes: QWERTY refers to the standard layout of keys on a typewriter or computer keyboard.

Common Mistakes: Students might confuse QWERTY with other input devices like the mouse or printer.

Explanations: QWERTY is a specific arrangement of keys on a keyboard designed to reduce the likelihood of mechanical keys jamming. It is named after the first six letters on the top left letter row of the keyboard. This layout is widely used in English-language keyboards and is not applicable to other computer hardware like monitors, printers, or mice.

Option Analysis:

Option A: QWERTY is not related to the monitor, which is a display device.
Option B: QWERTY is not related to the printer, which is a device for printing text or images.
Option C: QWERTY is the standard layout for the keyboard, which is used for inputting text and commands.
Option D: QWERTY is not related to the mouse, which is a pointing device.

65. DNS Stands for

Correct Answer: Correct answer is: (B) Domain Name System.

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

Difficulty: Very Easy

Concept notes: DNS stands for Domain Name System, which is a hierarchical and decentralized naming system for computers, services, or other resources connected to the Internet or a private network.

Common Mistakes: Students may confuse DNS with other acronyms that start with "D" such as Do Not Specify or Dynamic Network System.

Explanations: DNS is the correct term for the system that translates human-readable domain names into IP addresses. It is a fundamental component of the Internet infrastructure, enabling users to access websites and services using easy-to-remember names instead of numerical IP addresses.

Option Analysis:

Option A: Do Not Specify is incorrect as it does not relate to the naming system used for the Internet.
Option B: Domain Name System is the correct term for the system that translates domain names into IP addresses.
Option C: Dynamic Network System is incorrect as it does not refer to the naming system used for the Internet.
Option D: Downloading System is incorrect as it does not relate to the naming system used for the Internet.

Mnemonic: DNS: Domain Name System, Decipher Names Simply

66. A digital video camera that is used to capture moving images and is connected to the internet so the video can be seen by others remotely. They are often included as part of the screen in computers or bought separately and connected to a USB port.

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

Exam Relevance: SAT, ACT, AP Computer Science Principles

Difficulty: Easy

Concept notes: A webcam is a digital video camera that captures moving images and can be connected to the internet to allow remote viewing.

Common Mistakes: Students may confuse a webcam with a touchscreen, which is a display that can detect the presence and location of a touch within the display area.

Explanations: A webcam is designed to capture video and transmit it over the internet, making it suitable for remote viewing. It is often integrated into computer screens or can be connected via a USB port. This matches the description given in the question.

Option Analysis:

Option A: Webcam is the correct answer as it fits the description of a device that captures moving images and can be connected to the internet for remote viewing.
Option B: A tracker ball is a pointing device that is not used for capturing video or connecting to the internet.
Option C: A touchscreen is an input device that allows users to interact with a display using touch, but it does not capture video.
Option D: TFT (thin film transistor) is a type of display technology and not a device for capturing video.

Mnemonic: Webcam: Web + Cam (Web + Camera)

67. Word processing, spreadsheet, and photo-editing are examples of

Correct Answer: Correct answer is: (A) Application software.

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

Difficulty: Easy

Concept notes: Application software includes programs designed to perform specific tasks for users, such as word processing, spreadsheet creation, and photo editing.

Common Mistakes: Students may confuse application software with system software, which manages computer operations rather than providing direct user functionality.

Explanations: Word processing, spreadsheet, and photo-editing software are designed to perform specific tasks for users. These programs are categorized as application software because they directly interact with the user to accomplish particular objectives, such as creating documents, managing data, or editing images. System software, on the other hand, manages the computer's operations and resources, and does not directly provide user functionality.

Option Analysis:

Option A: Correct. Application software includes programs like word processors, spreadsheets, and photo editors.
Option B: Incorrect. Platform software is not a standard term and does not apply to the given examples.
Option C: Incorrect. System software manages computer operations and does not include user-specific applications.
Option D: Incorrect. Operating system software is a type of system software that manages computer hardware and software resources, not user-specific applications.

68. MS Excel is a.....

Correct Answer: Correct answer is: (A) Window based spreadsheet package.

Exam Relevance: SAT, ACT, AP Computer Science Principles

Difficulty: Very Easy

Concept notes: MS Excel is a software application designed for organizing, analyzing, and storing data in spreadsheets. It is a window-based application, meaning it runs on the Windows operating system.

Common Mistakes: Students may confuse MS Excel with DOS-based applications, which are older and run on the MS-DOS operating system.

Explanations: MS Excel is a window-based spreadsheet package because it operates within the graphical user interface (GUI) of the Windows operating system. It is not a DOS-based application, which would run in a text-based environment. It is also not an accounting package, although it can be used for accounting tasks.

Option Analysis:

Option A: Correct. MS Excel is a window-based spreadsheet package.
Option B: Incorrect. MS Excel is not a DOS-based application.
Option C: Incorrect. MS Excel is a spreadsheet package, not an accounting package.
Option D: Incorrect. The correct answer is provided in option A.

69. You can enter which types of data into worksheet cells?

Correct Answer: Correct answer is: (A) Labels, values, and formulas.

Exam Relevance: SAT, ACT, AP Computer Science Principles

Difficulty: Easy

Concept notes: In a worksheet, cells can contain labels, values, and formulas.

Common Mistakes: Students may mistakenly believe that cells can only contain values or formulas, but not labels.

Explanations: Cells in a worksheet can store different types of data. Labels are used for text entries, values are numerical data, and formulas are used to perform calculations. Therefore, the correct answer is that cells can contain labels, values, and formulas.

Option Analysis:

Option A: Correct. Cells can contain labels, values, and formulas.
Option B: Incorrect. Cells can also contain formulas.
Option C: Incorrect. Cells can also contain labels.
Option D: Incorrect. Cells can contain more than just formulas.

Mnemonic: L-V-F: Labels, Values, Formulas

70. How can you get your photo album slide show to play continuously?

Correct Answer: Correct answer is: (C) Loop continuously.

Exam Relevance: SAT, ACT, AP Computer Science Principles

Difficulty: Easy

Concept notes: The concept of looping in a photo album slide show refers to the feature that allows the slideshow to repeat itself continuously without stopping.

Common Mistakes: Students may mistakenly think that random slide transition or launching an online broadcast would make the slideshow play continuously, but these options do not inherently ensure continuous playback.

Explanations: The correct answer is to loop continuously because this feature ensures that the photo album slide show will repeat itself indefinitely, creating a seamless and continuous viewing experience. Random slide transition (Option A) changes the order of slides but does not ensure continuous playback. Launching an online broadcast (Option B) is a method of sharing the slideshow but does not affect its continuous playback. Option D is incorrect because not all options listed are correct.

Option Analysis:

Option A: Random slide transition changes the order of slides but does not ensure continuous playback.
Option B: Launching an online broadcast is a method of sharing the slideshow but does not affect its continuous playback.
Option C: Loop continuously ensures the slideshow repeats itself indefinitely, creating a continuous viewing experience.
Option D: All of the above is incorrect because not all options listed are correct.

Mnemonic: Loop for Looping

⬅ Previous SetSet 7Next Set ➡

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

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 7”

Leave a Reply