Computer set 1 MCQs
Practice interactive objective questions for this topic. Select an option to instantly verify your answer and read detailed explanations.
Q.211
Which port provides the fastest data transfer rate for external storage devices among the following?
A
Thunderbolt 3
B
USB 3.0
C
eSATA
D
FireWire 800
Q.212
In a computer, what is the role of a device driver?
A
It acts as a translator between the OS and the hardware
B
It manages file systems on the hard disk
C
It compiles source code into machine language
D
It allocates memory to running applications
Q.213
Which of the following is an open source operating system?
A
Linux
B
Windows
C
macOS
D
iOS
Q.214
Which type of software translates high-level language source code into machine code line by line and executes it immediately?
A
Interpreter
B
Compiler
C
Assembler
D
Linker
Q.215
A user notices that a newly installed application fails to start, and the error log mentions missing DLL files. Which software component is most likely the issue?
A
Dynamic Link Library (DLL) files
B
Device driver
C
Operating system kernel
D
Application configuration file
Q.216
Which input device uses magnetized ink characters to read bank cheque details?
A
MICR
B
OCR
C
OMR
D
Barcode Reader
Q.217
In MS Word, which feature allows users to view and compare two versions of a document side by side, highlighting differences?
A
Compare
B
Track Changes
C
Combine
D
Split View
Q.218
Which keyboard shortcut inserts a page break in MS Word?
A
Ctrl + Enter
B
Ctrl + Shift + Enter
C
Alt + Enter
D
Shift + Enter
Q.219
In MS Word, what is the purpose of the 'Reveal Formatting' pane?
A
It displays detailed formatting properties of selected text
B
It reveals hidden characters like spaces and paragraph marks
C
It shows the document in draft mode
D
It compares formatting between two paragraphs
Q.220
A user applies a set of formatting options (font, size, color, alignment) consistently across a document by using a named collection of formatting settings. What is this feature called?
A
Style
B
Theme
C
Template
D
Macro
Q.221
In MS Excel, which function would you use to find the position of a specific character within a text string?
A
FIND
B
SEARCH
C
MID
D
LEN
Q.222
What does the formula =SUMIF(A1:A10,">100",B1:B10) compute in Excel?
A
Sum of values in B1:B10 where corresponding A1:A10 > 100
B
Sum of values in A1:A10 that are greater than 100
C
Count of cells in A1:A10 > 100
D
Sum of B1:B10 if any cell in A1:A10 exceeds 100
Q.223
A cell in Excel displays ###### instead of the expected value. What is the most likely cause?
A
Column width is too narrow to display the number
B
The cell contains a division by zero error
C
The cell reference is circular
D
The formula syntax is incorrect
Q.224
Which type of cell reference in Excel does not change when the formula is copied to another cell?
A
Absolute reference (e.g., $A$1)
B
Relative reference (e.g., A1)
C
Mixed reference (e.g., $A1)
D
Circular reference
Q.225
In Excel, what is the purpose of a PivotTable?
A
To summarize, analyze, explore, and present large amounts of data interactively
B
To create charts automatically from raw data
C
To sort and filter data in place without changing the original table
D
To link data from multiple workbooks into one consolidated view
Q.226
Which Excel feature restricts data entry to predefined criteria, such as a dropdown list or a date range?
A
Data Validation
B
Conditional Formatting
C
Protect Sheet
D
Filter
Q.227
What is the function of the VLOOKUP formula =VLOOKUP(105, A2:D10, 3, FALSE) if 105 is found in the first column of the range?
A
Returns the value from the 3rd column of the matched row
B
Returns 105 if found, otherwise an error
C
Returns the sum of the third column
D
Returns TRUE if 105 is in the third column
Q.228
Which type of memory stores the BIOS firmware and retains its content without power?
A
ROM
B
RAM
C
Cache
D
Virtual Memory
Q.229
What is the primary advantage of an SSD over a traditional HDD?
A
Faster read/write speeds and lower latency
B
Higher storage capacity at a lower cost per GB
C
Greater durability against physical shock due to moving parts
D
Compatibility with older IDE interfaces
Q.230
In an operating system, what is the function of virtual memory?
A
It uses hard disk space as an extension of RAM, allowing execution of larger programs
B
It creates a duplicate copy of RAM for backup purposes
C
It stores the BIOS settings
D
It speeds up CPU processing by caching frequently used data
Q.231
Which file system is commonly used by Windows operating systems for internal drives due to its support for large files and security permissions?
A
NTFS
B
FAT32
C
exFAT
D
ext4
Q.232
When you boot a computer, the POST process is carried out by which component?
A
BIOS/UEFI
B
Operating system kernel
C
Bootloader
D
CPU microcode
Q.233
Which type of multitasking operating system allocates a fixed time slice to each process, preempting tasks to ensure all get CPU time?
A
Preemptive multitasking
B
Cooperative multitasking
C
Batch processing
D
Real-time processing
Q.234
In Linux, which command is used to list files and directories with detailed information including permissions?
A
ls -l
B
dir /s
C
list -a
D
show -d
Q.235
A mobile operating system based on the Linux kernel and primarily developed by Google is:
A
Android
B
iOS
C
Windows Phone
D
Tizen
Q.236
Which security attack involves an attacker sending fraudulent emails that appear to come from a trusted source to steal sensitive information?
A
Phishing
B
Spoofing
C
Man-in-the-middle
D
Ransomware
Q.237
What does a firewall primarily do to protect a network?
A
Monitors and controls incoming and outgoing network traffic based on predetermined security rules
B
Scans and removes malware from email attachments
C
Encrypts all data transmitted over the network
D
Authenticates users using biometric data
Q.238
Which malware type encrypts the victim’s files and demands payment to restore access?
A
Ransomware
B
Spyware
C
Trojan horse
D
Worm
Q.239
Two-factor authentication enhances security by requiring:
A
Something you know (password) and something you have (token/phone)
B
Two different passwords entered simultaneously
C
A password and a security question answer
D
Biometric and PIN only
Q.240
What is the primary purpose of digital signatures in electronic documents?
A
To verify the authenticity and integrity of the document
B
To encrypt the document so only intended recipients can read it
C
To compress the document for faster transmission
D
To convert the document into an image format