Computer fundamentals — hardware, software, MS Office, internet, networking, and cybersecurity awareness asked in computer knowledge sections.
_________ protocol is the main protocol for Internet communication.
POP3
UDP
OSI
TCP/IP
Correct answer
POP3
Which of the following is an example of a web hosting service?
Microsoft Excel
Amazon AWS
Google Docs
Adobe Photoshop
Correct answer
Microsoft Excel
In Excel, what is the effect of using the "Insert Cut Cells" option from the right-click menu after cutting a cell or range?
It pastes the content and pushes existing cells down or right depending on choice
It deletes the entire worksheet
It only changes formatting but not data
It converts the cut cells into formulas
Correct answer
It pastes the content and pushes existing cells down or right depending on choice
When a formula containing an absolute reference like $B$2 is copied to another cell, what happens to this reference during editing?
Both column and row change to match the new position
Only the column changes but the row stays the same
Only the row changes but the column stays the same
Neither the column nor the row changes
Correct answer
Both column and row change to match the new position
During ________ operation, no duplicate copy of the text is made.
save
cut
copy
paste
Correct answer
save
What is the primary goal of a phishing email?
To share legitimate business updates and newsletters with clients
To trick the recipient into revealing sensitive personal and financial information
To automatically delete junk email from an account and free storage
To widely advertise a legitimate commercial product or service
Correct answer
To share legitimate business updates and newsletters with clients
Which is short cut key press to insert comment?
Shift + F1
Shift + F2
Alt + O
Alt + C
Correct answer
Shift + F1
Which tool helps identify inconsistencies in formatting across your Word document?
Track Changes
Design Checker
Format Painter
Style Inspector
Correct answer
Track Changes
Which of the following is used to lock specific rows and columns while scrolling in Excel?
Freeze Panes
Split Window
Lock Cells
Protect Sheet
Correct answer
Freeze Panes
How can you insert a footnote in Microsoft Word?
References > Insert Footnote
Insert > Footnote
Home > Styles > Footnote
Ctrl + Alt + F
Correct answer
References > Insert Footnote
The default line spacing for a new document in modern versions of MS Word (after the first paragraph) is typically:
Single (1.0)
Double (2.0)
1.15
1.5
Correct answer
Single (1.0)
The Internet domain '.EDU’ is used for:
Commercial organization
Educational institution
Government institutions
Major network support
Correct answer
Commercial organization
Identify the correct structure of a URL (Uniform Resource Locator).
path.protocol://domain_name
www.protocol.domain_name
protocol://domain_name/path
Correct answer
path.protocol://domain_name
A user wants to quickly link a piece of text (e.g., "Click Here") to an external website URL within their MS Word document. Which single keyboard shortcut key combination should they use to open the Insert Hyperlink dialog box?
Ctrl + K
Ctrl + H
Ctrl + L
Ctrl + I
Correct answer
Ctrl + K
Which of the following statements best explains what a URL is mainly used for?
It is a software application used to view web pages on the internet.
It specifies the unique address of a resource (like a document or image) on the World Wide Web.
It is a protocol used for the secure transfer of data between a web browser and a server.
It is the technical name for the main page of a website, also known as the homepage.
Correct answer
It is a software application used to view web pages on the internet.
In Excel, which action best describes how to insert a new column between existing columns B and C?
Right-click on column C header and choose Insert
Right-click on column B header and choose Delete
Double-click between B and C headers
Press Esc on any cell in column C
Correct answer
Right-click on column C header and choose Insert
What is the main function of "starring" or "flagging" an email?
To send an automatic reply to the message.
To mark it as a spam or junk message.
To mark it as important and needing action.
To send an automatic “read receipt" notification to the sender.
Correct answer
To send an automatic reply to the message.
What is the shortcut key to hide the entire row?
CTRL + -
CTRL + 0
CTRL + 9
CTRL + C
Correct answer
CTRL + -
What is the correct way to reference cell Al from a different sheet named "Sheet2"?
Sheet2!A1
Sheet2:A1
Al:Sheet2
A1/Sheet2
Correct answer
Sheet2!A1
In MS Excel, which function can convert a vertical array into a single row automatically?
INDEX
TOROW
TRANSPOSE
TEXTJOIN
Correct answer
INDEX
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.