PPSC Junior Computer Operator Test Preparation MCQs in PDF

PPSC junior computer operator test preparation mcqs for jobs in Punjab Public Service Commission.

PPSC Junior Computer Operator Test Preparation MCQs

A social security number or a telephone number is considered to be this type of entry in a worksheet.

Numeric.
Text
Value
Formula

To open a template in Word first go to File and:

Click New
Click Display
Click Open
Click Search

From what location are the 1st computer instructions available on boot up?

ROM BIOS
CPU
boot .ini
CONFIG.SYS

Data communication requires

Sender
Receiver
Transmission medium
All of these

Data that is copied from an application is stored in the______

Driver
Clipboard
terminal
prompt

Which view shows margins and the ruler?

Normal
page Layout
page Setup
Review

You want to create a built-in cover page for your report. You go to to the:

Page Layout tab
Insert tab.
References tab .
Themes menu.

The Sort command of the Data menu provides this capability.

Multiple-row
Multiple -column
Multiple -field
Multiple-table

What is synonym for Contradict?

Predict
To Support
External
to oppose by words

What dialog box allows you to change a field name in Pivot Table?

Field Options
Field Pane
Field Settings
Field Structure

What is the background for a chart called?

Chart area
chart grid
Legend area
Plot grid

_____ is a technique that is used to send more than one call over a single line.

Digitizing
Duplexing
Multiplexing
Streaming

Which number will come next? 5,7,10,12,14,24,26

Which one of the following is not a prime number?

A _______ is a data communication system with in a building, plant, or campus, or between nearby buildings.

MAN
LAN
WAN
None of these

To what does the term “page orientation” refer?

An application that displays Web pages.
Combining two version of the same document.
Code in a mail merge main document that shows where data will be inserted.
Whether a page is laid out vertically or horizontally.

What is the name for a webpage address?

Directory
Domain
URL
Protocol

A combination of instructions and keystrokes that are stored and used in documents is called:

A shortcut
A macro
A keystroke
A function

What term describes a feature that gives Excel enhanced capability?

Trend lining
Enhancement bit
Thumbnail
Add-in

There are two different ways to insert content from one application into another-embedding and.

Importing
Integrating
Linking
Bookmarking

When you want to combine cells in any given table row, you:

Merge
Simplify
Join
Link

This describes the size, weight, and spacing of a character in a Word document.

Font
Typeface
Points
Typography

You can evenly adjust spacing in columns and rows by using the Table Tool called:

Equalize
Distribute
Mirror
Snap to Grid

Find odd man out

Japan
China
London
Canada

Where is the address of the active cell displayed?

Row heading
Status bar
Name Box
Formula bar

In the formula, = 10 + 5+15+25/5, Excel computes this first.

10+5
5+15
25/5
15+25

In a Rich Text content control field, the text :

Can be formatted
Cannot be formatted
IS limited to lower case
Cannot contain space

A man buys an item for Rs. 1400 and sells it at a loss of 15% . What is the selling price of the item?

Rs. 1090
Rs. 1160
Rs. 1190
Rs. 1202

Before you create labels such as name tags, specify the size by selecting:

Label Options
Layout
Format
Templates

A drive that can be removed or inserted while the computer is running is said to be_______

Robust
dynamic
hot swappable
SCSI

Which of the following will determine your choice of systems software for your computer?

is the applications software you want to use compatible with it?
Is it expensive?
Is it compatible with your hardware?
Both A and C

If ADD =9 , BAD = 7, and CAD = 8 what is da value of ADA?

What term describes shaped text?

TextArt
TextWord
WordArt
WordText

Which of the following is reliable communication?

TCP
IP
UDP
None of these

A driver drives 8 km South the 06 km W. and 2km S. again. she then drives 3km E to avoid a traffic jam before driving 6 km N. How many kilometers is she from her starting point?

Protecting a worksheet means:

No cell in a worksheet can be changed
Saving the workbook in a hidden folder
No additional changes can be made to a worksheet
To lock cells in the worksheet to that a user cannot inadvertently change them

Afzal mixed 40% kerosene solution to 25% kerosene solution hence obtaining 30% kerosene solution. in what ratio were the both solution mixed.

3:1
2:3
1:2
3:2

What do you see if you hover the mouse over a chart object?

Key Tip
Screen Tip
Chart Tip
Chart Key

Excel would evaluate the formula, =20*10/5*8, and return this answer.

5
6.25
320
232

What should follow the sheet name in a 3-d formula?

Colon
Parentheses
Period
Exclamation point

What Do-while is an _______ loop.

