Computer fundamentals — hardware, software, MS Office, internet, networking, and cybersecurity awareness asked in computer knowledge sections.
Which technology is commonly used for secure online banking transactions?
OTP (One Time Password)
SMS only
Manual signatures
Cheque book
Correct answer
OTP (One Time Password)
What is the purpose of the viewport meta tag in responsive web design?
It defines the character encoding of the webpage
It enables JavaScript execution
It sets up security policies for a website
It specifies how a website should be displayed on different devices
Correct answer
It defines the character encoding of the webpage
Which is NOT a valid section break type in MS Word?
Next Page
Continuous
Odd Page
Top Page
Correct answer
Next Page
Which of the following is the best way to delete only the contents and formatting of selected cells while keeping the overall structure (rows and columns) of the worksheet unchanged?
Use Clear All on the Home tab
Use Delete Sheet
Use Insert Rows
Use Merge & Center
Correct answer
Use Clear All on the Home tab
What does the 'Flash Fill' feature in Excel do?
Automatically fills data in cells based on patterns.
Fills cells with random data.
Fills a table with column names.
Adds a hyperlink to a cell.
Correct answer
Automatically fills data in cells based on patterns.
Clicking on each menu bar option generates a list of commands called:
Pull-down menu
Menu bar
Title bar
None of these
Correct answer
Pull-down menu
When you use the Reply function on an email message, who receives your response?
Everyone listed in the original 'To' and 'Cc' fields
Only the individual who originally sent the message
A new recipient that you manually type into the 'To' field
Only those recipients listed in the original 'Bcc' field
Correct answer
Everyone listed in the original 'To' and 'Cc' fields
What is the function of Slicer in MS excel?
Sort column
Timeline
Quickly and easily filter pivot tables
Create Table
Correct answer
Sort column
What is the purpose of the “Smart Lookup” feature in Word?
Translate words
Search the web for selected text
Find synonyms
Replace text
Correct answer
Translate words
What does the formula \( =RANK(A1, A1:A10) \) do?
Returns the rank of the value in A1 within the range A1:A10
Returns the highest value in A1:A10
Returns the count of values in the range A1:A10
Returns the sum of the values in A1:A10
Correct answer
Returns the rank of the value in A1 within the range A1:A10
Which one of the following is the instant messaging system?
Gtalk
Gmail
Yahoo
Rediff
Correct answer
Gtalk
What is the method to render text in bold using CSS?
text-bold: yes;
font-weight: bold;
bold: true;
font-style: bold;
Correct answer
text-bold: yes;
Which MS Word feature allows you to automatically update the page number formatting if you add or delete pages?
Field Codes
Header & Footer Tools
Page Layout > Page Numbers
Format Painter
Correct answer
Field Codes
Which option best describes the use of the Delete Cells dialog box (accessed via Home tab > Cells group > Delete > Delete Cells) in Excel?
It deletes the worksheet file from the disk
It deletes selected cells and gives options to shift remaining cells left or up
It deletes only the fonts used in selected cells
It deletes only the formulas but leaves values
Correct answer
It deletes the worksheet file from the disk
__________ option is to protect your word document. You can set a password so that nobody can open your document, or you can lock the document so that nobody can edit your document.
Versions
Prepare for sharing
Permissions
Compatibility mode
Correct answer
Versions
When you use the Forward feature to send a message to a new contact, which of the following parts of the original message is typically included by default?
(i) Original subject line with 'fwd' prepended
(ii) Original body text
(iii) Original attachments
(iv) All Original recipients
Only (i) and (ii)
Only (iii) and (iv)
Only (i), (ii) and (iii)
Only (ii), (iii) and (iv)
Correct answer
Only (i) and (ii)
__________ are often used to find out if there's a relationship between variable X and Y.
3D column
Scatter plots
Pivot Chart
Combo
Correct answer
3D column
Which command converts selected text to uppercase, lowercase, or sentence case?
Font > Transform
Format Painter
Change Case
Capitalize
Correct answer
Font > Transform
What does the =INDIRECT() function do in Excel?
Converts a value into a valid reference
Directly refers to a specific cell
Converts numbers to text
Creates a direct reference to a specific range
Correct answer
Converts a value into a valid reference
Regarding the Username part of an email address (the part before the @ symbol, e.g., JohnDoe in JohnDoe@example.com), most modern email systems treat case sensitivity as:
Case-sensitive, meaning JohnDoe@ is a different address from johndoe@.
Case-insensitive, meaning JohnDoe@ and johndoe@ deliver mail to the same inbox.
Sensitive only to the first letter, insensitive to the rest.
Determined solely by the operating system of the sender.
Correct answer
Case-sensitive, meaning JohnDoe@ is a different address from johndoe@.
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.