IBPS Clerk - MS Office, Internet, Networking, Database Basics Online Test (MCQ Quiz)

1. Which application in the MS Office suite is primarily used for creating spreadsheets and performing calculations?

A) Microsoft Word B) Microsoft PowerPoint C) Microsoft Excel D) Microsoft Access

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

A) .xlsx B) .pptx C) .docx D) .accdb

3. 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

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

A) Microsoft Word B) Microsoft Excel C) Microsoft PowerPoint D) Microsoft Outlook

5. 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

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

A) HTTP B) FTP C) SMTP D) TCP

7. 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

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

A) Microsoft Word B) Google Chrome C) Adobe Photoshop D) VLC Media Player

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

A) A server B) A protocol C) A network D) A router

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

A) Modem B) Switch C) Router D) Hub

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

A) Local Area Network B) Large Area Network C) Logical Area Network D) Limited Area Network

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

A) LAN B) MAN C) WAN D) PAN

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

A) Table B) Field C) Record D) Database

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

A) Field B) Table C) Database D) Record

15. 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

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

A) Microsoft Word B) Microsoft Excel C) Microsoft PowerPoint D) Microsoft Access

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

A) HTTP B) FTP C) SMTP D) POP3

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

A) Email B) Web browsing C) File sharing D) Word processing

19. 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

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

A) AVERAGE B) COUNT C) SUM D) MAX

21. 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

22. 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

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

A) Server B) Secure C) Site D) Speed

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

A) Hierarchical B) Network C) Relational D) All of the above

25. 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

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

A) Topology B) Protocol C) Bandwidth D) Latency

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

A) Microsoft Word B) Microsoft Excel C) Microsoft PowerPoint D) Microsoft Outlook

28. 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

29. 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

30. 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

31. 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

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

A) Microsoft Word B) Microsoft Excel C) Microsoft Access D) Microsoft Publisher

33. 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

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

A) SMTP B) HTTP C) POP3 D) FTP

35. 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

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

A) Primary Key B) Foreign Key C) Index D) Schema

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

A) Microsoft Word B) Google Drive C) Adobe Photoshop D) Mozilla Firefox

38. 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

39. 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

40. 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

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

A) Bus B) Star C) Ring D) Mesh

42. What is the default port number for HTTP?

A) 21 B) 25 C) 80 D) 443

43. 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

44. 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

45. 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

46. 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

47. 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

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

A) USB cable B) HDMI cable C) Ethernet cable D) Audio cable

49. 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

50. 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

MS Office, Internet, Networking, Database Basics - Online Test

Test Results