Entry control
Exit control
Entry enrolled
None of these

For what can you use Outlook Task?

Manage client data
Send and receive e-mail
Schedule appointments and meeting s
Manage to-do items

If the code for JAVA is LCXC what is the code for BASIC?

CBJTD
DCUKE
EDVLF
FEWMG

Find the odd man out

Carret
Cucumber
Onion
Ginger

A man is 24 years older than his son. In two years, his age will be twice the age of his son. The present age of his son is:

14 years
18 years
20 years
22 years

The Synonym of “Commence” is:

To End
To Begin
Nearing Finish
To Run

In which view does a page break appear as a black dashed line on the screen?

Normal
Page Bresk Preview
Page Layout
Custom

A Word template stores common documents:

Content
Structure
Style
Theme

How can words be separated by a range of names?

With a space
With a comma
With a period
With a colon

What term describes a picture that has been resized by a percentage?

Cropped
Flipped
Stretched
Scaled

User-developed instructions for Excel are called:

Programs
Macros
Procedures
All of these

Why might you hide worksheets in a workbook?

The file is smaller
The file is larger
Some data is private
Some data is formatted

What is the missing number? 1 4 9 ? 25

the information inside your table needs to be sorted alphabetically. To do this you go to:

Table Tppls Design
Page Layout
Home tab >Paragraph group.
Table Toos Layout

Which function automatically totals a column prow of values?

TOTAL
ADD
SUM
AVG

When you insert a comment in a document. the comment appears in a:

New window
Sidebar
balloon
Sticky

Which of the following is not a not major reason for an email bounce?

Bad user account name
bad domain name
Stale file handle
domain server is down

A car left Lahore at 7.12 am and arrived at a certain place 180 miles per hour

An unauthorized user is a network _____ issue.

Performance
Reliability
Security
All of these

What does an l-beam facilitate?

Locating text
Highlighting text
Dragging and selecting text
Formatting text

Each sector on a hard drive stores ______ bytes of data.

64
512
1,024
1Glga

Which is the largest fraction?

3/4
4/5
7/8
7/9

What category of function is used in this formula ? =PMT(C10/12, c8 ,c9 1)

Logical
Financial
Payment
Statistical

The most common types of storage devices are ______.

Magnetic
optical
flash
persistent

What is the sum of this series 1,2,3,4,._____99

1500
4950
2500
3000

When you insert a picture into a document the default text-wrapping option is:

Line with Text
None
Tight
Square

When typing character search criteria Excel matches based on

Alphabetical order
Capitalization
Spelling
Primary records

What function displays a row?

Hyperlink
Index
Transpose
Rows

Which option displays fill color in alternate rows in an Excel table?

Banded Rows
First Row
Last Row
Filled Rows

When inserting a graphic into a worksheet you could go to ceil to ceil A1 by pressing

SHIFT+HOME
CTRL+HOME
ENTER +HOME
ALT+HOME

The percentage increase in the area of a rectangle if each of its sides is increased by 20% is:

40%
42%
44%
46%

A ____ is a major database object used to display information in a printable page format.

Form
query
report
table

To get step-by-step instructions as you go through the Word mail merge process using:

A template
The Mail Merge Wizard
the Mailing Table
A macro

To move to the previous cell in a table inserted in a document press

The Tab Key
Alt+Table
Shift +Tab
Backspace

To have your macro available to all new documents you create store it in:

My Documents
Quick access
The Normal template
The Macro Gallery

Find the odd man out :

Coaxial cable
Microwaves
Optical fiber
Twisted pair wire

Reusable optical storage will typically have the acronym_____

Objects on the slide that hold text are called?

Placeholders
Object holders
Auto layout
text holders

CBT stands for?

Computer Based Testing
Computer Based Trade
Certificate Based Training
City of Big Towers

Which of the following memory is non volatile?

RAM
ROM
DRAM
SDRAM

Which mathematical operator is represented by an asterisk?

Exponentiation
Addition
Subtraction
Multiplication

How are font sizes specified?

Pixels
Spaces
Points
Picas

In Microsoft PowerPoint the best place to find animated images for your presentation is:

Microsoft Online
PowerPoint tools and ins
Word Clipart
All of these.

You want to create a built-in cover page for your report. You go to the:

Page Layout tab
Insert tab
References tab
Themes menu

Which of the following features determines how the contents of a cell are positioned in the cell?

AutoComplete
Cell Alignment
Format
Pick from List

Which of the following protocol provide email facility among different hosts?

FTP
SMTP
HTTP
TELNET

This will eliminate gaps in justified text In 3Wor document.

