Computer fundamentals — hardware, software, MS Office, internet, networking, and cybersecurity awareness asked in computer knowledge sections.
______ refers to a series of Websites that require special decryption and configuration tools to access.
Dead Web
Dark Web
Data Wide
Data Web
Correct answer
Dead Web
Which of the following BEST explains why keywords are important in search engines?
They act as security codes
They help match user queries with indexed pages
They block viruses
They store files
Correct answer
They act as security codes
In Excel, when a formula containing relative references is copied from one cell to another, which statement best describes the editing behavior of the references?
The references remain exactly the same in every copied cell
The references adjust based on the relative position of the new cell
The references change only if the destination is in a different worksheet
The references always change to A1
Correct answer
The references remain exactly the same in every copied cell
Which formula correctly calculates the average of values in B2:B10 but excludes zeros by using COUNTIF and SUM together?
=SUM(B2:B10)/COUNT(B2:B10)
=SUM(B2:B10)/COUNTIF(B2:B10,'<>0')
=SUM(B2:B10)/COUNTIF(B2:B10,'=0')
=SUMIF(B2:B10,'=0')/COUNT(B2:B10)
Correct answer
=SUM(B2:B10)/COUNT(B2:B10)
Which is a short cut key use to open the file from the computer edge?
Ctrl+N
Ctrl+S
Ctrl+O
Ctrl+P
Correct answer
Ctrl+N
Which of the following recipient actions do emails containing malware or viruses typically rely on to infect a computer?
(i) The recipient clicks the 'Reply' button to respond
(ii) The recipient manually forwarding the email to five or more contacts
(iii) The recipient clicks on a malicious link
(iv) The recipient downloads and opens an infected attachment
Only (i) and (ii)
Only (ii), (iii) and (iv)
Only (iii) and (iv)
Only (i) and (iii)
Correct answer
Only (i) and (ii)
___ is a feature in Excel used to control what a user can enter into a cell.
Data Validation
Data Format
Data Flash fill
Data Relationships
Correct answer
Data Validation
Which Word feature helps you view multiple parts of a long document simultaneously?
Split Window
View Gridlines
Draft Mode
Freeze Pane
Correct answer
Split Window
What is the purpose of the \( =IFERROR() \) function in Excel?
Checks for errors in a cell and returns a custom message if there is an error
Returns the error message of a formula
Displays a warning message
Ignores the errors in a formula
Correct answer
Checks for errors in a cell and returns a custom message if there is an error
What is the purpose of the 'Compare' feature in Microsoft Word?
To compare two documents for differences
To merge two documents
To create a table of contents
To insert comments
Correct answer
To compare two documents for differences
Which of the following is NOT required for Internet Banking?
Internet connection
Bank account
Debit/Credit card PIN
User ID and Password
Correct answer
Internet connection
'Which feature in MS Word allows you to insert custom fields, such as dates, document properties, or user information, into a document?'
'Insert > Field Codes'
'References > Insert Field'
'Home > Text > Field'
'Insert > Quick Parts > Field'
Correct answer
'Insert > Field Codes'
'What does the z-index property control?'
'Page margin'
'Text alignment'
'Zoom of an image'
'Stacking order of elements'
Correct answer
'Page margin'
'In MS Excel, what is the intersection of a row and a column on a worksheet called?'
'Cell'
'Field'
'Sheet'
'Range'
Correct answer
'Cell'
'Which combination of features in MS Word is most suitable to create a professional letter that includes a company logo, uses a predefined layout and has consistent heading styles?'
'Manual spacing and random fonts only'
'Insert Picture, use a suitable Template, and apply Styles for headings'
'Write everything in uppercase without formatting'
'Use only the default Normal style and no images'
Correct answer
'Manual spacing and random fonts only'
When using AutoFill for a text like 'Mon' in a cell, which setting should be applied or accepted so that dragging the Fill Handle downward continues the series to 'Tue', 'Wed', and so on?
Choose 'Copy Cells' in the AutoFill options
Choose 'Fill Series' in the AutoFill options
Choose 'Fill Formatting Only' in the AutoFill options
Choose 'Clear Contents' in the AutoFill options
Correct answer
Choose 'Copy Cells' in the AutoFill options
Which of the following formulas will correctly display 'High' if A1 is greater than 80, 'Medium' if A1 is between 40 and 80 (inclusive), otherwise 'Low'?
=IF(A1>80, "High", "Medium", "Low")
=IF(A1>80, "High", IF(A1>=40, "Medium", "Low"))
=IF(A1>80, "High", IF(A1>40, "Low", "Medium"))
=IF(A1>=40, "Medium", IF(A1>80, "High", "Low"))
Correct answer
=IF(A1>80, "High", "Medium", "Low")
To view formatting for your current selection, press ______ to see Reveal Formatting.
Shift+F2
Ctrl+F1
Shift+F1
Ctrl+F10
Correct answer
Shift+F2
What is the main purpose of a clear and concise subject line in an email?
To ensure the email's file size is limited and easy to send
To help the recipient quickly grasp the email's content and prioritise
To allow the email to be easily marked as spam
To ensure the email gets a quick response, regardless of content
Correct answer
To ensure the email's file size is limited and easy to send
What is the result of the formula =LEN('Excel') ?
4
5
6
7
Correct answer
4
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.