PPSC Data Entry Operator Punjab Police Special Branch Past Paper 2025 Solved MCQs

Correct Answer: Bandwidth

Bandwidth refers to the maximum rate of data transfer across a given path, usually measured in bits per second.

Correct Answer: Server

In many network configurations, the server acts as the central hub that manages network resources and services for other devices.

Correct Answer: RJ-45

RJ-45 is the standard connector type used for Ethernet networking cables in computers.

Correct Answer: SMTP

Simple Mail Transfer Protocol (SMTP) is the standard communication protocol for electronic mail transmission.

Correct Answer: Cell

A cell is the rectangular space created by the intersection of a row and a column in a spreadsheet program.

Correct Answer: B1:B2

A cell range is defined by two or more cells, represented by the starting cell and the ending cell separated by a colon.

Correct Answer: COUNT IF

The COUNTIF function is used to count cells in a range that meet a single specific criterion.

Correct Answer: Alt + =

Alt + = is the shortcut for the AutoSum feature in Excel, which automatically sums a column or row of data.

Correct Answer: Auto Fill

Auto Fill is an Excel feature that automatically fills data based on a pattern or series.

Correct Answer: Ascending Order

Sorting from A to Z arranges items in ascending order; sorting from Z to A is descending.

Correct Answer: 1,048,576

Modern versions of Microsoft Excel support 1,048,576 rows per worksheet.

Correct Answer: =

In Excel, every formula must begin with the equals sign (=) to tell the application to perform a calculation.

Correct Answer: Name Box

The Name Box, located to the left of the formula bar, displays the cell reference (address) of the currently selected cell.

Correct Answer: Moving cell content away from the cell border

Indentation in Excel increases the space between the cell border and the text content within the cell.

Correct Answer: Choose no border

The 'No Border' option in the border formatting menu is used to clear any existing borders from selected cells.

Correct Answer: =AVERAGE(B3:E5)

The AVERAGE function in Excel calculates the arithmetic mean of the specified cell range.

Correct Answer: Book1

By default, Microsoft Excel names new workbooks as 'Book1' until they are saved with a specific name.

Correct Answer: Email servers

Gmail, Hotmail, and Yahoo are web-based email services that act as email servers for managing user accounts and messages.

Correct Answer: Storing user data and preferences

Cookies are small pieces of data stored by websites on a user's browser to remember user information and session preferences.

Correct Answer: Accessing and sharing information over the internet

The World Wide Web is an information system where documents and other web resources are identified by URLs and accessible via the internet.

Correct Answer: Hyper Text Transfer Protocol

HTTP stands for Hypertext Transfer Protocol, which is the foundation of data communication for the World Wide Web.

Correct Answer: A global computer network connecting millions of devices

The internet is a global network of interconnected computer networks that use standard protocols to communicate.

Correct Answer: HTML

HTML (HyperText Markup Language) is the standard markup language used to create and structure pages on the World Wide Web.

Correct Answer: Text effects

Text effects in software like MS Word add visual styling such as animations or formatting enhancements to selected text.

Correct Answer: Clipboard

The Clipboard group on the Home tab contains the Copy, Cut, and Paste commands in Microsoft Office applications.

Correct Answer: Format Painter

Format Painter is a tool that copies formatting from a selected object or text and applies it to another location.

Correct Answer: Review

The protect document option is typically located under the Review tab in Microsoft Office applications.

Correct Answer: Five

MS Word includes five main view modes: Read Mode, Print Layout, Web Layout, Outline, and Draft.

Correct Answer: Raised

Raised refers to font position (superscript), whereas expanded and condensed refer to character spacing.

Correct Answer: From File menu choose Close submenu

The 'Close' command in the File menu closes the current document, but it does not exit the entire MS Word application.

Correct Answer: Both A & C

In MS Word, the Zoom controls are accessible both from the View tab on the ribbon and the status bar at the bottom.

Correct Answer: Mail Merge

Mail Merge is a feature that enables users to create mass documents like letters or labels by pulling data from a list.

Correct Answer: Line Spacing

Line spacing is the distance between the lines of text within a paragraph.

Correct Answer: Font Dialog Box

The option to apply the 'Hidden' text effect is found within the Font dialog box.

Correct Answer: Print Layout

Print Layout view provides an accurate visual representation of how the document will look when printed, including headers and footers.

Correct Answer: Graphics

Graphics data, such as images or videos, requires significantly more storage memory than plain text or numerical data.

