Computer fundamentals — hardware, software, MS Office, internet, networking, and cybersecurity awareness asked in computer knowledge sections.
What do you mean by SQL?
Structured Query Language
Statistical Query Language
Superior Questions Lot
Standard Query Lot
Correct answer
Structured Query Language
Which HTML element is used for the highest level of heading?
<header>
Correct answer
<header>
Which alignment option adjusts text so that both the left and right edges of the paragraph are flush with the margins, often used in books and newspapers?
Left Align
Center Align
Right Align
Justify
Correct answer
Left Align
When editing a cell that currently contains a formula, which part of the Excel window is most useful for carefully changing the formula without missing any operators or cell references?
Scroll bar
Formula bar
Status bar
Sheet tab
Correct answer
Scroll bar
Which function would you use to return the current date in Excel?
=TODAY()
=NOW()
=DATE()
=CURRENTDATE()
Correct answer
=TODAY()
__________ is used for enlarging a window after it has been minimized or restored.
Minimize Button
Restore Button
Close Button
Maximize Button
Correct answer
Minimize Button
Which of the following information is typically appropriate to include in a professional email signature?
(i) Your name and job title
(ii) Your latest passport-sized photograph
(iii) Your company's or brand's logo and tagline
(iv) Your company's name and contact numbers
Only (i) and (ii)
Only (i), (ii) and (iii)
Only (i), (iii) and (iv)
Only (iii) and (iv)
Correct answer
Only (i) and (ii)
Which tool allows us to automatically apply formatting like colors, icons, and data bar to one or more cells based on the apply condition ?
Conditional formatting
Format as table
Cell styles
Insert
Correct answer
Conditional formatting
Which of the following allows you to link content from Excel into Word?
Bookmark
Hyperlink
Object Linking and Embedding (OLE)
Macro
Correct answer
Bookmark
Which function will you use to return the largest number from a range of cells?
=LARGE()
=MAX()
=MAXIMUM()
=HIGHEST()
Correct answer
=LARGE()
Which of the following is a benefit of E-Banking?
Limited access to accounts
24 × 7 availability
Only works during office hours
Requires physical presence at the bank
Correct answer
Limited access to accounts
What is the maximum transmission unit (MTU) for Ethernet frames in most networks?
1024 bytes
1500 bytes
2048 bytes
4096 bytes
Correct answer
1024 bytes
Which feature allows text to flow around images or shapes?
Text Wrapping
Mail Merge
AutoFormat
SmartArt
Correct answer
Text Wrapping
Which of the following options is used to protect a Word document with a password?
File > Protect Document > Encrypt with Password
Home > Restrict Editing
File > Permissions > Password
Review > Protect Document
Correct answer
File > Protect Document > Encrypt with Password
Which statement best describes a critical characteristic distinguishing HTTP from HTTPS?
HTTP is always faster than HTTPS because it requires fewer data packets to be transferred.
HTTPS uses an additional security layer (SSL/TLS) to encrypt data, while HTTP transmits data in plain text.
HTTP is used for sending information from the client to the server, and HTTPS is used for receiving information from the server.
HTTPS is required only for e-banking, whereas HTTP is used for all other general web browsing.
Correct answer
HTTP is always faster than HTTPS because it requires fewer data packets to be transferred.
In Excel, which element is used to select the entire worksheet at once for applying editing actions like changing font or deleting all data?
The Name Box
The small triangle or square at the top-left corner of the grid (above row 1 and left of column A)
Any cell in column A
Any sheet tab
Correct answer
The Name Box
Which formula best demonstrates a nested use of IF inside another function, such as counting how many values in A1 : A10 are "Pass"?
=COUNT(A1:A10="Pass")
=COUNTIF(A1:A10,"Pass")
=IF(COUNT(A1:A10), "Pass", "Fail")
=SUM(IF(A1:A10="Pass",1,0))
Correct answer
=COUNT(A1:A10="Pass")
What is the purpose of the recent option in Ms-Word?
This option lists down all the recently opened documents.
This option is used to open new documents.
This option is used to opened documents.
None of these
Correct answer
This option lists down all the recently opened documents.
If you have a worksheet with data in columns that you need to rotate to rearrange it in rows, use the _______ feature.
Average
transpose
Copy + Paste
rotate
Correct answer
Average
What does the =LEFT(text, num_chars) function do?
Extracts the first num_chars characters from the right of the text
Extracts the first num_chars characters from the left of the text
Converts the text to uppercase
Returns the last num_chars characters from the text
Correct answer
Extracts the first num_chars characters from the right of the text
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.