Font size
WorksheetsICT 102 Mid-Term Examination
Total questions: 60
Worksheet time: 48mins
What is a computer?
A digital clock
A telephone system
A mechanical machine that counts
An electronic machine that processes data
Who was the first to use the word "computer"?
Charles Babbage
Blaise Pascal
William Oughtred
It referred to a human who calculated
Which device is considered the earliest form of a computer?
Pascaline
Abacus
ENIAC
Harvard Mark I
Who invented the Pascaline?
Charles Babbage
Blaise Pascal
John Napier
Gottfried Wilhelm Leibniz
What was the significance of the Jacquard Loom?
It was a mechanical calculator.
It was controlled by punched cards.
It was the first electronic computer.
It could perform addition and subtraction.
Who is known as the "Father of the Computer"?
Charles Babbage
John Napier
Blaise Pascal
Alan Turing
Which generation of computers used transistors?
First
Second
Third
Fourth
What does ENIAC stand for?
Electronic Network Interface and Control
Electrical Numerical Integrator and Calculator
Electronic Numerical Integrator and Computer
Electronic Navigational Interface and Calculator
Which was the first stored-program computer?
UNIVAC 1
EDVAC
Z1
Harvard Mark I
Which device is considered the first portable computer?
ENIAC
Osborne 1
Z1
UNIVAC 1
Which of the following is a characteristic of third-generation computers?
Use of vacuum tubes
Use of integrated circuits
Use of microprocessors
Use of artificial intelligence
Which of these elements is NOT part of the computing process?
Hardware
Software
Procedures
None of the above
Which application is NOT listed under computer applications in society?
Education
Finance
Agriculture
Publishing
Which disadvantage is associated with computers?
High accuracy
Self-operating capabilities
Prone to machine defection
Ability to store large amounts of data
Which generation of computers introduced microprocessors?
First
Second
Third
Fourth
What are the three main components of a computer?
Input/output units, memory/storage units, CPU
Hard drive, RAM, motherboard
Monitor, keyboard, CPU
Processor, mouse, software
Which part of the motherboard is connected to the CPU at high speed?
Southbridge
Northbridge
Bus
Memory
What is the role of the ALU (Arithmetic Logic Unit) in the CPU?
Performs calculations and comparisons
Controls the execution of instructions
Stores data permanently
Manages power consumption
Which architecture is known for using a single memory for both data and instructions?
Harvard Architecture
RISC Architecture
von Neumann Architecture
CISC Architecture
What does the Control Unit (CU) do in the CPU?
It performs all arithmetic operations
It handles the fetch/execute cycle
It stores data permanently
It cools down the CPU
What is a characteristic of L1 cache memory?
It is non-volatile memory
It is the largest cache memory
It is the slowest memory
It is the fastest and smallest cache memory
Which type of memory is volatile and needs to be refreshed thousands of times per second?
ROM
SRAM
DRAM
Flash memory
Which type of memory is non-volatile and used to hold software that doesn't change?
SRAM
DRAM
ROM
Cache memory
What is the function of the Memory Address Register (MAR)?
To decode instructions
To perform arithmetic operations
To manage input/output operations
To find the location of memory addresses
Which component is responsible for determining the next instruction for execution in the CPU?
Instruction Register (IR)
Program Counter (PC)
ALU
Cache Memory
What does the Memory Data Register (MDR) do?
Manages the machine cycle
Controls the execution of instructions
Stores the address of the next instruction
Holds data that is being transferred to or from memory
Which type of memory is commonly used for BIOS and system settings?
SRAM
DRAM
CMOS
Flash memory
Which of the following best describes Harvard Architecture?
Uses a large cache of memory
Utilizes multiple CPUs for parallel processing
Combines data and instructions in one memory
Uses separate memory for data and instructions
What are registers in the CPU used for?
Cooling the CPU
Permanent storage of data
Managing the power supply
Temporary storage locations within the CPU for specific purposes
Which component supervises fetching instructions and data in the CPU?
Cache Memory
Control Unit (CU)
Arithmetic Logic Unit (ALU)
Memory Management Unit (MMU)
What is the main purpose of the ACM Code of Ethics?
To regulate the salaries of computing professionals.
To set technical standards for software development.
To provide legal guidelines for computing professionals.
To guide the ethical conduct of computing professionals.
Which of the following ACM Code that consistently supports computing professionals?
Profit maximization
Public good
Personal advancement
Technological innovation
Which of the following is NOT listed as a General Ethical Principle in the ACM Code?
Be honest and trustworthy.
Respect privacy.
Maximize profit for stakeholders.
Avoid harm
In the ACM Code, what should a computing professional strive for?
Innovation at any cost
High quality in both processes and products
Quick completion of tasks
High salary and benefits
Which of the following is the responsibility of computing professionals towards their employers?
Ignoring proprietary information
Keeping trade secrets confidential
Sharing intellectual property freely
Prioritizing personal projects
What is the primary obligation of computing professionals towards the public?
Ensuring personal financial success
Increasing company profits
Advancing personal knowledge
Ensuring the safety, health, and welfare of the public
What is 'peer review' in the context of professional ethics?
A process to obtain client feedback.
A method to gain promotions within a company.
An informal discussion about a project with peers.
A formal evaluation of one's work by colleagues in the same field.
According to the ACM Code, what should be the central concern during all professional computing work?
Technical innovation
Public good
Profit margins
Professional development
Which of the following is a key element in professional leadership according to the ACM Code?
Prioritizing personal career advancement.
Ensuring all actions benefit the company financially.
Delegating all ethical decisions to lower-level employees.
Managing personnel to enhance the quality of working life.
What is the purpose of the Ten Commandments of Computer Ethics?
To establish legal standards for computing.
To regulate computer sales and marketing.
To provide technical guidelines for programming.
To guide moral behavior in the use of computers.
What is an internal storage device?
A type of external hard drive
A cloud-based storage solution
A portable storage device that connects via USB
A storage device installed inside a system unit or laptop
Which of the following is NOT a type of internal storage device?
Hard Disk Drive (HDD)
Solid State Drive (SSD)
USB Flash Drive
Hybrid Hard Drive (HHD)
What is the primary technology used in a Hard Disk Drive (HDD)?
Flash memory
Magnetic storage disks
Optical storage
Cloud storage
Which of the following is an example of an external storage device?
SSD
HDD
USB Flash Drive
S-ATA Controller
What is the storage capacity of a standard CD?
650 MB
700 MB
4.7 GB
25 GB
Which connector is commonly used by internal storage devices?
USB
S-ATA
HDMI
Ethernet
What is the main advantage of cloud storage?
It is less secure than local storage
It is more expensive than traditional storage
It requires physical hardware to be stored locally
It allows data to be accessed from anywhere on any device
Which of the following is a disadvantage of cloud storage?
Accessibility
Cost savings
Disaster recovery
Data security concerns
What is a Storage Area Network (SAN)?
A type of USB flash drive
A type of external hard drive
A cloud-based storage solution
A dedicated high-performance network for storage
Which of the following is an example of a cloud storage service?
S-ATA
Google Drive
HDD
EIDE
What formula should be used to combine the "LASTNAME" and "FIRSTNAME" columns into a full name in the format "LASTNAME, FIRSTNAME"?
What formula should be used to convert all names to uppercase in the "FULLNAME" column?
(a)
What formula should be used to find the last name from a table where "FULLNAME" is in column G and "LASTNAME" is in column H?
What adjustment should be made to the VLOOKUP function if the lookup value is not in column G and H of the range?
What formula should be placed in I1 to return the corresponding first name from the table array when searching for a full name in column G?
Why does VLOOKUP(G1, A1:D40, 4, FALSE) fail when looking up by Full Name, and what should be used instead?
What formula should be used to format the full address as "Street, City, State ZIP"?
What does a delimited function do to your data?
What is a workbook in Excel?
A formula used for calculations
A single sheet where data is entered
A collection of one or more worksheets
A toolbar for quick access to commands
Which tab in the Ribbon contains the "Merge & Center" and "Wrap Text" options?
Insert
Home
View
Data
