Computer fundamentals — hardware, software, MS Office, internet, networking, and cybersecurity awareness asked in computer knowledge sections.
In ________ communication, the two computers begin by establishing a connection via an automated process called a 'handshake.'
Socket
TCP
Server
Protocol
Correct answer
Socket
What is the difference between normal text and a saved "building block" (via Quick Parts / AutoText) in Word?
Building blocks lose all formatting when re-used
Reusable block keeps formatting (text, graphics, tables) for reuse
Building blocks double the document file size every time they are used
Building blocks can only store single words, not full sentences or paragraphs
Correct answer
Building blocks lose all formatting when re-used
Which folder is used to temporarily save a message you are writing but are not yet ready to send?
Junk
Archive
Outbox
Drafts
Correct answer
Junk
When editing a spreadsheet, which keyboard shortcut is most commonly used to copy the selected cells to the clipboard without removing them from their original location?
Ctrl + X
Ctrl + C
Ctrl + V
Ctrl + Z
Correct answer
Ctrl + X
In MS Word, To remove the changes keep clicking on the __________ button till you reach the original form of your document.
save
undo
copy
cut
Correct answer
save
Which of the following options is TRUE with respect to a "read receipt" in email communication?
Read receipts are legally binding and cannot be refused by the recipient.
Recipients always have the option to decline sending a read receipt.
All email systems automatically send read receipts without the recipient's consent.
Read receipts guarantee that the recipient has fully understood the email's contents.
Correct answer
Read receipts are legally binding and cannot be refused by the recipient.
What is represented by the small, dark square in the lower-right corner of an active cell which we can drag to fill the next cells?
Copy handle
Insert handle
Fill handle
Border
Correct answer
Copy handle
Which format preserves Word document layout and is best for sharing?
.docx
.rtf
.txt
Correct answer
.docx
What is the default alignment of data in an Excel cell?
Left for text, Right for numbers
Right for text, Left for numbers
Center for all data
Justified for all data
Correct answer
Left for text, Right for numbers
A cell contains the formula: =B$2 + $C3.
this formula is copied from cell A1 to cell D4, what will the formula in cell D4 be?
=B$2 + $C3
=E$2 + $C6
=F$2 + $C6
=E$5 + $F6
Correct answer
=B$2 + $C3
_________ is a company that provides web access to both businesses and consumers.
World Wide Web
Internet Service Provider (ISP)
Web
Local Area Network
Correct answer
World Wide Web
A __________ is a single page of information on the World Wide Web.
Title Page
Doc Page
Web page
Home Page
Correct answer
Title Page
Which option is used to apply a gradient background to a page in MS Word?
Design > Page Color > Gradient
Insert > Page Background
View > Gradient Background
Page Layout > Background
Correct answer
Design > Page Color > Gradient
While working on a large worksheet, which element should be used to keep the top heading row visible at all times when scrolling down to edit data in lower rows?
Sort A to Z
Freeze Panes
Conditional Formatting
Merge Cells
Correct answer
Sort A to Z
Which of the following button is used to set the size of alphabet?
Font Size Button
Undo button
F2 button
None of these
Correct answer
Font Size Button
What is an email signature?
A required security certification for all business communications
The image of a hand-drawn signature of the sender, attached to every message
A block of text added to outgoing emails, usually containing the sender's contact information
A unique tracking ID assigned to the email by the email service provider
Correct answer
A required security certification for all business communications
In order to arrange the marks of students in the division from those with the highest marks to those with the lowest, you need to sort on the marks field in __________.
ascending order
descending order
alphabetical order
random order
Correct answer
ascending order
What does the "Inspect Document" feature check for?
Spelling errors
Formatting issues
Hidden metadata or personal info
Duplicate content
Correct answer
Spelling errors
Which of the following Excel functions can you use to check if a condition is true or false?
=IF()
=BOOLEAN()
=TRUE()
=LOGICAL()
Correct answer
=IF()
Which specific function would you use to find the third lowest numerical value in the entire range of cells A1:D10?
=SMALLEST(A1:D10, 3)
=SMALL(A1:D10, 3)
=RANK(A1:D10, 3)
=MIN(A1:D10) + 3
Correct answer
=SMALLEST(A1:D10, 3)
Solving previous year questions by topic helps identify recurring concepts, question patterns, and frequently asked sub-topics. Attempt each question, review the step-by-step explanation, and note down key formulas or facts for quick revision before the exam.