IBPS RRB (Computer Knowledge) 5 — Questions and Answers
Question 1: Which MS Excel function counts the number of cells in a range that meet a specified condition?
- COUNT()
- SUMIF()
- COUNTIF() (Correct answer)
- COUNTA()
Correct answer: COUNTIF()
COUNTIF() counts the number of cells within a range that satisfy a given criterion, such as counting all values greater than 100.
Question 2: What is a firewall primarily used for in computer networks?
- To increase internet speed
- To monitor and control incoming and outgoing network traffic based on security rules (Correct answer)
- To store backup copies of files
- To convert analog signals to digital
Correct answer: To monitor and control incoming and outgoing network traffic based on security rules
A firewall is a network security device or software that monitors and filters traffic based on predefined security rules to protect against unauthorized access.
Question 3: Which type of computer memory loses its contents when the power is switched off?
- ROM
- Hard disk
- RAM (Correct answer)
- Flash memory
Correct answer: RAM
RAM (Random Access Memory) is volatile memory, meaning all stored data is lost when the computer is powered off.
Question 4: In the context of the internet, what is a 'cookie'?
- A type of computer virus
- A small data file stored on a user's browser by a website (Correct answer)
- An encryption algorithm
- A web development programming language
Correct answer: A small data file stored on a user's browser by a website
A cookie is a small text file saved on a user's browser by a website to remember preferences, login sessions, or browsing activity.
Question 5: Which shortcut key is used to open the 'Find and Replace' dialog box in MS Word?
- Ctrl + F
- Ctrl + H (Correct answer)
- Ctrl + R
- Ctrl + G
Correct answer: Ctrl + H
Pressing Ctrl + H in MS Word opens the Find and Replace dialog box, allowing you to search for text and replace it with different text.
Question 6: What does 'HTTP 404' error code indicate when browsing a website?
- The website server is temporarily down
- The requested page could not be found on the server (Correct answer)
- The user's internet connection is lost
- Access to the page is forbidden
Correct answer: The requested page could not be found on the server
An HTTP 404 error means the server could not find the requested resource, typically because the page has been moved or deleted.
Question 7: Which of the following best describes an operating system?
- A hardware component that processes data
- Software that manages hardware and software resources and provides services for programs (Correct answer)
- A network device that routes internet traffic
- An application used only for word processing
Correct answer: Software that manages hardware and software resources and provides services for programs
An operating system (OS) is system software that manages computer hardware and software resources and acts as an intermediary between users and the hardware.
IBPS RRB (Computer Knowledge) 5
Which MS Excel function counts the number of cells in a range that meet a specified condition?