IBPS Clerk - MS Office, Internet, Networking, Database Basics Question Bank with Options

1. What is the term for the combination of hardware and software that allows computers to communicate with each other?

A) Operating System

B) Application Software

C) Network

D) Database

2. In PowerPoint, what is a 'Slide Master' used for?

A) To apply transitions between slides

B) To create animations for objects

C) To define the default formatting and layout for all slides in a presentation

D) To insert audio and video clips

3. What does 'DBMS' stand for?

A) Data Management Business System

B) Database Management System

C) Data and Memory Backup System

D) Digital Management and Backup Service

4. Which of the following is a common type of network cable?

A) USB cable

B) HDMI cable

C) Ethernet cable

D) Audio cable

5. What is the primary function of a search engine like Google?

A) To store personal files

B) To send emails

C) To find information on the World Wide Web

D) To create presentations

6. Which MS Office feature allows you to automate repetitive tasks by recording a sequence of actions?

A) PivotTable

B) Macro

C) VLOOKUP

D) Conditional Formatting

7. What is the term for the software that allows a computer to access and display web pages?

A) Search Engine

B) Web Browser

C) Web Server

D) URL

8. Which of the following is a characteristic of a peer-to-peer (P2P) network?

A) Centralized server

B) Each computer can act as both a client and a server

C) Requires a dedicated network administrator

D) High security by default

9. In a database, what is a field?

A) A row of data

B) A column of data representing a specific attribute

C) The entire database file

D) A unique identifier for a table

10. What is the default port number for HTTP?

A) 21

B) 25

C) 80

D) 443

11. Which network topology resembles a circle or a ring?

A) Bus

B) Star

C) Ring

D) Mesh

12. What is the term for a device that connects a home or office network to the Internet?

A) Router

B) Switch

C) Hub

D) Modem

13. Which MS Office application is primarily used for creating documents with text, images, and formatting?

A) Microsoft Excel

B) Microsoft PowerPoint

C) Microsoft Word

D) Microsoft Access

14. What does 'SQL' stand for in the context of databases?

A) Structured Query Language

B) Simple Query Logic

C) Sequential Query Language

D) System Query Language

15. Which of the following is a cloud storage service?

A) Microsoft Word

B) Google Drive

C) Adobe Photoshop

D) Mozilla Firefox

16. In a relational database, what is a relationship between two tables called?

A) Primary Key

B) Foreign Key

C) Index

D) Schema

17. What is the term for a small piece of data sent from a website and stored on the user's computer by the user's web browser?

A) Cache

B) Cookie

C) URL

D) HTML

18. Which Internet protocol is used to retrieve emails from a mail server?

A) SMTP

B) HTTP

C) POP3

D) FTP

19. What is the term for a set of rules that govern how data is transmitted over a network?

A) IP Address

B) Topology

C) Protocol

D) Firewall

20. Which MS Office application is designed for creating and managing databases?

A) Microsoft Word

B) Microsoft Excel

C) Microsoft Access

D) Microsoft Publisher

21. In Excel, what is a cell reference?

A) The value entered in a cell

B) The formula within a cell

C) The address of a cell, such as A1

D) The name of the worksheet

22. What is the term for the speed at which data can be transmitted over a network connection?

A) Latency

B) Bandwidth

C) Throughput

D) Packet size

23. Which of these is a common example of a WAN?

A) A home Wi-Fi network

B) Computers in a single office building

C) The Internet

D) A network of computers in a single classroom

24. What is the main purpose of a database query?

A) To create a new table

B) To add new records

C) To retrieve specific information from a database

D) To delete the entire database

25. Which MS Office application is used for managing email, calendars, and contacts?

A) Microsoft Word

B) Microsoft Excel

C) Microsoft PowerPoint

D) Microsoft Outlook

26. What is the term for the physical arrangement of network components?

A) Topology

B) Protocol

C) Bandwidth

D) Latency

27. In networking, what is an IP address?

A) A username for a website

B) A unique numerical label assigned to each device connected to a computer network

C) A type of network cable

D) A software application for browsing the internet

28. Which of the following is a type of database model?

A) Hierarchical

B) Network

C) Relational

D) All of the above

29. What does the 'S' in 'HTTPS' stand for?

A) Server

B) Secure

C) Site

D) Speed

30. Which MS Office feature allows users to create a personalized document by merging data from a data source (like an Excel sheet) with a main document?

A) Track Changes

B) Mail Merge

C) Table of Contents

D) Styles

31. What is the purpose of a firewall in a network?

A) To increase internet speed

B) To filter incoming and outgoing network traffic for security

C) To connect multiple devices wirelessly

D) To store large amounts of data

32. In Excel, which function is used to sum a range of cells?

A) AVERAGE

B) COUNT

C) SUM

D) MAX

33. What is the main advantage of a client-server network architecture?

A) Increased redundancy

B) Centralized data management and security

C) Simpler network setup

D) Lower hardware costs

34. Which of the following is NOT a common Internet service?

A) Email

B) Web browsing

C) File sharing

D) Word processing

35. What is the protocol used for transferring files between a client and a server?

A) HTTP

B) FTP

C) SMTP

D) POP3

36. Which MS Office application is a database management system?

A) Microsoft Word

B) Microsoft Excel

C) Microsoft PowerPoint

D) Microsoft Access

37. What is the term for a unique identifier for each record in a database table?

A) Foreign Key

B) Primary Key

C) Index

D) Field Name

38. In a database, what is a collection of related records called?

A) Field

B) Table

C) Database

D) Record

39. What is the basic unit of data storage in a database?

A) Table

B) Field

C) Record

D) Database

40. Which type of network covers a large geographical area, like a country or the world?

A) LAN

B) MAN

C) WAN

D) PAN

41. What does 'LAN' stand for in networking?

A) Local Area Network

B) Large Area Network

C) Logical Area Network

D) Limited Area Network

42. Which device is used to connect multiple networks together?

A) Modem

B) Switch

C) Router

D) Hub

43. What is a network of computers connected together called?

A) A server

B) A protocol

C) A network

D) A router

44. Which of the following is a popular web browser?

A) Microsoft Word

B) Google Chrome

C) Adobe Photoshop

D) VLC Media Player

45. What is the primary function of a web browser?

A) To send emails

B) To create documents

C) To display web pages

D) To manage databases

46. Which protocol is used to send and receive emails?

A) HTTP

B) FTP

C) SMTP

D) TCP

47. What does the acronym 'URL' stand for in the context of the Internet?

A) Uniform Resource Locator

B) Universal Resource Link

C) Uniform Record Locator

D) Universal Record Link

48. Which MS Office application is used for creating presentations?

A) Microsoft Word

B) Microsoft Excel

C) Microsoft PowerPoint

D) Microsoft Outlook

49. In Microsoft PowerPoint, what is the term for a pre-designed slide layout that includes placeholders for text and graphics?

A) Animation

B) Template

C) Slide Master

D) Transition

50. What is the default file extension for Microsoft Word documents?

A) .xlsx

B) .pptx

C) .docx

D) .accdb

MS Office, Internet, Networking, Database Basics - Question Bank