WorksheetsComputer Basics Quiz
Total questions: 30
Worksheet time: 15mins
Which part of the computer performs arithmetic and logic operations?
CU
ALU
RAM
ROM
Which of the following is a permanent memory?
RAM
Cache
ROM
Register
What does CPU stand for?
Central Power Unit
Central Processing Unit
Core Processing Unit
Computer Program Utility
Which device is used to input handwritten characters in banks?
OCR
MICR
OMR
Barcode Reader
What is the full form of OMR?
Optical Machine Reader
Optical Mark Recognition
Optical Main Register
Output Mark Reader
Which one is an output device?
Mouse
Printer
Keyboard
Scanner
The fastest and smallest memory in a computer is:
RAM
Cache
Register
ROM
Which memory stores data temporarily during program execution?
ROM
RAM
Hard Disk
CD-ROM
What does OCR stand for?
Output Character Recognition
Optical Character Recognition
Online Character Reader
Optical Code Reader
What is the main function of the Control Unit?
Store data
Coordinate all operations of the computer
Perform calculations
Display output
What is the full form of LAN?
Linked Access Network
Local Area Network
Long Area Network
Low Application Network
Which network covers a very short distance like inside a room?
LAN
PAN
WAN
MAN
Which network spans across countries and continents?
LAN
MAN
WAN
PAN
The most commonly used protocol for internet communication is:
FTP
TCP/IP
HTML
USB
A __________ connects two different networks.
Switch
Hub
Router
Repeater
Which of the following is a transmission medium?
Twisted Pair Cable
Hub
Switch
CPU
What does UTP stand for in networking?
Unified Transfer Protocol
Unshielded Twisted Pair
Universal Telecom Path
Unlocked Transmission Port
What is the function of a modem?
It converts digital signals to analog and vice versa
It prints data
It stores programs
It switches network routes
Which topology uses a central cable to which all nodes are connected?
Star
Bus
Ring
Mesh
What is the use of a repeater in a network?
Store data
Strengthen and regenerate signals
Print documents
Manage passwords
What will =5+10*2 return in Excel?
30
25
20
15
Which symbol is used to start any formula in Excel?
#
&
=
$
Which function adds a range of values?
=COUNT()
=ADD()
=SUM()
=AVG()
What does =AVERAGE(10, 20, 30) return?
30
25
20
10
Shortcut to save a workbook in Excel is:
Ctrl + A
Ctrl + N
Ctrl + S
Ctrl + W
In =A1+$B$1, which part is absolute reference?
A1
$B$1
B1
A1 + B1
What does Wrap Text do in Excel?
Deletes data
Displays long text on multiple lines in a cell
Shrinks text
Prints content
Which Excel chart shows trends over time?
Pie Chart
Line Chart
Column Chart
Area Chart
Which function counts only numeric values?
=COUNTA()
=COUNT()
=COUNTALL()
=SUM()
Shortcut to insert current date in Excel:
Ctrl + Shift + D
Ctrl + ;
Ctrl + T
Ctrl + Alt + D
