PPSC Punjab Police Data Entry Operator Previous Papers Archives - Page 3 of 3

Which of the following is not a valid version of Microsoft Office?

A. Office 2003

B. Office 2007

C. Office 2016

D. Office Vista

Correct answer is: D. Office Vista

Office Vista is not a valid Microsoft Office version.

____ is a predefined set of colors, fonts, and visual effects that you apply to your slides in PowerPoint for a unified, professional look.

A. Design

B. Animation

C. Layout

D. Theme

Correct answer is: D. Theme

A theme in PowerPoint provides a consistent look with predefined colors, fonts, and effects.

The process of arranging data in a logical sequence is called:

A. Filtering

B. Grouping

C. Sorting

D. Formatting

Correct answer is: C. Sorting

Sorting arranges data in a specific order, such as ascending or descending.

MS Word is a type of:

A. System Software

B. Programming Software

C. Utility Software

D. Application Software

Correct answer is: D. Application Software

MS Word is an application software used for word processing.

Which protocol provides email facility among different hosts on the internet?

A. HTTP

B. SMTP

C. FTP

D. SNMP

Correct answer is: B. SMTP

SMTP (Simple Mail Transfer Protocol) enables email communication between hosts.

Which of the following functions in MS Excel counts the number of cells within a range that meet the given condition?

A. COUNTIFB

B. COUNTA

C. COUNT

D. COUNTIF

Correct answer is: D. COUNTIF

COUNTIF counts cells in a range that meet a specified condition.

The intersection of a row and a column in a spreadsheet (e.g., MS Excel) is called a:

A. Box

B. Field

C. Cell

D. Sheet

Correct answer is: C. Cell

The intersection of a row and column in a spreadsheet is referred to as a cell.

Which keyboard shortcut is used to create a formula that sums all the cells above the active cell in Excel?

A. Alt + S

B. Ctrl + =

C. Alt + =

D. Shift + =

Correct answer is: C. Alt + =

Alt + = inserts a SUM formula for the cells above the active cell in Excel.

Gmail, Hotmail, and Yahoo are examples of:

A. Search engines

B. Web browsers

C. Email servers

D. None of these

Correct answer is: C. Email servers

Gmail, Hotmail, and Yahoo provide email services, functioning as email servers.

The Protect Document option can be found in the ____ tab of the Ribbon.

A. Review

B. Home

C. References

D. Edit

Correct answer is: A. Review

The Protect Document option is located in the Review tab in MS Word.

Shimmer, Sparkle text, Blinking Background etc. are known as:

A. WordArt

B. Font styles

C. Text effects

D. Badge

Correct answer is: C. Text effects

These are visual enhancements applied to text, known as text effects in software like PowerPoint.

The functions of Copy and Paste reside in which group on the Home tab in MS Word?

A. Home

B. Paragraph

C. Style

D. Clipboard

Correct answer is: D. Clipboard

Copy and Paste are located in the Clipboard group on the Home tab in MS Word.

What are cookies in a web browser used for?

A. Cleaning the browser cache

B. Displaying advertisements

C. Storing user data and preferences

D. Blocking pop-ups

Correct answer is: C. Storing user data and preferences

Cookies store user data like login details and preferences to enhance browsing.

If you want to apply the formatting of one page to another without copying the text, which tool should you use?

A. Copy-Paste

B. Format Painter

C. Format Text Box

D. Page Setup

Correct answer is: B. Format Painter

Format Painter copies formatting from one section to another without copying content.

The World Wide Web (WWW) is used for:

A. Sending e-mails

B. File printing

C. Accessing and sharing information over the internet

D. Operating system functions

Correct answer is: C. Accessing and sharing information over the internet

The WWW enables access and sharing of information via websites on the internet.

Which category of computer data typically consumes the most memory?

A. Text

B. Numbers

C. Graphics

D. Symbols

Correct answer is: C. Graphics

Graphics, such as images and videos, require significantly more memory than text or numbers.

What is the primary function of the Windows Task Manager?

A. File management

B. System configuration

C. Process and resource management

D. Disk cleanup

Correct answer is: C. Process and resource management

Windows Task Manager monitors and manages running processes and system resources.

In a LAN (Local Area Network) system, the operation mainly depends on the:

A. Node

B. Hub

C. Server

D. Ring

Correct answer is: C. Server

The server is central to LAN operations, managing data and resources.

Which keyboard shortcut is used to change the case of selected text in Microsoft Word?

A. Ctrl + Shift + A

B. Shift + F3

C. Ctrl + F3

D. Alt + F3

Correct answer is: B. Shift + F3

Shift + F3 cycles through case options (uppercase, lowercase, title case) in MS Word.

What is a range in Microsoft Excel?

A. A1

B. #REF!

C. B1:B2

D. 100

Correct answer is: C. B1:B2

A range in Excel refers to a group of cells, such as B1:B2, denoted by a colon.

The feature of Word that automatically adjusts the amount of space between certain combinations of characters so that an entire word looks more evenly spaced is called:

A. Spacing

B. Kerning

C. Positioning

D. Scaling

Correct answer is: B. Kerning

Kerning adjusts spacing between characters for better visual alignment.

____ is the measurement of the amount of data that can be transmitted over a network at any given time.

A. Search engines

B. Web browsers

C. Email servers

D. Bandwidth

Correct answer is: D. Bandwidth

Bandwidth measures the data transmission capacity of a network.