PPSC Past Papers & Solved MCQs

The World Wide Web (WWW) is a system of interlinked hypertext documents accessed via the Internet. Its primary function is to access and share information globally through web browsers.

• "Sending e-mails" (A) is a function of email protocols (like SMTP, POP3, IMAP), not the WWW itself, although email clients can be accessed via the web.
• "File printing" (B) is a local or network printer function, not directly related to the WWW's core purpose.
• "Operating system functions" (D) refer to the core tasks managed by an OS (e.g., memory, process, file management), which are distinct from the WWW's role as an information system.

Graphics typically consume the most memory because they are composed of many individual pixels, each requiring data to define its color and intensity. High-resolution images or complex 3D models contain vast amounts of pixel data, leading to significant memory usage.

• "Text" (A) and "Numbers" (B) are represented by character codes (e.g., ASCII, Unicode) or numerical formats, which are very compact.
• "Symbols" (D) are also character-based and require minimal memory, similar to text. The complexity and detail of graphical data far exceed that of simple textual or numerical representations.

The primary function of the Windows Task Manager is process and resource management. It allows users to monitor running applications, processes, and services, view system performance (CPU, memory, disk, network usage), and manage startup programs. Users can also end unresponsive tasks.

• "File management" (A) is handled by File Explorer.
• "System configuration" (B) is typically done through the Control Panel or Settings app.
• "Disk cleanup" (D) is a utility specifically designed to free up disk space, not the main role of Task Manager.

In many typical LAN systems, especially client-server architectures, the operation mainly depends on the server. The server provides centralized resources, services, and data to client nodes, managing network access, security, and shared applications. Without a server, many network functions would be unavailable or decentralized.

• A "Node" (A) is any device connected to the network, but it doesn't dictate the network's overall operation.
• A "Hub" (B) is a basic networking device that connects multiple devices, but it's a passive component and doesn't manage operations like a server. Modern LANs often use switches instead of hubs.
• A "Ring" (D) refers to a network topology, not a device that dictates operation. While a ring topology connects devices, the server still provides the core services.

In Microsoft Word, the keyboard shortcut Shift + F3 is used to cycle through different text cases for selected text: Sentence case, lowercase, and UPPERCASE. This is a highly efficient way to adjust text formatting without using the mouse.

• "Ctrl + Shift + A" (A) is used to toggle all caps for selected text.
• "Ctrl + F3" (C) is used to cut selected text to the Spike (a special clipboard).
• "Alt + F3" (D) is used to create a new building block from selected text. Therefore, Shift + F3 is the specific shortcut for changing case cyclically.

In Microsoft Excel, a range refers to a collection of two or more cells. It is typically represented by the cell address of the top-left cell, followed by a colon, and then the cell address of the bottom-right cell. Therefore, B1:B2 correctly denotes a range encompassing cells B1 and B2.

• "A1" (A) represents a single cell, not a range.
• "#REF!" (B) is an error message indicating an invalid cell reference.
• "100" (D) is a numerical value, not a cell reference or a range. Understanding ranges is fundamental for performing calculations and applying formatting to multiple cells simultaneously.

Kerning is a fundamental typographic concept that involves adjusting the space between specific pairs of characters to achieve a visually pleasing and evenly spaced appearance for an entire word. This feature is crucial for professional document presentation, preventing awkward gaps or overlaps between letters like "VA" or "To".

• Spacing is a general term for the distance between elements, not specifically character pairs for visual balance.
• Positioning refers to the placement of text blocks or objects on a page, not the fine-tuning of space between individual characters.
• Scaling involves changing the overall size of characters or objects, rather than their inter-character spacing.

The process of arranging data in a logical sequence, such as alphabetical, numerical, or chronological order, is known as Sorting. This is a core data management function that helps in organizing and analyzing information efficiently.

• Filtering involves displaying only the data that meets specific criteria, hiding the rest, but it does not rearrange the order of the data.
• Grouping organizes data into categories based on common attributes, but it doesn't necessarily sequence the entire dataset in a logical order.
• Formatting refers to changing the appearance of data, such as font, color, or cell borders, without altering its underlying order or content.

MS Word is categorized as Application Software. This type of software is designed to perform specific tasks for the end-user, such as word processing, creating spreadsheets, or browsing the internet. It directly helps users accomplish productive work.

• System Software manages computer hardware and software resources, like operating systems (e.g., Windows, macOS).
• Programming Software provides tools for developers to write, test, and debug computer programs (e.g., compilers, debuggers).
• Utility Software helps maintain and optimize computer performance (e.g., antivirus programs, disk defragmenters).

Email communication relies on specific protocols to ensure messages are sent and received across different networks. The question asks for the protocol responsible for providing email facilities between hosts.

• "SMTP" (Simple Mail Transfer Protocol) is the correct answer. SMTP is the standard protocol used for sending and routing email messages between mail servers. When you send an email, your email client typically uses SMTP to send it to your outgoing mail server, which then uses SMTP to relay it to the recipient's mail server.
• "HTTP" (Hypertext Transfer Protocol) is used for accessing web pages.
• "FTP" (File Transfer Protocol) is used for transferring files between computers.
• "SNMP" (Simple Network Management Protocol) is used for managing network devices.

Thus, SMTP is fundamental for email delivery on the internet.

In MS Excel, the COUNTIF function is specifically designed to count the number of cells within a specified range that meet a single given condition or criterion. This is incredibly useful for conditional data analysis.

• COUNTIFB is not a standard or recognized function in MS Excel.
• COUNTA counts the number of cells in a range that are not empty, regardless of their content type (numbers, text, errors).
• COUNT counts the number of cells in a range that contain only numbers. It ignores empty cells and cells containing text or logical values.

Bandwidth is the correct answer. It is a fundamental concept in computer networking, representing the maximum rate of data transfer across a given path or network connection. A higher bandwidth allows for more data to be transmitted per unit of time, directly impacting network performance and speed.

• Search engines (A) are software systems designed to find information on the World Wide Web.
• Web browsers (B) are applications used to access and view websites.
• Email servers (C) are computer systems that manage the sending and receiving of email messages.

None of the distractors relate to the measurement of data transmission capacity, which is precisely what bandwidth defines.