Computer fundamentals — hardware, software, MS Office, internet, networking, and cybersecurity awareness asked in computer knowledge sections.
In MS Excel, which of the following correctly identifies how rows and columns are labeled as elements of a worksheet?
Rows use letters and columns use numbers
Rows use numbers and columns use letters
Rows and columns both use letters
Rows and columns both use numbers
Correct answer
Rows use letters and columns use numbers
Which statement best describes why using cell references in formulas is better than typing actual numbers directly when editing a spreadsheet?
It makes formulas harder to read and understand
It ensures that formulas automatically update when the referenced cells change
It prevents any further editing of the worksheet
It stops the use of functions like SUM and AVERAGE
Correct answer
It makes formulas harder to read and understand
Which statement best describes the difference between the Save and Save As commands in MS Word once a document already has a name?
Save creates a new copy while Save As exits the document
Save stores changes in the same file, Save As saves a new copy with a different name or location
Save prints the document, Save As emails it
There is no difference; both always do exactly the same thing
Correct answer
Save creates a new copy while Save As exits the document
In MS Word, which feature ensures that when text is typed, existing characters move forward instead of being overwritten by new characters?
Insert mode
Overtype mode
AutoCorrect
Track Changes
Correct answer
Insert mode
Which of the given options is NOT required to send an electronic mail?
Internet Connection
E-mail Account
Recipient's email address
Recipient's IP address
Correct answer
Internet Connection
Which of the following are we typically required to enter on an email account creation page?
(i) First name (ii) Last name (iii) Username (iv) Bank account number (v) Password
Only (iii), (iv) and (v)
Only (i), (ii) and (iii)
Only (i), (iii), (iv) and (V)
Only (i), (ii), (iii) and (v)
Correct answer
Only (iii), (iv) and (v)
Which bar is below Title Bar that provides categorized options?
Status Bar
Menu bar
Tool bar
Scroll bar
Correct answer
Status Bar
Which shortcut key is used for small-cap?
Shift - Ctrl - D
Ctrl - Shift - K
Shift - Ctrl-A
Shift - Ctrl - >
Correct answer
Shift - Ctrl - D
What does the =TEXT() function do in Excel?
Converts a numeric value into text in a specific format
Converts text into numeric value
Replaces text within a string
Converts text to lowercase
Correct answer
Converts a numeric value into text in a specific format
Which MS Excel function returns the number of months between two dates, rounded down to the nearest whole month?
EOMONTH
MONTH
DATEDIF
NETWORKDAYS
Correct answer
EOMONTH
In E-banking, which security measure is commonly used to verify a transaction by sending a temporary code to your registered mobile number?
YRL
OTP
FTP
GPS
Correct answer
YRL
Which of the following is used to format text into a superscript in MS Word?
Ctrl + Shift ++
Ctrl + Shift +=
Ctrl + Shift +S
Ctrl + S
Correct answer
Ctrl + Shift ++
During a video-conferencing session, which underlying factor has the greatest influence on maintaining clear and uninterrupted communication?
Browser version
Bandwidth availability
Screen resolution
Storage capacity
Correct answer
Browser version
Which tab in MS Word provides options for inserting footnotes and endnotes?
Home
References
Review
Layout
Correct answer
Home
Which of the following pairs is correctly matched?
Ctrl + H - Highlight text
Ctrl+F-Find text
Ctrl + D - Delete paragraph
Ctrl list N-Number
Correct answer
Ctrl + H - Highlight text
Which primary tab on the Excel Ribbon is home to the commands for adding, removing, and renaming individual sheets within a workbook?
Data
View
Home (Cells Group)
Formulas
Correct answer
Data
Which Excel function would you use to calculate the internal rate of return (IRR) for a series of cash flows?
NPV
IRR
PMT
FV
Correct answer
NPV
The _____ function takes data from a series of worksheets or workbooks and summaries it into a single worksheet that you can update easily.
Data Validation
Data Duplicate
From Access
Data Consolidation
Correct answer
Data Validation
When we receive an email, which field indicates the sender's email address?
The "To" field
The "From" field
The "Cc" field
The "Bcc" field
Correct answer
The "To" field
In Excel, how would you round the number 5.6789 to two decimal places?
=ROUND(5.6789, 2)
=ROUNDUP(5.6789, 2)
=ROUNDDOWN(5.6789, 2)
=FIXED(5.6789, 2)
Correct answer
=ROUND(5.6789, 2)
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.