Correct Answer: Process and resource management

Windows Task Manager is used to monitor running processes, performance, and manage system resources.

Correct Answer: Shift + F3

Pressing Shift + F3 toggles the selected text between uppercase, lowercase, and title case.

Correct Answer: Alt + Tab

Alt + Tab is the standard keyboard shortcut used to switch between currently open windows or applications.

Correct Answer: Remove Paragraph formatting

In many Microsoft Office programs, Ctrl + Q is used to remove paragraph formatting from the selected text.

Correct Answer: Shift + Down Arrow

Shift plus an arrow key is the standard command for selecting cells in the direction of the arrow.

Correct Answer: Ctrl + F9

In Microsoft Excel, Ctrl + F9 is the shortcut to minimize the current workbook window.

Correct Answer: Ctrl + Shift + >

In MS Word, Ctrl + Shift + > is the shortcut used to increase the font size of the selected text.

Correct Answer: Ctrl + C

Ctrl + C is the universal keyboard shortcut for the copy command.

Correct Answer: Ctrl + =

Ctrl + = is the keyboard shortcut for applying subscript formatting in Microsoft Word.

Correct Answer: Kerning

Kerning adjusts the spacing between individual characters to create more visually pleasing and readable text.

Correct Answer: Sorting

Sorting is the process of arranging data in a specific order, such as alphabetical or numerical (ascending or descending).

Correct Answer: Application Software

MS Word is a word processing program designed to help users complete specific tasks, categorizing it as application software.

Correct Answer: MS PowerPoint

.ppt is the legacy file extension for Microsoft PowerPoint presentation files.

Correct Answer: Office Vista

Windows Vista is an operating system, not a version of the Microsoft Office productivity suite.

Correct Answer: ASANA

Asana is a dedicated web and mobile application designed to help teams organize, track, and manage their work.

Correct Answer: Theme

A theme in PowerPoint provides a cohesive look by applying a set of coordinated colors, fonts, and effects.

Correct Answer: Outline view

The Outline view in PowerPoint shows the text content of the slides in a hierarchical, easy-to-read list format.

Correct Answer: Transition

The option to advance slides 'on mouse click' is located under the Transition tab in PowerPoint.

Correct Answer: Presentations

Microsoft PowerPoint is a presentation software designed for creating slideshows and visual presentations.

Correct Answer: F5

Pressing the F5 key starts a PowerPoint slide show from the very first slide.

Correct Answer: All of these

PowerPoint supports inserting a wide range of media formats, including images like JPG and GIF, and audio files like WAV.

Correct Answer: MS PowerPoint

While specialized software like Visio exists, PowerPoint is frequently used for creating professional presentations and diagrams.

Correct Answer: F5

F5 is the shortcut key used to initiate a slideshow presentation starting from the first slide.

Correct Answer: Title Slide

The default first slide layout in a new PowerPoint presentation is the Title Slide.

Correct Answer: Title Bar

The title bar is located at the top of a window and displays the document or application name.

Correct Answer: Hybrid computer

Hybrid computers combine the features of both analog and digital computers to process different types of data.

Correct Answer: Charles Babbage

Charles Babbage is widely considered the father of computing for his conceptual design of the Analytical Engine.

Correct Answer: Both B & C

Bill Gates and Paul Allen co-founded Microsoft Corporation in 1975.

Correct Answer: Integrated Circuits (ICs)

Third-generation computers transitioned from discrete transistors to Integrated Circuits (ICs).

Correct Answer: Output

Output is the result generated after data has been processed by the computer.

Correct Answer: Multiprocessor

A multiprocessor system is a computer system that uses two or more central processing units within a single computer system.

Correct Answer: BIOS

BIOS (Basic Input/Output System) is firmware used to perform hardware initialization during the booting process.

Correct Answer: Microprocessor

A microprocessor is a central processing unit (CPU) contained on a single silicon chip, responsible for performing data processing.

Correct Answer: MySQL

MySQL is a widely used, robust Relational Database Management System (RDBMS) known for its features and performance.

Correct Answer: MS Access

MS Access is a database management system (DBMS) from Microsoft that combines the relational database engine with a graphical user interface.

Correct Answer: .zip

.zip is a standard file format used for data compression and archiving.

Correct Answer: .docx

.docx is the standard file format for documents created in Microsoft Word (2007 and later).

Correct Answer: Programming Language

Ada is a structured, statically typed, and object-oriented high-level programming language.