Computer fundamentals — hardware, software, MS Office, internet, networking, and cybersecurity awareness asked in computer knowledge sections.
_____ refers to the design of websites that are displayed on the internet.
UX design
Web design
Graphical User Interface
Data design
Correct answer
UX design
Which of the following lists contains ONLY Web Browsers?
Windows 10, macOS, Linux
Facebook, Instagram, Twitter
Google, Bing, Yahoo
Google Chrome, Mozilla Firefox, Microsoft Edge
Correct answer
Windows 10, macOS, Linux
Which MS Word feature allows you to remove formatting from selected text?
Format Painter → “Clear Format”
Home → “Clear All Formatting”
Review → Track Changes → “Remove Formatting
Insert → Styles → “Normal Text Only”
Correct answer
Format Painter → “Clear Format”
Which feature lets you create personalized letters or envelopes using a list of names/addresses?
Mail Merge
Equation Editor
Restrict Editing
Track Changes
Correct answer
Mail Merge
Which of the following correctly describes what happens when an entire column is deleted from a worksheet in Excel?
Only the heading of the column is deleted, but data remains
The column and all its data are removed, and columns to the right shift left
Only the formatting is removed while values stay
Anew column is automatically inserted at the end
Correct answer
Only the heading of the column is deleted, but data remains
What does it mean when we say that an email is “queued”?
The email has been marked as spam and is waiting to be automatically deleted by the system.
The email has been moved to the Archives folder for long-term storage for future reference.
The email has been placed in the Outbox folder, waiting in line to be transmitted to the mail server.
The email has been sent successfully and is waiting in the recipient's inbox to be read..
Correct answer
The email has been marked as spam and is waiting to be automatically deleted by the system.
Which tool is used to rearrange the data to find values quickly?
Sort
Conditional formatting
Cell Style
Format Table
Correct answer
Sort
What is the shortcut to insert a hyperlink in Word?
Ctrl + H
Ctrl + K
Alt + H
Ctrl + Alt + K
Correct answer
Ctrl + H
Which function in Excel would you use to return the current time?
=CURRENTTIME()
=TIME()
=NOW()
=TODAY()
Correct answer
=CURRENTTIME()
In MS Excel, which function returns a vertically stacked dynamic array from multiple ranges?
VSTACK
HSTACK
STACKV
WRAPROWS
Correct answer
VSTACK
______ is a type of broadband communications technology that transmits digital data at a high bandwidth over existing or phone lines to homes and businesses.
ADSL
ASDL
ADLS
DLS
Correct answer
ADSL
In which order are 'Posts' (articles) usually displayed on a standard Blog?
Alphabetical Order (A to Z)
Oldest post at the top
Reverse Chronological Order
Random Order
Correct answer
Alphabetical Order (A to Z)
The feature used to apply an artistic or decorative style to text, such as shadows or reflections, is called:
Format Painter
Quick Styles
WordArt
SmartArt
Correct answer
Format Painter
Which statement best characterizes the nature and purpose of a Blog?
A Blog is a specialized network protocol that enables real-time voice and video communication over the internet.
A Blog is a type of electronic bank transaction that allows users to manage their accounts online without visiting a physical branch.
A Blog is a personal or corporate website, usually maintained by an individual featuring regular posts of commentary, descriptions of events, or other material.
A Blog is a search engine optimization technique used to prioritize website rankings based on content quality and relevance.
Correct answer
A Blog is a specialized network protocol that enables real-time voice and video communication over the internet.
Which of the following pairs is correctly matched?
Ctrl + L - Left align text
Ctrl + R - Remove formatting
Ctrl + J - Jump to header
Ctrl + T - Table insert
Correct answer
Ctrl + L - Left align text
Which of the following edits can be performed using the Format Painter tool in Excel?
Copy only the data from one cell to another
Copy formatting such as font, border and color from one cell another
Copy the contents and clear the formatting
Remove all data and formatting from a selected range
Correct answer
Copy only the data from one cell to another
If A1 contains text instead of a number, what kind of problem is most likely when the formula = A1 + 10 is used?
Excel will return #DIV/0!
Excel will return #VALUE!
Excel will return #NAME?
Excel will ignore A1 and return 10 without warning
Correct answer
Excel will return #DIV/0!
What is the purpose of a "read receipt" in email communication?
To inform the sender when their email has been delivered to the recipient's inbox.
To notify the sender when the recipient has opened or read their email.
To notify the receiver that the email has to be immediately deleted after reading.
To notify the receiver that the sender has read the necessary terms and conditions.
Correct answer
To inform the sender when their email has been delivered to the recipient's inbox.
How can we insert formula in a cell?
Starting with '='
Starting with '+'
Starting with '-'
Starting with '$'$;
Correct answer
Starting with '='
Which Excel feature allows you to separate text into multiple columns?
Flash Fill
Text to Columns
AutoFit
Concatenate
Correct answer
Flash Fill
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.