Hyphenation
Hanging indents
Pagination
Cross-referencing

To move to the end of a line of text, press the ——- key.

Page up
A
Enter
End

A word in a web page that. when clicked. opens another document.

URL
Hyperlink
Reference
Anchor

Another word for pointer is——

Pixel
cursor
point
monochrome

This feature recognizes and corrects commonly misspelled words

AutoComplete
AutoFormat
AutoCorrect
spell Check

To_____text. you select it. hold down the mouse button, and move the mouse.

cut
Draw
Paste
Drag

Which function automatically totals a column or row of values?

TOTAL
ADD
SUM
AVG

In Microsoft PowerPoint in order to see all the slides on one screen use:

View, Slide Sorter
View, Slide
View. Master
View. slide show

Which topology requires a central controller or hub?

Mesh
Star
Bus
Ring

A television broadcast is an example of —– transmission.

Simplex
Half-duplex
Full-duplex
Automatic

Which of the following commands enables users to set slide timings?

Set up Show
Slide Transition
Rehearse Timings
Custom Animation

Paint programs keep track of every —–placed on the screen ,

Image
Object
Pixel
Color

All computers must have ;

Operating System
Key board
Word Processor
Printer attached

A—– is a major database object used to display information in a printable page format

Form
Query
Report
Table

Software mistakes during coding are known as ?

Errors
Failures
Bugs
Defects

——– Cable Consists of an inner copper core and a second conducting outer sheath

Twisted -pair
Coaxial
riber-optic
Shielded twisted -pair

Which of the following is not an example of a pointing device ?

Bar cod reader
Mouse
Pointing stick
Touchpad

Your_____files store various various versions of running programs.

Cache
Memory
Temp
Static

Which of the following keystrokes updates a bibliography field?

If you have a sent an e-mail message , what folder would you access to resend it ?

Drafts
Inbox
Outbox
Sent Items

An IP V4 address consists of —–bits

This is the part of the computer system that one can touch

Hardware
Data
Software
Input

The unique identifier that is used when a word form is connected to a database is called ;

A label
An identifier
A sig
A tag,

The dots that run from a table of contents entry to the page number are called

A leader
A outline
A gutter
A connector

Using find Command in Word we can search ?

Characters
Formats
Symbols
Both A and C

Free hard -disk space used to extend the capacity of RAM is termed

Cache
Flash memory
ROM
Virtual memory

The ——is the software tool to store or access data

Table
DBMS
Query
Report

Ctrl ‘Shift and Alt are Called —— keys .

Adjustment
Function
Modifier
Alphanumeric

Which of the following represents one billion characters?

Byle
Gigabyte
Kilobyte
Megabyte

What is a motion path ?

A type of animation entrance effect
A method of advancing slllides
A method of moving items on a slide
All of these

the first part of a complete URL is the —– needed to access the web resource

Address
Name
Location
protocol

To send email to a large group at one time. a —– can be use

Listserv
Group
Allas
Mail server

—– memory loses its content ;when power is lost

Non volatile
Random
Static
ROM

Which learn best describes Outlook?

Database manager
Messaging client
Presentation client
Spreadsheet manager

Where is the address of the active cell displayed?

Row heading
Status bar
Name box
Formula bar

A combination of instructions and keystrokes that are stored and used in documents is called ;

A shortcut
A macro
Akeystroke
A function

Data that is copied from an application is stored in the —-

Driver
Clipbord
Terminal
Prompt

which function removes the decimal portion of a value?

CUTOFF
ROUNDUP
TRUNC
TRIM

To add an internal card to a computer ;it must have an open ——–

Expansion slot
Buy
Bus
USB port

A(n) —— query locates data from one or more tables

Select
Summary
Parameter
Action

Which key should be pressed to start a new paragraph in MS- Word?

Down Cursor Key
Enter +Key
Shift +Enter
Ctrl+Enter

A drive that can be removed or inserted while the computer is running is said to be ——

Robust
Dynamic
Hot swappable
SCSI

To automatically insert the last date a document was saved add :

A word field
A data field
Anumeric field
Afunction

A virus that replicates itself called——–

Bug
Worm
Vaccine
Troan Horse

To place a sound into a Word document you would use the —–feature of windows

OLE
Clipboard
padte
Task Switching

Which option in the Find/Replace dialog box makes a search task case-sensitive?

Match strings
Match case
String sensitive
Case sensitive

DNS refers to?

Data Number Sequence
Digital Network Service
Digital Name Service
Disk Numbering System

The browser’s—–keeps a list of web pages you have visited during the current session.

