Information and Communication Technology MCQ

781. In Excel say that you want to paste a formula result.....but not the underlying formula.....to another cell. In excel 2002, you would copy the cell with the formula, then place the insertion point in the cell you want to copy to what next?

Correct Answer: Correct answer is: (C) Click the arrow on the paste button on the standard toolbar, then click values.

Exam Relevance: Microsoft Office Specialist, Excel Certification

Difficulty: Easy

Concept notes: In Excel, the "Paste Values" option allows you to copy only the result of a formula, not the formula itself.

Common Mistakes: Students may mistakenly choose the "Paste" button without realizing it will copy the formula, not just the value.

Explanations: To paste only the result of a formula in Excel 2002, you need to use the "Paste Values" option. This is done by clicking the arrow on the Paste button on the standard toolbar and then selecting "Values." This ensures that only the calculated result is pasted, not the underlying formula.

Option Analysis:

Option A: This option will paste both the formula and the result, not just the result.
Option B: This option will paste only the formulas, not the values.
Option C: This option correctly pastes only the values, not the formulas.
Option D: This option is incorrect because not all options are correct.

782. What is the address given to a computer connected to a network called?

Correct Answer: Correct answer is: (C) IP Address.

Exam Relevance: CCNA, CompTIA Network+, A+

Difficulty: Easy

Concept notes: An IP address is a unique identifier assigned to a device connected to a network. It allows devices to communicate with each other over the network.

Common Mistakes: Students may confuse IP address with other types of addresses like MAC addresses or system IDs, which serve different purposes.

Explanations: An IP address is the correct term for the unique identifier assigned to a device on a network. It enables communication between devices by providing a standardized way to locate and address each device. Other options like SYSID, System Address, and Process ID do not specifically refer to the unique identifier used for network communication.

Option Analysis:

Option A: SYSID is not a standard term for a network address.
Option B: System Address is a general term and not specific to network communication.
Option C: IP Address is the correct term for the unique identifier assigned to a device on a network.
Option D: Process ID is an identifier for processes within an operating system, not for network communication.

Mnemonic: IP for Internet Protocol, like a postal address for the internet.

783. I am going to write a letter to my bank. Which piece of software do I need to use

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

Exam Relevance: SAT, ACT, GCSE, A-Level

Difficulty: Easy

Concept notes: A word processor is used to create and edit documents such as letters.

Common Mistakes: Students may confuse a word processor with a web browser, which is used for browsing the internet rather than creating documents.

Explanations: A word processor is the appropriate software for writing a letter because it allows for the creation and formatting of text documents. Web browsers, databases, and spreadsheets are not designed for this purpose.

Option Analysis:

Option A: A web browser is used for accessing the internet and viewing web pages, not for creating documents.
Option B: A word processor is used for creating and editing text documents, making it the correct choice for writing a letter.
Option C: A database is used for storing and managing data, not for creating documents.
Option D: A spreadsheet is used for organizing and analyzing numerical data, not for creating documents.

784. Steps

Correct Answer: Correct answer is: (A) Input > Process > Output.

Exam Relevance: SAT, ACT, AP Computer Science

Difficulty: Easy

Concept notes: The correct sequence in a system or process is typically Input, followed by Process, and then Output.

Common Mistakes: Students may confuse the order, thinking that Output comes before Process.

Explanations: In a system or process, data or materials are first input into the system. This input is then processed or transformed according to the system's rules or functions. Finally, the processed data or materials are output as the result. This sequence ensures that the system operates logically and efficiently.

Option Analysis:

Option A: Correct. The sequence Input > Process > Output is the standard order in a system or process.
Option B: Incorrect. This sequence does not follow the logical order of a system or process.
Option C: Incorrect. This sequence does not follow the logical order of a system or process.
Option D: Incorrect. This option suggests that none of the given sequences are correct, which is not true.

Mnemonic: IPO: Input, Process, Output

785. The memory which allocates space for DOS and application is called

Correct Answer: Correct answer is: (D) Conventional memory.

Exam Relevance: AP Computer Science Principles, A+ Certification

Difficulty: Easy

Concept notes: Conventional memory is the primary memory space in DOS systems where the operating system and applications are loaded and run.

Common Mistakes: Students may confuse conventional memory with expanded memory, which is used for additional memory beyond the standard 640KB limit in DOS.

Explanations: Conventional memory is the primary memory space in DOS systems, typically up to 640KB, where the operating system and applications are loaded and run. This memory is directly accessible by the CPU and is essential for the operation of DOS and its applications.

Option Analysis:

Option A: Expanded memory is used for additional memory beyond the standard 640KB limit in DOS, not for the primary allocation of DOS and applications.
Option B: Cache memory is a high-speed memory used to store frequently accessed data, not for DOS and application allocation.
Option C: Virtual memory is a technique that uses disk space to simulate additional RAM, not the primary memory for DOS and applications.
Option D: Conventional memory is the correct choice as it is the primary memory space for DOS and applications.

786. Which of the following is the definition of a constant?

