MS Office, Internet, Networking, Database Basics - One Line Questions

1. What is the default file extension for Microsoft Word documents? .docx
2. What is the default port number for HTTP? 80
3. Which of these is a common example of a WAN? The Internet
4. In a database, what is a field? A column of data representing a specific attribute
5. What is a network of computers connected together called? A network
6. In networking, what is an IP address? A unique numerical label assigned to each device connected to a computer network
7. In Microsoft PowerPoint, what is the term for a pre-designed slide layout that includes placeholders for text and graphics? Slide Master
8. In Excel, which function is used to sum a range of cells? SUM
9. Which network topology resembles a circle or a ring? Ring
10. 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? Cookie
11. Which of the following is a characteristic of a peer-to-peer (P2P) network? Each computer can act as both a client and a server
12. What does 'DBMS' stand for? Database Management System
13. Which of the following is NOT a common Internet service? Word processing
14. In a database, what is a collection of related records called? Table
15. What is the term for a unique identifier for each record in a database table? Primary Key
16. Which of the following is a type of database model? All of the above
17. Which protocol is used to send and receive emails? SMTP
18. What is the protocol used for transferring files between a client and a server? FTP
19. What is the main advantage of a client-server network architecture? Centralized data management and security
20. What is the term for a set of rules that govern how data is transmitted over a network? Protocol
21. Which type of network covers a large geographical area, like a country or the world? WAN
22. What is the term for the speed at which data can be transmitted over a network connection? Bandwidth
23. What does 'LAN' stand for in networking? Local Area Network
24. Which MS Office application is primarily used for creating documents with text, images, and formatting? Microsoft Word
25. Which application in the MS Office suite is primarily used for creating spreadsheets and performing calculations? Microsoft Excel
26. Which MS Office application is used for creating presentations? Microsoft PowerPoint
27. Which of the following is a popular web browser? Google Chrome
28. Which MS Office application is a database management system? Microsoft Access
29. Which MS Office application is used for managing email, calendars, and contacts? Microsoft Outlook
30. Which MS Office application is designed for creating and managing databases? Microsoft Access
31. Which of the following is a cloud storage service? Google Drive
32. Which device is used to connect multiple networks together? Router
33. What is the term for the combination of hardware and software that allows computers to communicate with each other? Network
34. Which MS Office feature allows you to automate repetitive tasks by recording a sequence of actions? Macro
35. In a relational database, what is a relationship between two tables called? Foreign Key
36. What is the term for a device that connects a home or office network to the Internet? Modem
37. What is the term for the software that allows a computer to access and display web pages? Web Browser
38. What does the 'S' in 'HTTPS' stand for? Secure
39. Which Internet protocol is used to retrieve emails from a mail server? POP3
40. What does 'SQL' stand for in the context of databases? Structured Query Language
41. What is the basic unit of data storage in a database? Field
42. In Excel, what is a cell reference? The address of a cell, such as A1
43. In PowerPoint, what is a 'Slide Master' used for? To define the default formatting and layout for all slides in a presentation
44. What is the main purpose of a database query? To retrieve specific information from a database
45. What is the purpose of a firewall in a network? To filter incoming and outgoing network traffic for security
46. What is the primary function of a web browser? To display web pages
47. What is the primary function of a search engine like Google? To find information on the World Wide Web
48. What is the term for the physical arrangement of network components? Topology
49. 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? Mail Merge
50. What does the acronym 'URL' stand for in the context of the Internet? Uniform Resource Locator