Font size
WorksheetsComputer Hardware Basics MCQs
Total questions: 50
Worksheet time: 31mins
Which part of the computer is known as the "brain"?
CPU Hard Drive
CPU
RAM
GPU
What does CPU stand for?
Central Programming Unit
Central Processing Unit
Computer Power Unit
Central Peripheral Unit
The temporary storage area of the computer is called:
Hard Disk
ROM
RAM
SSD
What is the function of the motherboard?
Display images
Connect all hardware components
Store data
Produce sound
Which component stores data permanently?
RAM
Cache
Hard Drive
Register
What does GPU stand for?
General Processing Unit
Graphics Processing Unit
Graphical Power Unit
General Power Utility
Which hardware device supplies power to the computer?
PSU
GPU
CPU
HDD
The full form of BIOS is:
Basic Input Output System
Binary Input Output Setup
Basic Integrated Output System
Base Information Operating Setup
Which type of memory is volatile?
RAM
ROM
Flash Memory
SSD
Which part of the CPU performs arithmetic operations?
Control Unit
ALU
Memory Unit
Register
What does ROM stand for?
Random Output Memory
Read Only Memory
Rapid Output Module
Read Once Memory
What device displays the visual output of a computer?
Keyboard
Monitor
CPU
Motherboard
What is the function of a heat sink?
Process data
Cool down the CPU
Store data
Increase voltage
Which device is used to input text?
Scanner
Keyboard
Mouse
Microphone
Your computer suddenly shuts down when you open multiple applications. You notice a burning smell from inside the case. What component is most likely failing?
CPU
Hard Drive
Power Supply Unit
RAM
A student is typing a report but no letters appear on the screen when keys are pressed. Which hardware should be checked first?
Keyboard
Monitor
Motherboard
Mouse
When you turn on your computer, you hear a beep sound, but nothing appears on the monitor. What component might be defective?
Graphics Card
Hard Drive
Keyboard
Speaker
Your computer displays “No Bootable Device Found.” Which part might not be connected properly?
Flashdrive
Keyboard
Monitor
RAM
A gamer wants smoother graphics performance for playing 3D games. What should be upgraded?
GPU
Motherboard
Network Card
Sound Card
The computer turns on but there is no display, even though the monitor power light is on. Which cable should you check?
HDMI
LAN
SATA
USB
The system date and time reset every time the computer restarts. What should be replaced?
CMOS Battery
CPU
GPU
Power Cord
Your friend wants to store photos, videos, and music on their computer. Which part should have high capacity?
Hard Drive
RAM
ROM
You notice distorted sound while playing a video. What hardware might be faulty?
Sound Card
Graphics Card
Power Supply
RAM
A computer technician needs to install a component to connect the PC to a Wi‑Fi network. What should he add?
Network Interface Card
RAM Module
Sound Card
VGA Adapter
The monitor shows "No Signal." What might be disconnected?
HDMI or VGA Cable
Keyboard Port
LAN Cable
USB Hub
When the power button is pressed, the computer doesn’t turn on. What should be checked first?
Power Cable
RAM Slot
USB Drive
Video Card
When the power button is pressed, the computer doesn’t turn on. What should be checked first?
Power Cable
RAM Slot
USB Drive
Video Card
You are assembling a new PC. Which component connects all other components together?
Motherboard
Power Supply
SSD
USB Hub
You cannot hear any sound even though speakers are connected. Which device setting should be checked?
Sound Card
GPU
CPU
RAM
A file is deleted accidentally. From which device could it possibly be recovered?
Hard Drive
Monitor
Power Supply
Speaker
The computer cannot connect to the network. What might be missing or disabled?
Network Adapter
Sound Card
USB Port
VGA Cable
Your monitor displays blurry images. Which component should be adjusted or replaced?
Graphics Card
Hard Drive
Keyboard
PSU
The cursor moves randomly on the screen. Which device might be causing this?
Mouse
Monitor
Speaker
USB Drive
A user wants to improve audio quality when recording songs. What should be upgraded?
Sound Card
CPU
Hard Disk
RAM
Liam wants to make a column always visible while scrolling. What should he use?
Filter
Freeze Panes
Sort
Split Window
Jenny wants to arrange a list of students alphabetically by name. What Excel feature should she use?
Filter
Find
Sort
Split
Anna wants to only display rows where the grade is “Passed.” Which feature will she use?
Conditional Formatting
Filter
Sort
Data Validation
To highlight all students who scored below 75, which tool should be used?
AutoSum
Conditional Formatting
Data Validation
Filter
You want to quickly copy the same formula down a column. Which tool should you use?
AutoFill Handle
Copy and Paste
Format Painter
Merge and Center
When you type a long text and want it to appear on multiple lines in one cell, use:
AutoFit
Merge Cells
Text Wrap
Shrink to Fit
If you want to merge multiple cells into one large title cell, which command is used?
Center Text
Merge & Center
Wrap Text
Format Painter
The formula “=IF(A1>=75, "Pass", "Fail")” means:
If A1 is less than 75, display Pass
If A1 equals 75, display Fail
If A1 is greater than or equal to 75, display Pass
Display Pass always
To convert a value like 0.25 into percentage format, you should:
Multiply by 100
Change cell format to Percentage
Use SUM function
Divide by 100
WRITE THE FORMULA OF THE FOLLOWING. If A1 is greater than or equal to 75, display “Pass” else display “Failed”. pls type all in capital letter
(a)
WRITE THE FORMULA OF THE FOLLOWING. If A1 is less than 75, display “Failed” else display “Pass”. TYPE IN ALL CAPITAL LETTER
(a)
WRITE THE FORMULA OF THE FOLLOWING. Add values from A1 and B1
You want to find the lowest score from B2 to B10.TYPE IN ALL CAPITAL LETTERS
(a)
You want to find the highest score from A2 to A10.TYPE IN CAPITAL LETTERS
(a)
FORMULA IN COUNTING LETTER IN CELL B2 TO B759 HAVING THE WORD WATER.TYPE IN ALL CAPITAL LETTER
(a)
FORMULA IN COUNTING LETTER IN CELL A1 TO A5 HAVING THE WORD JEN.TYPE IN ALL CAPITAL LETTER
(a)
