Computer fundamentals — hardware, software, MS Office, internet, networking, and cybersecurity awareness asked in computer knowledge sections.
Which of the following feature of MS Excel is used to quickly copy and paste content to adjacent cells in the same row or column?
Clear Formatting
Format Painter
Auto Format
Fill handle
Correct answer
Clear Formatting
Which of the following refers to the intersection of a column and row in a worksheet of MS Excel?
Name Box
Cell
Formula Bar
Workbook
Correct answer
Name Box
Which of the following protocols is used to transfer files from one host to another over the internet?
IP
UDP
FTP
TCP
Correct answer
IP
Which of the following shortcut key is used to paste the clipboard contents in an MS Word document?
Ctrl + Z
Ctrl + X
Ctrl + V
Ctrl + C
Correct answer
Ctrl + Z
Which of the following is used to identify every computer in the internet?
Internet address
IP address
Location address
Computer name
Correct answer
Internet address
Which of the following is used to create small letters above the line of text in MS Word?
Subscript
Superscript
Underline
Strikethrough
Correct answer
Subscript
Which of the following shortcut is used to select a paragraph in MS Word?
Ctrl + click on a paragraph
Double-click on a paragraph
Triple-click on a paragraph
Alt + click on a paragraph
Correct answer
Ctrl + click on a paragraph
Which of the following is NOT an email service provider?
Yahoo Mail
Hotmail
Coolmail
Gmail
Correct answer
Yahoo Mail
What will be the result of formula '=16/2^3' in a cell in MS Excel?
2
512
124
6
Correct answer
2
Which of the following is true with reference to opening and closing documents in MS Word 2007?
To close a document, click '-' in the upper right corner of the window.
For opening a new file, click on 'New' in Windows button.
The shortcut key for opening a document is Ctrl + F.
By default, MS Word document contains no pages when it is opened.
Correct answer
To close a document, click '-' in the upper right corner of the window.
Which of the following protocols pushes email messages to the server?
SMTP
HTTP
Both, POP and HTTP
POP
Correct answer
SMTP
State whether the following statements related to MS Word are true or false.
(i) When you open a new file in MS Word, by default it has a Landscape orientation.
(ii) When you open a new file in MS Word, by default it has a Portrait orientation.
(i) True, (ii) True
(i) False, (ii) True
(i) True, (ii) False
(i) False, (ii) False
Correct answer
(i) True, (ii) True
Consider a formula "= A3 + B4" in cell A5. If cell A5 is copied and pasted into E9, then what will be the formula in cell E9?
= A3 + B4
= E8 + F7
= E7 + F8
= B4 + C5
Correct answer
= A3 + B4
Which of the following is NOT a valid 'Change case' option in MS Word?
Uppercase
Toggle case
Lowercase
Pascal case
Correct answer
Uppercase
Which of the following appears as a part of the 'Editing' command group within the Home menu in recent versions of MS Word, such as Word 2016?
Change case
Font color
Format Painter
Replace
Correct answer
Change case
What will be the result of the following MS Excel formula?
= FACT(0) + FACT(3) + FACT(5)
126
9
127
8
Correct answer
126
Which of the following keyboard shortcuts is used to move to the right of the current tab in a Chrome browser?
Ctrl + Shift + Tab
Ctrl + Tab
Alt + Left arrow
Ctrl + Page up
Correct answer
Ctrl + Shift + Tab
In dotted-decimal notation, an IP version 4 address is represented by using exactly ______ dot (.) symbols.
three
four
five
two
Correct answer
three
Which of the following keyboard shortcuts can be used to indent paragraphs in an MS Word document?
Alt + I
Alt + T
Ctrl + I
Ctrl + M
Correct answer
Alt + I
When you open a new workbook in MS Excel, which of the following appears on the topmost portion of the screen?
Horizontal scroll bar
Vertical scroll bar
Status bar
Title bar
Correct answer
Horizontal scroll bar
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.