Correct Answer: Correct answer is: (C) A value that cannot be altered by the program during normal execution: the value stays the same.

Exam Relevance: AP Computer Science, IB Computer Science, GCSE Computer Science

Difficulty: Easy

Concept notes: A constant is a value that remains unchanged throughout the execution of a program.

Common Mistakes: Students may confuse constants with variables, which can change their values during program execution.

Explanations: A constant is defined as a value that cannot be altered by the program during normal execution. This means that once a constant is assigned a value, it remains the same throughout the program's runtime. This is in contrast to variables, which can be modified as the program runs.

Option Analysis:

Option A: This describes a variable, not a constant, as the number of attempts can change.
Option B: This describes pseudocode, not a constant.
Option C: This correctly defines a constant as a value that remains unchanged during program execution.
Option D: This describes comments, not a constant.

787. Who among the following is known for starting the "Free Software movement" in September 1983 and GNU Project to develop software that would free users from the restrictive licenses imposed by software companies?

Correct Answer: Correct answer is: (C) Richard Stallman.

Exam Relevance: GRE, GMAT, Competitive Programming Exams

Difficulty: Easy

Concept notes: Richard Stallman is known for starting the "Free Software movement" and the GNU Project in 1983.

Common Mistakes: Students may confuse Richard Stallman with other figures in the open-source community, such as Linus Torvalds.

Explanations: Richard Stallman initiated the Free Software movement in September 1983 to promote software freedom and the GNU Project to develop a free operating system. This movement and project aimed to ensure that software users have the freedom to run, study, share, and modify the software.

Option Analysis:

Option A: Georg C. F. Greve is not associated with the Free Software movement or the GNU Project.
Option B: Benjamin Mako Hill is not associated with the Free Software movement or the GNU Project.
Option C: Richard Stallman is the correct answer as he is the founder of the Free Software movement and the GNU Project.
Option D: Robert J. Chassell is not associated with the Free Software movement or the GNU Project.

Mnemonic: RSM - Richard Stallman, Free Software Movement

788. Which Unit is used to measure the speed of a printer?

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

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

Difficulty: Easy

Concept notes: The speed of a printer is typically measured in pages per minute (PPM).

Common Mistakes: Students may confuse CPM (characters per minute) with PPM, which is used for measuring the speed of printers.

Explanations: The speed of a printer is measured in pages per minute (PPM). This unit indicates how many pages the printer can produce in one minute. CPM (characters per minute) is not a standard unit for measuring printer speed.

Option Analysis:

Option A: CPM is not the correct unit for measuring printer speed.
Option B: PPM is the correct unit for measuring printer speed.
Option C: None of the Above is incorrect as PPM is a valid unit.
Option D: All the above is incorrect as only PPM is the correct unit.

789. A storage area used to store data to a compensate for the difference in speed at which the different units can handle data is

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

Exam Relevance: Computer Architecture, Operating Systems, Data Structures

Difficulty: Easy

Concept notes: A buffer is a temporary storage area used to compensate for the difference in speed at which different units can handle data.

Common Mistakes: Students may confuse a buffer with memory, which is a more general term for data storage.

Explanations: A buffer is specifically designed to handle the speed mismatch between different components in a system. For example, a buffer can store data temporarily while a slower component catches up, ensuring smooth data flow without loss or delay.

Option Analysis:

Option A: Memory is a general term for data storage and does not specifically address the speed mismatch issue.
Option B: Buffer is the correct term for a temporary storage area used to compensate for speed differences.
Option C: Accumulator is a register in a CPU used for arithmetic and logic operations, not for buffering data.
Option D: Address is a location in memory, not a storage area for compensating speed differences.

Mnemonic: Buffer: Balance, Flow, Undergo, Reconcile, Enhance, Rhythms

790. Read Only Memory is permanent memory and is called:

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

Exam Relevance: SAT, ACT, AP Computer Science Principles

Difficulty: Very Easy

Concept notes: Read Only Memory (ROM) is a type of permanent memory that retains data even when the power is turned off.

Common Mistakes: Students may confuse ROM with RAM, which is volatile memory that loses data when power is turned off.

Explanations: ROM stands for Read Only Memory, which is a type of non-volatile memory used in computers and other electronic devices. It is called "Read Only" because the data stored in ROM cannot be modified once it has been written. This makes ROM suitable for storing firmware or software that should not be altered, such as the BIOS in a computer. The data in ROM is permanent and remains intact even when the power is turned off.

Option Analysis:

Option A: Correct. ROM stands for Read Only Memory, which is a type of permanent memory.
Option B: Incorrect. RAM stands for Random Access Memory, which is volatile and loses data when power is turned off.
Option C: Incorrect. CPU stands for Central Processing Unit, which is the primary component that performs most of the processing inside a computer.
Option D: Incorrect. Motherboard is the main circuit board of a computer that holds and connects all the major components.

Mnemonic: ROM - Remember Only Memory

⬅ Previous SetSet 79Next Set ➡

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

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

Leave a Reply