PPSC Punjab Police All Past Papers

This question asks to identify the primary Microsoft Office application for creating presentations and visual diagrams like flowcharts.

• Correct Option C: "MS PowerPoint" is the dedicated application for creating presentations, which inherently involves designing slides, incorporating text, images, charts, and often flowcharts to visually convey information. It provides tools for drawing shapes and connectors suitable for flowcharts.
• Option A: "MS Excel" is primarily used for spreadsheets, data analysis, and calculations, not for creating presentations or flowcharts.
• Option B: "MS Word" is a word processor used for creating documents, reports, and letters. While it can create basic diagrams, it's not its primary function for presentations or complex flowcharts.
• Option D: "MS Access" is a database management system, used for storing and managing structured data, completely unrelated to creating presentations or flowcharts.

This question tests knowledge of default naming conventions in Microsoft Excel.

• Correct Option D: "Book1" is the standard default file name for a new, unsaved workbook in Microsoft Excel. When you open Excel or create a new workbook without specifying a name, it is automatically assigned "Book1", then "Book2", "Book3", and so on for subsequent new workbooks in the same session.
• Option A: "NewBook1" is not the default naming convention used by Excel.
• Option B: "Excel1" is also not the default name.
• Option C: "Sheet1" is the default name for the first worksheet within a new workbook, not the workbook file itself. A workbook contains one or more sheets.

The Title Slide is the standard first slide in a PowerPoint presentation. Its primary purpose is to introduce the presentation's topic and often includes placeholders for the title, subtitle, and presenter's name. It sets the stage for the entire presentation. While 'Introduction Slide,' 'Main Slide,' and 'Opening Slide' might describe its function, they are not the official, designated name for this specific slide type within PowerPoint's interface and structure. PowerPoint automatically generates a Title Slide when a new presentation is created, highlighting its foundational role.

The space between lines of a paragraph in Microsoft Word is called Line Spacing. This feature allows users to adjust the vertical distance between lines of text within a paragraph, commonly set to single, 1.5 lines, or double. Paragraph Spacing refers to the space before or after an entire paragraph. Indentation controls the distance of the paragraph from the page margins. Margin refers to the blank space around the edges of the page itself. Therefore, Line Spacing is the precise term for the vertical distance between text lines.

The 'Hidden' checkbox option, which allows users to conceal text in Microsoft Word, is located within the Font Dialog Box. This is because 'Hidden' is considered a character-level formatting attribute, similar to bold, italic, or underline, affecting the display properties of selected text. The Paragraph Dialog Box manages paragraph-level formatting like alignment and line spacing. The Page Setup Dialog Box controls document layout settings such as margins and orientation. The Styles Dialog Box applies predefined sets of formatting, but the direct 'Hidden' attribute is found under Font settings.

Headers and footers are visible in Microsoft Word's Print Layout view. This view is designed to show the document exactly as it will appear when printed, including all page elements like margins, headers, footers, and graphics. In contrast, Web Layout view displays the document as it would appear in a web browser, often without headers/footers. Outline View focuses on the document's structure and headings. Draft View (formerly Normal View) shows only the text, making it faster for typing and editing, but it hides headers and footers to simplify the display.