History
Cache
Favourites
Trail

what property works with the Protect Sheet command?

Locked
Property
Protection
Thumbnails

Which of the following is a spread sheet

MS Excel
MS Outlook
MS Power Point
MS word

What does the AVERAGE function calculate for a range of cells ?

Mean
Sum
Median
Mode

You can customize all of your documents properties in the

Preview Window
Options Menu
Page Layout tab
Backstage view

The default font for Microsoft word is

Times New Roman
Calibri
verdana
Helvetica

Which of the following terms refers to the ability of a computer to automatically configure a new hardware component that is added to it ?

Formatting
Multiprocessing
Multiprogramming
Plug and play

In Microsoft Power Point two kinds of sound effects files that can be added to the presentation are ?

Wav files and mid files
Wav files and gif files
Wav files and jpg files
jpg files and .gif files

In Microsoft PowerPoint to add a header or footer to your handout, you can use.

The title master
The handout master
The slide master
Text

What is the function of print manager?

Print queue
Print cancel
Print stop
All of these.

Changing to newer, usually more powerful or sophisticated versions of hardware components is termed

Expansion
Plug-and-play
Upgrading
Upsizing

Microsoft PowerPoint is a.

Database program
Spreadsheet program
Presentation program
Word processing program

Which of the following protocol is used to access web pages on World Wide Web?

TCP/IP
Gopher
HTTP
HTML

Drive access time is measured in——-

Nanoseconds
Milliseconds
Microseconds
Picoseconds

What is a web browser?

A program that can display a web page
A program used to view html documents
It enables user to access the resources of internet
All of these.

GUI stands’ for which oi: the following?

Graphic User Interface
Graphical User interface
Graphical User Interfaces
Graphs under Interplay

In MS Word shortcut key CTRL+W is used for?

Open the Print dialog box
Update the current Web page
Close the current window
None of these

A message with replies on a newsgroup is often called a—–

Post
List
Thread
Comment

A file which contains readymade styles that can be used for presentations is called?

Auto Style
Template
Wizard
Pre-formatting

1/0 is the shbrt term for:

Income/Outcome
Input/Ou tput
Inner/Outer
Incoming/Outgoing

Indentation is a?

Left margin
Right margin
Left space of paragraph
Top

What is defined by the handout master?

Slide formatting
Layout of audience handout notes
Handout content formatting for Microsoft word export
None of these.

To view Word field codes in your document, press:

Alt+F9
F4
Shift+V
Shift+F1

Use the—–button to reverse your iast change.

Undo
Cut
Redo
Paste

There are——bits in one byte.

In a laser printer, the——transfers the image to the paper.

Laser
Roller
Toner
Drum

What does HTML mean?

High Top Math Level
Hyper True Math Language
Hypertext Markup Language
Hyper Text Memory Language

Which of these arithmetic operators takes the highest precedence?

< (lesser than)
> (greater than)
/ (division)
(exponentiation)

There are two methods you can use to move text-cut and paste or:

Move and copy
Select and shift
Highlight and place
Drag and drop

Smallest unit of memory is :

Bit
Byte
Character
Word

You can modify alignment. line spacing. and paragraph spacing in the.

Layout menu
Paragraph dialog box
Format tab
Styles group

What is the filename extension for an Outlook data file?

RTF
PST
DAT
XLS\

The following are examples of data types EXCEPT.

Functions
Sound
Video
Text

In Microsoft Power Point the following Will not advance the slides in a slide show view:

The space bar
The mouse button
The enter key
Esc key

The inner core of an optical fiber is — in composition.

Glass or plastic
Copper
Bimetallic
Liqutd

The ______interface transmits one bit at a time.

Parallel
SCSI
Serial
Fire Wire

which alignment choice spreads the data across the width of the cell?

Center
–
ustify
Indent

The three parts of an if function are Separated by___

Dashes
Asterisks
Semicolons
Commas

Which of the following data types automatically generates a consecutive number?

Auto Number
Memo
Number
Text

What is shortcut to change the font?

Ctrl+F
Ait+Ctrl+F
Shift+Alt+F
Ctrl+Shift+F

What is the name for a webpage address?

Directory
Domain
URL
Protocol

Which of the following is fastest?

Hard Disk
Register
RAM
Cache

A word template stores common document :

Content
Structure
Style
Theme

Read More: All PPSC Computer Operator Past Paper MCQs for PPSC Test Preparation.

IMPORTANT: Computer MCQs and Computer MCQs Quizzes for more practice and preparation.

PPSC Junior Computer Operator Test Preparation MCQs

Leave a Comment Cancel reply