The keyboard shortcut used to increase the font size in Microsoft Word is Ctrl + Shift + >. This shortcut incrementally increases the font size of the selected text. Ctrl + [ is used to decrease the font size. Ctrl + Shift + L is typically used to apply a bulleted list. Ctrl + Alt + Up Arrow is often used to move a paragraph up in some applications or for display rotation on certain graphics cards. Therefore, Ctrl + Shift + > is the correct and standard shortcut for increasing font size.

The keyboard shortcut used to copy selected text is Ctrl + C. This command duplicates the selected content and places it onto the clipboard, allowing it to be pasted elsewhere without removing it from its original location. Ctrl + X is used to 'cut' selected text, removing it from its original location and placing it on the clipboard. Ctrl + V is used to 'paste' content from the clipboard. Ctrl + Z is the universal shortcut for 'undoing' the last action. Thus, Ctrl + C is the correct shortcut for copying.

The Microprocessor, often referred to as the Central Processing Unit (CPU), is the silicon chip responsible for executing instructions, performing calculations, and managing data flow within a computer. It is essentially the 'brain' of the computer.

• Hard Disk is a storage device used to permanently save data, not for processing.
• RAM (Random Access Memory) is volatile memory used for temporary storage of data that the CPU is actively using, but it does not process data itself.
• Monitor is an output device that displays visual information to the user, not a processing component.

Therefore, the microprocessor is the correct answer as it performs the data processing functions.

The keyboard shortcut Ctrl + = is the correct command to apply subscript formatting to selected text in Microsoft Word. Subscript places text slightly below the baseline, often used for chemical formulas like H2O.

• Ctrl + Shift + + (or Ctrl + Shift + =) is used for superscript formatting, which places text slightly above the baseline.
• Alt + = is typically used to insert an equation field in Word, allowing users to type mathematical equations.

Understanding these shortcuts enhances efficiency when formatting documents.

The default file extension for a Microsoft Word document is .docx. This extension was introduced with Word 2007 as part of the Office Open XML format, offering improved file recovery and smaller file sizes compared to older formats.

• .txt is the extension for plain text files, which contain no formatting.
• .xls is the default file extension for Microsoft Excel spreadsheets in older versions (pre-2007). The current default is .xlsx.
• .pptx is the default file extension for Microsoft PowerPoint presentations.

Knowing file extensions helps identify the type of document and the program required to open it.

HTML (HyperText Markup Language) is the foundational language primarily used for creating the structure and content of web pages. It uses a system of tags to define elements like headings, paragraphs, images, and links.

• C++ is a powerful, general-purpose programming language used for system programming, game development, and high-performance applications, but not for structuring web pages directly.
• Python is a versatile programming language widely used for web development (backend), data analysis, AI, and scripting, but it doesn't define the client-side structure of a web page.
• Java is a robust, object-oriented programming language used for enterprise applications, Android development, and some backend web services, but not for the primary markup of web pages.

HTML is essential for any content displayed in a web browser.

HTTP stands for HyperText Transfer Protocol. This foundational protocol is the backbone of data communication for the World Wide Web, defining how web browsers request web pages and how web servers respond. It dictates the format and transmission of messages between clients and servers, enabling the exchange of hypertext documents and other web content.

Option A, "Hyper Tool Transfer Protocol," is incorrect as "Tool" is not part of the official acronym. Option C, "High Text Transfer Protocol," incorrectly uses "High" instead of "HyperText." Option D, "Hyperlink Transfer Protocol," is also incorrect; while HTTP facilitates hyperlinks, the correct term in the acronym is "HyperText," referring to text with links.

The computer that processes both analog and digital data is called a Hybrid computer. These specialized machines combine the best features of both analog and digital computers, allowing them to handle continuous physical quantities (like temperature or pressure) and discrete numerical data simultaneously. They are often used in complex scientific and industrial applications where real-time processing of varied data types is crucial.

An Analog computer processes continuous data, while a Digital computer processes discrete data (binary 0s and 1s). A Mainframe computer is a large, powerful digital computer primarily for high-volume data processing, not defined by its ability to process both analog and digital signals.

Charles Babbage is widely recognized as the "Father of the Computer." In the 19th century, he conceptualized and designed the Analytical Engine, which incorporated many fundamental elements of modern computers, including a programmable design using punched cards, a memory unit, and an arithmetic logic unit. His visionary work laid the theoretical groundwork for future computing machines.

Alan Turing was a brilliant mathematician known for the Turing machine and his contributions to artificial intelligence, but not the "Father of the Computer." Bill Gates and Steve Jobs were instrumental in the personal computer revolution and software development, but they did not invent the foundational concept of the computer itself.

The process that produces results of processed data for getting useful information is known as Output. In the computing cycle, after data has been input and processed, the output stage presents the transformed data in a human-readable or machine-readable format. This makes the raw data meaningful and useful, whether displayed on a screen, printed, or transmitted.

Control refers to managing operations within the system. Storage involves saving data for future use. Processing is the actual manipulation of data. While processing occurs before output, output is the specific stage responsible for delivering the final, useful results to the user.

A computer that has more than one processor is called a Multiprocessor system. This architecture allows multiple central processing units (CPUs) to work in parallel, significantly enhancing the computer's ability to execute instructions and handle multiple tasks concurrently. This design improves overall performance, speed, and efficiency, especially in demanding applications and server environments.

A Uniprocessor system has only one CPU. A Microprocessor is a single integrated circuit containing a CPU, but doesn't imply multiple processors in a system. A Minicomputer is a class of multi-user computers, defined by size and capability, not specifically by the number of processors.

In MS Excel, indentation refers to moving cell content away from the cell border. This formatting feature allows users to visually offset text or numbers within a cell, typically from the left border, without altering the cell's actual alignment. It's used to improve readability, create hierarchical lists, or visually group related data within a worksheet, enhancing the presentation of information.

Merging two or more cells combines them into a single larger cell. Changing text direction rotates the text within a cell. The Styles Dialog Box is a feature for applying predefined or custom formatting styles, but it is not the definition of indentation itself.

The Internet is fundamentally a vast, interconnected global computer network. Option C, "A global computer network connecting millions of devices," accurately defines it as a worldwide system of interconnected computer networks that uses standard Internet Protocol Suite (TCP/IP) to serve billions of users. It enables communication and data exchange across the globe.

• Option A ("A software used to play games") is incorrect; software for games is an application that might use the Internet, but it is not the Internet itself.

• Option B ("A local area network in an office") describes a LAN, which is a small, localized network, not the global Internet.

• Option D ("A large computer used in universities") refers to a single machine, not a network of interconnected devices.

MySQL is the correct answer. It is one of the most widely used relational database management systems (RDBMS) and offers powerful features, reliability, scalability, and support for graphical administration tools such as MySQL Workbench, making database management easier.

• DNMS is not a recognized standard database management system.
• RDBMS refers to a category of database systems, not a specific software product.
• MySQL is a specific RDBMS that provides advanced database management features.
• None of these is incorrect because MySQL is a valid answer.

In Microsoft Excel, formatting options are used to customize the appearance of cells. To remove borders, you need to access the specific border formatting tools. Option B, "Choose No Border," is the correct method. You typically select the cells, go to the 'Home' tab, find the 'Borders' dropdown in the 'Font' group, and then select 'No Border' to clear any existing cell borders.

• Option A ("Press Enter") is incorrect as pressing Enter confirms cell input or moves the cursor, it does not affect cell borders.

• Option C ("Use formula") is incorrect; formulas are for calculations and data manipulation, not for applying or removing visual formatting like borders.

• Option D ("Not possible in Excel") is false; removing borders is a fundamental formatting capability in Excel.

During a computer's startup sequence, a crucial piece of firmware is responsible for initializing and configuring hardware. Option B, "BIOS" (Basic Input/Output System), is the correct answer. BIOS is firmware stored on a chip on the motherboard that performs a Power-On Self-Test (POST) and initializes hardware components before loading the operating system.

• Option A ("Operating system") is incorrect; the operating system loads after the BIOS has completed its initial hardware checks and configuration.

• Option C ("Driver") refers to software that allows the operating system to communicate with specific hardware devices, not the initial startup firmware.

• Option D ("Cache") is a type of fast memory used to store frequently accessed data, unrelated to the startup configuration process.

Project management and task tracking software are designed to help individuals and teams organize work, manage deadlines, and monitor progress. Option A, "ASANA," is a widely recognized and popular web and mobile application specifically built for project management, task tracking, and team collaboration, offering features like task assignment, timelines, and progress reporting.

• Option B ("Zoom") is incorrect; Zoom is primarily a video conferencing and online meeting platform.

• Option C ("Sublime") refers to Sublime Text, which is a sophisticated text editor primarily used by developers for coding, not project management.

• Option D ("HAWET") is not a commonly known or recognized software for project management or task tracking.

File compression is the process of reducing the size of one or more files to save disk space or facilitate faster transmission. Option C, ".zip," is the most common and widely recognized file extension for compressed archives. The .zip format allows multiple files and folders to be bundled into a single file, significantly reducing their overall size.

• Option A (".docs") is incorrect; .docs is typically associated with Microsoft Word document files.

• Option B (".cmp") is not a standard or widely used file extension for general file compression.

• Option D (".clp") is often associated with Windows Clipboard files, which store clipboard contents, not compressed files.

Microsoft Corporation was co-founded by two individuals who played pivotal roles in its establishment in 1975. Understanding the founders is key to recognizing the company's origins.

• A: Jimmy Wales is incorrect; he is known for co-founding Wikipedia.
• B: Bill Gates is a co-founder, but not the sole founder.
• C: Paul Allen is also a co-founder, but not the sole founder.
• D: Both B & C is the correct answer because both Bill Gates and Paul Allen were instrumental in founding Microsoft, making them its co-founders.