RAM is a....? Mcqs

RAM is a....?

(A) Volatile

(B) Temporary

(C) Primary Memory

(D) All of these

Source: This question is taken from the Assistant (BS-16) Provincial Disaster Management PPSC Past

Which of the following is not essential component to perform a mail merge operation:...?

(A) Main document

(B) Data source

(C) Merge fields

(D) Word fields

Source: This question is taken from the Clubbed Case Canal Patwari First Phase (Morning) 2023

Which one is the spreadsheet application that comes with MS Office software group:...?

(A) MS Word

(B) MS Excel

(C) MS PowerPoint

(D) MS Access

Source: This question is taken from the Clubbed Case Canal Patwari First Phase (Morning) 2023

Which option in Microsoft Excel will help you arrange, summarize and group large sets of data...?

(A) Illustrations

(B) Pivot table

(C) Sparkline

(D) Filter

Source: This question is taken from the Assistant director (Bs-17) local government & community development department PPSC 2024

When all the numbers between 0 and 100 in a range should be displayed in red color apply...?

(A) Use =if() function to format the required numbers red

(B) Apply Conditional Formatting command on Format menu

(C) Both

(D) None

Source: This question is taken from the Microsoft Excel MCQs

in a computer spreadsheet, SUM, AVERAGE, MIN and MAX are examples of...?

(A) calculation

(B) formulas

(C) functions

(D) relative addressing

Source: This question is taken from the Manager Auqaf BS 16 PPSC past papers solved

The most fundamental unit of information in digital system is:...?

(A) Bit

(B) Byte

(C) Kilo Byte

(D) Giga Byte

Source: This question is taken from the Inspector Cooperative Societies (Bs-14) Cooperatives Department Punjab Public Service Commission (PPSC) Club-104

Creating ga new email account is called:...?

(A) Signin

(B) Sign up

(C) sign out

(D) None of these

Source: This question is taken from the Assistant Sub Inspector Punjab Police 2021

Which of the following is the Second Step in Creating a Macro...?

(A) Using your mouse or keyboard, perform the task you want to automate

(B) Give the macro a name

(C) Assign a keyboard shortcut to the macro

(D) Start recording

Source: This question is taken from the Microsoft Word MCQs

What does the term "filter" refer to in Excel...?

(A) To permanently delete rows or columns

(B) To format the appearance of cells

(C) To temporarily hide certain data based on specific criteria

(D) To create a chart

Source: This question is taken from the Microsoft Excel MCQs

How can you sum up a range of cells in Excel...?

(A) Use the SUM function

(B) Use the AVERAGE function

(C) Use the COUNT function

(D) Use the MAX function

Source: This question is taken from the Microsoft Excel MCQs

Which of following function in Microsoft Excel is used to count items in a cell range...?

(A) Count

(B) SUM

(C) MAX

(D) Average

Source: This question is taken from the Microsoft Excel MCQs

Errors from computer hardware and software can be identified and removed by process:...?

(A) Interface

(B) Debugging

(C) Formatting

(D) Flip Flop

Source: This question is taken from the Assistant Director Intelligence BS-17 Punjab Police

Default name of a newly created MS Word File is ___________...?

(A) File1

(B) Document1

(C) untitled1

(D) None of these

Source: This question is taken from the Microsoft Word MCQs

In MS Excel if a numeric value start with ____ then this value can be treated as a table ...........?

(A) Hash

(B) Equal Sign

(C) Apostrophe

(D) Tide

Source: This question is taken from the Assistant Sub Inspector (ASI) Punjab Police Service Quota

Times New Roman is the example of...?

(A) Text

(B) Alignment

(C) Font

(D) Ruler

Source: This question is taken from the Assistant BS-16 & Junior Clerk BS-11 Agriculture Department

What is gutter margin in MS Word...?

(A) Margin that is added to the left margin when printing

(B) Margin that is added to right margin when printing

(C) Margin that is added to the binding side of page when printing

(D) Margin that is added to the outside of the page when printing

Source: This question is taken from the Naib Tehsildar General Knowledge PPSC Past Paper

The ______ project allows access to the universe of online information using two simple user interface operations...?

(A) World-wide web

(B) IP address

(C) Web browser

(D) None of these

Source: This question is taken from the Assistant Sub Inspector Punjab Police 2021

Silicon valley is famous for...?

(A) Computers

(B) Film Industry

(C) Cars

(D) Sugarcans

Source: This question is taken from the PMS General Knowledge Paper 2005

Starting with Microsoft Office 2003, Photo Editor was renamed to :...?

(A) Photo editor

(B) Photo manager

(C) Picture editor

(D) Picture manager

Source: This question is taken from the Microsoft Word MCQs

To remove the content of selected cells you must issue ___ commands...?

(A) Clear All

(B) Clear Delete

(C) Clear Contents

(D) All

Source: This question is taken from the Microsoft Excel MCQs

In the context of Microsoft Word, there is a feature called ‘Gutter Margin’. What is this feature used for...?

(A) Improve the clarity of graphics and images

(B) Give provision for better document binding

(C) Improve the clarity of the printed text

(D) Facilitate the insertion of page numbers

Source: This question is taken from the Microsoft Word MCQs

Times new roman, Arial etc are examples of...?

(A) Font style

(B) Web page

(C) Font

(D) Computers

Source: This question is taken from the Assistant director (Bs-17) local government & community development department PPSC 2024

Which of following action removes a sheet from workbook...?

(A) Select the sheet, then choose Edit > Delete Sheet

(B) Select the sheet then choose Format > Sheet > Hide

(C) Both

(D) None

Source: This question is taken from the Microsoft Excel MCQs

Which elements of a worksheet can be protected from accidental modification...?

(A) Scenarios

(B) Objects

(C) Contents

(D) All of the above

Source: This question is taken from the Microsoft Excel MCQs

The official name of Sukkur barrage is...?

(A) Kotri barrage

(B) Ghulam Muhammad Barrage

(C) Lloyd Barrage

(D) None of these

Source: This question is taken from the Tehsildar Past Paper PPSC Solved

What should you do if you require pasting the same format in many places...?

(A) Double click the format painter then go on pasting in many places

(B) Click the format painter then go on pasting to many places holding Ctrl Key

(C) Click the Format painter and go on pasting in many places holding Alt Key

(D) All of above

Source: This question is taken from the Microsoft Word MCQs

Area formula helps for performing________ calculations...?

(A) Multiple

(B) Composite

(C) Nested

(D) All of these

Source: This question is taken from the Intelligence Officer (Bs-14) Punjab Police, Special Branch Assistant (Bs-16) Cooperatives Department PPSC Past Paper 2024

Pressing the _____ key instructs Word to replace an AutoText entry name with the stored AutoText entry...?

(A) f1

(B) f2

(C) f3

(D) f4

Source: This question is taken from the Microsoft Word MCQs

Which of the following can be renamed...?

(A) Worksheet

(B) Workbook

(C) Both A and B

(D) None of these

Source: This question is taken from the Microsoft Excel MCQs

Which of following is not true regarding conditional formatting...?

(A) You can set condition to look for Bold and apply Italics on them

(B) You can add more than one condition to check

(C) You can apply Font, border and pattern formats that meets the specified conditions

(D) None of these

Source: This question is taken from the Microsoft Excel MCQs

which of these options in PowerPoint would allow us to carry any set of slides from a given computer to another one...?

(A) Web and Go

(B) pack and go

(C) save and go

(D) save as

Source: This question is taken from the Microsoft PowerPoint MCQs

What should be done after fixing a problem or installing a new application or making configuration in a computer...?

(A) Hibernate

(B) Restart

(C) Shutdown

(D) Sleep

Source: This question is taken from the District Zakat Officer BS-17 PPSC past papers

an optical disk is an electronic data storage medium that can be written to and read from using a ______ beam...?

(A) high-powered laser

(B) low-powered laser

(C) medium-powered laser

(D) None of these

Source: This question is taken from the District Zakat Officer BS-17 PPSC past papers

The "Draft" option appears in which menu...?

(A) page layout

(B) insert

(C) view

(D) none

Source: This question is taken from the Microsoft Word MCQs

Which one is example of spreadsheet software...?

(A) MS WORD

(B) MS EXCEL

(C) MS POWERPOINT

(D) None of these

Source: This question is taken from the Microsoft Excel MCQs

Ms Access arranges the data in :...?

(A) Rows

(B) Tables

(C) word

(D) None

Source: This question is taken from the Assistant Sub Inspector (ASI) Punjab Police Past Paper 2021

ROM stores data:...?

(A) Permanently

(B) Temporarily

(C) Partially

(D) Fully

Source: This question is taken from the Data Entry Operator BS-14 Lahore High Court 2022

Which shortcut key is for auto sum ...?

(A) Alt + =

(B) Ctrl + Shift

(C) Alt + F1

(D) Ctrl + =

Source: This question is taken from the Microsoft Excel MCQs

_______is widely used for transmitting streaming videos data on the internet...?

(A) AVI

(B) MP3

(C) MVA

(D) Animation Scheme

Source: This question is taken from the Junior Clerk Service and General Administration (S&GAD)

DOS cannot retrieve any data from a disk if a computer virus corrupts its:...?

(A) Directory Area

(B) Data Area

(C) BAT Files

(D) None of these

Source: This question is taken from the Data Entry Operator in the Punjab Police 2020

Microsoft Office is an example of a...?

(A) vertical market software

(B) Closed source software

(C) Open source software

(D) Horizontal market software

In MS PowerPoint presentations, MR. Ali has to design and regulate the layout and formatting of the slide. These are commonly known as:...?

(A) Blueprint

(B) placeholder

(C) templates

(D) design plates

Source: This question is taken from the Microsoft PowerPoint MCQs

Which of the following is not a term pertaining to spreadsheets...?

(A) cell

(B) character

(C) browser

(D) formula

Source: This question is taken from the Microsoft Excel MCQs

The only difference between memory and storage is:...?

(A) Slow, Fast

(B) Temporary, Permanent

(C) Permanent, Temporary

(D) None of these

Source: This question is taken from the PMS General Knowledge Past Paper

In a computer spreadsheet, function which is used to count numbers of entries in given range is called __________ ...?

(A) Length

(B) Counter

(C) Count

(D) None of These

Source: This question is taken from the Microsoft Excel MCQs

In MS Word, when we apply Drop Cap on a word then, by default, first character of this word drops to:...?

(A) 3 lines

(B) 5 lines

(C) 2 lines

(D) 8 lines

Source: This question is taken from the Assistant Sub Inspector (ASI) Punjab Police Service Quota

A numeric value can be treated as label value if ___precedes it...?

(A) Apostrophe

(B) Hash

(C) Exclamation

(D) All

Source: This question is taken from the Microsoft Excel MCQs

Which file stored in computer that perform functions quickly while browsing:...?

(A) Cache

(B) Exe

(C) Cookies

(D) None of these

Source: This question is taken from the Assistant BS-16 Special Education Department

switching between portrait and landscape modes involves the__________...?

(A) header and footer toolbar

(B) print layout view

(C) page setup dialog box

(D) none of the above

Source: This question is taken from the Microsoft Word MCQs

Select the example of connectivity?...?

(A) Floppy Disk

(B) Internet

(C) Data

(D) Power card

Source: This question is taken from the Data Entry Operator BS-14 Lahore High Court 2022

Portrait and Landscape are present under which command:...?

(A) Page Layout

(B) Home

(C) References

(D) Review

Source: This question is taken from the Inspector Cooperative Societies (Bs-14) Cooperatives Department Punjab Public Service Commission (PPSC) Club-104

Which of the following is the second largest measurement of RAM?...?

(A) Megabyte

(B) Gigabyte

(C) Byte

(D) Terabyte

Source: This question is taken from the Data Entry Operator BS-14 Lahore High Court 2022

Main window in a computer spreadsheet is called:...?

(A) Workbook

(B) Work

(C) Account book

(D) Worksheet

Source: This question is taken from the Clubbed Case Canal Patwari First Phase (Morning) 2023

Arrangement of data in a logical sequence is known as:...?

(A) Sorting

(B) Classifying

(C) Reproducing

(D) Summerizing

Source: This question is taken from the Data Entry Operator in the Punjab Police 2020

What type of chart will you use to compare performance of sales of two products ...?

(A) Pie Chart

(B) Line Chart

(C) Column Chart

(D) None

Source: This question is taken from the Microsoft Excel MCQs

In MS Word, you can use ________ for consistent document formatting....?

(A) Character and Paragraph styles

(B) SmartArt

(C) Page Margin

(D) None of these

Source: This question is taken from the Microsoft Word MCQs

What is the symbol for the "not equal to" operator in Excel...?

(A) !=

(B) ~=

(C) <>

(D) None of these

Source: This question is taken from the Microsoft Excel MCQs

Printer is an example of, that related to...?

(A) Output device

(B) Input device

(C) Photocopy

(D) None of these

Source: This question is taken from the Tehsildar Past Paper PPSC Solved

Which of the following is the feature that keeps track of the right margin...?

(A) Find and Replace

(B) Word-wrap

(C) Right justified

(D) Left justified

Source: This question is taken from the Junior Computer Operator (Bs-12) Transport And Mass Transit Department, Irrigation Department PPSC 2024

Enable drawing text in an MS Word document...?

(A) Word art

(B) macros

(C) templates

(D) none of these

Source: This question is taken from the Microsoft Word MCQs

By selecting paragraph we can apply:...?

(A) Line spacing

(B) Indent

(C) Both A and B

(D) None of these

Source: This question is taken from the Junior Clerk Board of Revenue, Punjab-2023 43j2022

The default alignment for paragraph is...?

(A) Left

(B) Right

(C) Center

(D) None of these

Source: This question is taken from the Assistant BS-16 & Junior Clerk BS-11 Agriculture Department

In a computer spreadsheet, each cell contain a __________ ...?

(A) label

(B) Value

(C) Formula

(D) All of these

Source: This question is taken from the Microsoft Excel MCQs

Arithmetic Operations are performed by:...?

(A) LU

(B) AU

(C) ALU

(D) CU

Source: This question is taken from the Data Entry Operator BS-14 Lahore High Court 2022

A part of a word that can be pronounced separately...?

(A) Letter

(B) Sibilant

(C) Particle

(D) Syllable

Source: This question is taken from the Assistant Sub Inspector (ASI) Punjab Police Past Paper 2021

In MS Excel, to clear all content, Formats and comments in selected cell, we use...?

(A) Clean All

(B) Clear All

(C) Clean Content

(D) Clean Format

Source: This question is taken from the Microsoft Excel MCQs

In computer disk storage is a sub division on a magnetic disk or optical disk called_________...?

(A) Track

(B) ROM

(C) Sector

(D) None of these

Source: This question is taken from the Assistant/Head Clerk (Bs-16) Livestock & Dairy Development

in a computer spreadsheet, SUM, AVERAGE, MIN and MAX are examples of...?

(A) calculation

(B) formulas

(C) functions

(D) relative addressing

Source: This question is taken from the Microsoft Excel MCQs

Statue is to sculptor and symphony is to________...?

(A) Composer

(B) Pen

(C) Chisel

(D) Canvas

Source: This question is taken from the Inspector Cooperative Societies (Bs-14) Cooperatives Department Punjab Public Service Commission (PPSC) Club-104

Microprocessors was introduced in which generation of computer...?

(A) Second Generation

(B) Fourth Generation

(C) Third Generation

(D) Both (A) and (B)

Source: This question is taken from the Microsoft Excel MCQs

What is a terabyte...?

(A) An optical storage medium capable of storing vast amounts of information

(B) A multifunctional operating environment

(C) Flash memory

(D) Roughly a trillion bytes

Source: This question is taken from the Sub Inspector Punjab Police Open Marit

Cyber warfare means:...?

(A) Installing spyware

(B) Destroying the infrastructure

(C) Use of Technology to attack and harm to actual warfare

(D) All of these

Source: This question is taken from the Labour Officer/Assistant (Bs-16), Labour Inspector (Bs-14), Junior Patrol Officer (Bs-11), Punjab Ring Road Authority, C&W PPSC Evening Time

The term DNS stands for:...?

(A) Domain Name system

(B) Defence Nuclear system

(C) Downloadable New Software

(D) Dependent Name Server

Source: This question is taken from the Assistant Director Labour Welfare Bs-17 HR Department

____ includes superscript, subscript, outline , emboss , engrave...?

(A) Word art

(B) Text effects

(C) font effects

(D) none

Source: This question is taken from the Punjab Police Sub Inspector (SI) Service Quota PPSC Past

in Ms PowerPoint Which option allows you to select line, curve, freeform or scribble tools...?

(A) Create effect

(B) Insert motion path

(C) Draw custom path

(D) All of the above

Source: This question is taken from the Microsoft PowerPoint MCQs

In MS Excel Ready-made templates are available under-tab...?

(A) File

(B) Insert

(C) Design

(D) None of these

Source: This question is taken from the Canal Patwari (BS-11) Irrigation ppsc past papers

Excel is a program that is used to prepare a ______...?

(A) Spreadsheet

(B) Database

(C) Workbook

(D) None of these

Source: This question is taken from the Microsoft Excel MCQs

Suppose there is a text in a document that is Bold, Red in color with Green background we want to of these formatting to another paragraph in one go, which option will we use:...?

(A) Format Button

(B) Format Menu

(C) Format Painter

(D) Format Macro

Source: This question is taken from the Clubbed Case Canal Patwari First Phase (Morning) 2023

In MS Excel, which of the following functions can be used to remove all spaces from a text string except for single spaces between words...?

(A) TRIM

(B) SUBSTITUTE

(C) CLEAN

(D) REPT

Source: This question is taken from the Microsoft Excel MCQs

Trackball is an:...?

(A) Storage device

(B) Output device

(C) Input device

(D) Programming language

Source: This question is taken from the Sub Inspector Punjab Police Open Marit

What is the shortcut key for a double line spacing...?

(A) Ctrl + 2

(B) Ctrl + 3

(C) Ctrl + 1

(D) None

Source: This question is taken from the Microsoft Word MCQs

The name box on to the left of formula bar...?

(A) Shows the name of worksheet currently working on

(B) Shows the name of cell or range currently working on

(C) Shows the name of workbook currently working on

(D) none

Source: This question is taken from the Microsoft Excel MCQs

In Excel, which is used to perform what if analysis ...?

(A) Goal seek

(B) Solver

(C) Scenario Manager

(D) All of above

Source: This question is taken from the Punjab Police Sub Inspector (SI) Service Quota PPSC Past

What does the term “filter” refer to in Excel...?

(A) To permanently delete rows or columns

(B) To format the appearance of cells

(C) To temporarily hide certain data based on specific criteria

(D) To create a chart

Source: This question is taken from the Microsoft Excel MCQs

Which of the following symbol sets would be most likely to contain a mathematical symbol such as a degree sign, greater than or equal to, or a Greek letter...?

(A) Symbol

(B) Wingdings

(C) Webdings

(D) None of the above

Source: This question is taken from the Microsoft Word MCQs

which of the following controls the process of interaction between the user and the operating system...?

(A) user interface

(B) platform

(C) screensaver

(D) none of these

Source: This question is taken from the District Zakat Officer BS-17 PPSC past papers

Normally, a spreadsheet contains...?

(A) Documents

(B) rows

(C) rows and columns

(D) None of these

Source: This question is taken from the Microsoft Excel MCQs

Which is correct form of Cell range in MS Excel:...?

(A) A1-B1

(B) A1:A10

(C) A1 to A10

(D) A1-A10

Source: This question is taken from the Administrative Officer (Bs-17), Administrator (Bs-16), Media Monitoring Officer (Bs-16), Information Officer (Bs-17), Estate Officer (Bs-16) 2024

To access a mainframe or supercomputer, users often use a:...?

(A) Terminal

(B) Node

(C) Desktop

(D) Handheld

Source: This question is taken from the Inspector Cooperative Societies (Bs-14) Cooperatives Department Punjab Public Service Commission (PPSC) Club-104

Silicon Valley is famous for ______...?

(A) Film Industry

(B) Rare birds

(C) Cars

(D) Computers

Source: This question is taken from the PMS General Knowledge PPSC Past Paper 2024

How much free storage does Google Drive offer...?

(A) 10 GB

(B) 15 GB

(C) 20 GB

(D) None of these

Source: This question is taken from the Tehsildar Past Paper PPSC Solved

Changing the appearance of a document is called___________...?

(A) Proofing

(B) Editing

(C) Formatting

(D) All of above

Source: This question is taken from the Microsoft Word MCQs

Which the following term does not pertain to Excel...?

(A) Browser

(B) Columns

(C) Work Book

(D) None of these

Source: This question is taken from the Microsoft Excel MCQs

When two people collaborate on an online document at the same time, they are collaborating...?

(A) In CloudEdit

(B) By Tracking

(C) Synchronously

(D) Independently

Source: This question is taken from the Data Entry Operator in the Punjab Police 2020

After creating the table, which of the following is correct:...?

(A) Fields cannot be added

(B) Fields cannot be deleted

(C) Fields can added but only once

(D) Fields can be added and deleted as needed

Source: This question is taken from the Deputy Controller (BS-18) BISE Rawalpindi PPSC Past paper

What is the shortcut key for “Increase Font Size” the selected text ...?

(A) Ctrl + Shift + <

(B) Ctrl + Shift + >

(C) Ctrl + I

(D) None of these

Source: This question is taken from the Microsoft Word MCQs

in a computer spreadsheet block of numbers is called-------...?

(A) workbook

(B) columns

(C) rows

(D) range

Source: This question is taken from the Microsoft Excel MCQs

When a peripheral device needs immediate attention from the operating system, it generates a...?

(A) Spool

(B) Interrupt

(C) Stack

(D) Page file

Source: This question is taken from the Assistant (bs-16) various departments Clubbed Case-74-2024 PPSC Past Paper (Morning)

Whereas a computer mouse moves over the table surface, the trackball is...?

(A) Stationary

(B) Difficult to move

(C) Dragged

(D) Moved in small steps

Source: This question is taken from the Labour Officer/Assistant (Bs-16), Labour Inspector (Bs-14), Junior Patrol Officer (Bs-11), Punjab Ring Road Authority, C&W PPSC Evening Time

Main window in a computer spreadsheet is called ___________ ...?

(A) Work book

(B) Work

(C) Account book

(D) Work sheet

Source: This question is taken from the Microsoft Excel MCQs

In Excel, Conditional formatting is in: ______________...?

(A) Insert Tab

(B) Page layout

(C) View Tab

(D) Home Tab

Source: This question is taken from the Microsoft Excel MCQs

Which menu do you choose to create footer in Office 365...?

(A) format, header and footer

(B) view, footer

(C) insert, header and footer

(D) view, header and footer

Source: This question is taken from the Microsoft Word MCQs

What is the shortcut key for paragraph break...?

(A) Ctrl+Enter

(B) Shift+Enter

(C) Ctrl+Shift+Enter

(D) Alt+Enter

Source: This question is taken from the Junior Computer Operator (Bs-12) Transport And Mass Transit Department, Irrigation Department PPSC 2024

Which type of file is created by word processing programs...?

(A) Database file

(B) Worksheet file

(C) Graphic file

(D) Document file

Source: This question is taken from the Junior Clerk Deputy Commissioner Office BOR

Which one can be used for creating a document _______________________...?

(A) MS Excel

(B) MS Word

(C) MS Access

(D) None

Source: This question is taken from the Microsoft Word MCQs

Which operation you will perform if you need to move a block of text...?

(A) Copy and Paste

(B) Paste and Cut

(C) Cut and Paste

(D) Paste and Delete

Source: This question is taken from the Microsoft Word MCQs

Which among following is not associated with spelling dialogue box...?

(A) Edit

(B) Ignore All

(C) Ignore

(D) Change

Source: This question is taken from the Microsoft Excel MCQs

Which application is used for accessing the Internet:...?

(A) Operating system

(B) Customized software

(C) System software

(D) Browser

Source: This question is taken from the Junior Clerk Deputy Commissioner Office BOR

In Microsoft Excel, the file you create and edit is called:...?

(A) A form

(B) A ledger

(C) A table

(D) A workbook

Source: This question is taken from the Assistant Sub Inspector (ASI) Anti-Corruption Punjab Police

Programs stored in ROM are called:...?

(A) Fireware

(B) Formware

(C) None of these

(D) Firmware

Source: This question is taken from the Data Entry Operator BS-14 Lahore High Court 2022

Word has web authoring tools allow you to incorporate ___ on Web pages....?

(A) Bullets

(B) Hyperlinks

(C) Sounds

(D) All of these

Source: This question is taken from the Microsoft Word MCQs

What type of chart will you use to compare performance of two employees in the year 2021...?

(A) Column Chart

(B) Line Chart

(C) Pie Chart

(D) Dot Chart

Source: This question is taken from the Microsoft Excel MCQs

Which of the following file types represents a compressed version of one or more files...?

(A) EXE

(B) PDF

(C) DOC

(D) ZIP

Source: This question is taken from the Lecturer Islamiat Special Education Department, Punjab (Bs-17) 2024

An application program that allows a user to set page number and spell check of adocument is known as:...?

(A) Notepad application

(B) Word Pad

(C) Email application

(D) Word Processor

Source: This question is taken from the Clubbed Case Canal Patwari First Phase (Morning) 2023

Where is the quick Access Toolbar and when should you use it...?

(A) upper-left corner and use it for your favorite commands

(B) floats over your text and use it when you need to make formatting changes

(C) Home tab and use it when you need to quickly launch or start new document

(D) None of above

Source: This question is taken from the Microsoft Word MCQs

Which of the following is a graphic change format extension...?

(A) GIF

(B) JPEG

(C) MPG

(D) All of these

Source: This question is taken from the Excise And Taxation Inspector & Narcotics Control (Bs-16)

In a database table, the category of information is called __________...?

(A) Tuple

(B) Field

(C) Record

(D) All of above

Source: This question is taken from the Microsoft Excel MCQs

Which feature is used to wrap extra-long text into multiple lines in MS Excel ...?

(A) wrap text

(B) text wrap

(C) letter warp

(D) word wrap

Source: This question is taken from the Microsoft Excel MCQs

Which of the following is not essential component to perform a mail merge operation...?

(A) Word fields

(B) Main document

(C) Data source

(D) Merge fields

Source: This question is taken from the Corporal (Bs-11) Counter Terrorism Department, Punjab Police PPSC Past Paper 11-08-2024

How can you create a uniform appearance by adding a background image to all slides...?

(A) Create a template

(B) Edit the slide master

(C) Use the autocorrect wizard

(D) All of the above

Source: This question is taken from the Microsoft PowerPoint MCQs

Where can you change automatic or manual collection mode in Excel ...?

(A) Double CAL indicator on status bar

(B) Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button

(C) both

(D) none

Source: This question is taken from the Microsoft Excel MCQs

Which of the following can be used to divide a web page into Areas...?

(A) frames

(B) theme

(C) table of contents

(D) none of the above

Source: This question is taken from the Microsoft Word MCQs

You want to insert a paragraph of text from one document into another document while still keeping it in the first document, you will do it bydoing the following;...?

(A) Cut and paste

(B) Copy and paste

(C) Delete and paste

(D) Insert and paste

Source: This question is taken from the Assistant Sub Inspector in the Punjab Police Department

In which software is a CV typically created...?

(A) Microsoft Word

(B) Adobe Photoshop

(C) Google Chrome

(D) VLC Media Player

Source: This question is taken from the Microsoft Word MCQs

How are data organized in a spreadsheet ...?

(A) Lines and spaces

(B) Layers and planes

(C) Rows and columns

(D) Height and width

Source: This question is taken from the Microsoft Excel MCQs

Paint programs keep track of every _____ placed on the screen...?

(A) Image

(B) Object

(C) Pixel

(D) Color

Source: This question is taken from the Data Entry Operator in the Punjab Police 2020

Which simplifies the process of formatting text if the same formatting is required in more than one location...?

(A) Auto Text

(B) Format Painter

(C) Font dialog box

(D) None of the above

Source: This question is taken from the Microsoft Word MCQs

In MS Excel, a formula that looks for a value in the leftmost column of a table and then returns a value in the same row for a specific column is called:...?

(A) Horizontal Lookup

(B) Vertical Lookup

(C) Average

(D) None of these

Source: This question is taken from the Assistant Sub Inspector (ASI) Punjab Police Past Paper 2021

Which file format can be added to a Power Point show...?

(A) .gif

(B) .jpg

(C) .wav

(D) All of these

Source: This question is taken from the Sub Inspector BS 14 (open Marit) 2016

The process of putting data into a storage location is called...?

(A) Reading

(B) Writing

(C) Controlling

(D) None of these

Source: This question is taken from the Punjab Police Sub Inspector Service Quota PPSC Past Paper

Which feature starts a new line whenever a word or sentence reached a border...?

(A) Text Line

(B) New Line

(C) Text Wrapping

(D) Text Align

Source: This question is taken from the Microsoft Word MCQs

In Microsoft Window 7,_______ can give you information about weather...?

(A) File

(B) Gadgets

(C) Windows explorer

(D) None of these

Source: This question is taken from the Junior Clerk Service and General Administration (S&GAD)

Which of the following functions is used to calculate the average of a range of cells in Excel...?

(A) AVERAGE

(B) SUM

(C) COUNT

(D) None of these

Source: This question is taken from the Microsoft Excel MCQs

Physical or logical arrangement of network is _____...?

(A) Topology

(B) Routing

(C) Networking

(D) None of these

Source: This question is taken from the Junior Computer Operator PPSC Past Paper 2024

Which feature helps you to inserts the contents of the Clipboard as text without any formatting in MS Word...?

(A) Paste special

(B) Format Painter

(C) Page setup

(D) Styles

Source: This question is taken from the Junior Computer Operator (Bs-12) Transport And Mass Transit Department, Irrigation Department PPSC 2024

How to duplicate values in cell range in Excel 2016...?

(A) Click the conditional formatting button in the styles group of the theme

(B) Select the range of cell in the work sheet

(C) Both A and B

(D) None of these

Source: This question is taken from the Microsoft Excel MCQs

What is the storage capacity of a CD ROM...?

(A) 500 MB

(B) 680 MB

(C) 800 MB

(D) 1000 MB

Source: This question is taken from the Lecturer Political Science Punjab Higher Education Department (Bs-17) 2022

Which of the following is not essential component to perform a mail merge operation...?

(A) Word fields

(B) Main document

(C) Data source

(D) Merge fields

Source: This question is taken from the Microsoft Word MCQs

Which is not the function of the operating system...?

(A) Linux

(B) DOS

(C) Oracle

(D) Window

Source: This question is taken from the Junior Computer Operator PPSC Past Paper 2024

The arrangement of elements such as Title, Subtitle text, picture, tables etc....?

(A) layout

(B) presentation

(C) design

(D) scheme

Source: This question is taken from the Microsoft Excel MCQs

What category of functions is used in this formula = PMT (C10/12, CB, C9, 1)...?

(A) Logical

(B) Payment

(C) Financial

(D) None of these

Source: This question is taken from the Microsoft Excel MCQs

In MS Excel, You can copy data or formulas _____...?

(A) With buttons on the standard toolbars

(B) With commands on the shortcut menu

(C) With the copy, paste and cut commands on the edit menu

(D) All of the above

Source: This question is taken from the Microsoft Excel MCQs

A numeric value can be treated as label value if it is precedes with...?

(A) Apostrophe

(B) Exclamation

(C) Hash

(D) Ampersand

Source: This question is taken from the Microsoft Excel MCQs

What is the term used when a clip art image changes the direction of faces...?

(A) Group

(B) Flip

(C) Rotate

(D) All of the above

Source: This question is taken from the Microsoft PowerPoint MCQs

A network tha coves large area, City , County and beyond is called....?

(A) LAN

(B) WAN

(C) Router

(D) Bridge

Source: This question is taken from the SUB Inspector In Punjab Police Department (BSP 14) 2017

Who was the founder of C programming language...?

(A) Dennis Ritchie

(B) Billgates

(C) Bjarne Stroustrup

(D) James A. Gosling

Source: This question is taken from the Assistant Punjab Police PPSC Past Paper 2024

The _________ indents all the lines of a paragraph except first line in Ms Word....?

(A) First Line Indent Marker

(B) Hanging Indent Marker

(C) Left Indent Marker

(D) Right Indent Marker

Source: This question is taken from the Microsoft Word MCQs

In Windows Operating System ____________ known as a File Manager...?

(A) Windows Explorer

(B) MS Word

(C) MS Excel

(D) Device Driver

Source: This question is taken from the Junior Clerk Service and General Administration (S&GAD)

Which key deletes the character to the right of the cursor in MS Word:...?

(A) Delete

(B) Backspace

(C) End

(D) None of thee

Source: This question is taken from the Junior Clerk Board of Revenue, Punjab-2023 43j2022

In MS Excel, if you want to reference a cell in the same column but a different row on another sheet, what type of...?

(A) Absolute refrence

(B) Relative reference

(C) mixed reference

(D) circular reference

Source: This question is taken from the Canal Patwari (BS-11) Irrigation ppsc past papers

Which command is used to generate a series of data directly from the values of the selected cells:...?

(A) Auto Fill

(B) Fill

(C) Range Fill

(D) Row Fill

Source: This question is taken from the Clubbed Case Canal Patwari First Phase (Morning) 2023

In MS Excel to add two cells (A1 and A2) togather you use the following formula...?

(A) = add(A1+A2)

(B) = A1+A2

(C) = together A1:A2

(D) None of these

Source: This question is taken from the Microsoft Excel MCQs

Which of these terms do we use when an image in a clip art changes the direction that it was originally facing?...?

(A) Mirror

(B) Rotate

(C) Flip

(D) Group

Source: This question is taken from the Data Entry Operator BS-14 Lahore High Court 2022

In MS-Word. Header & Footer are inserted in:...?

(A) Front Page

(B) Last Page

(C) On Every Page

(D) None of these

Source: This question is taken from the OFFICE ASSISTANT (BS-16) Housing Urban Development

The column heading in the spreadsheet are identified by _________...?

(A) Alphabets

(B) Numbers

(C) Symbels

(D) None of these

Source: This question is taken from the Microsoft Excel MCQs

What do you mean by vertical separation between columns:...?

(A) Orientation

(B) Gutter

(C) Margin

(D) Index

Source: This question is taken from the Junior Computer Operator (Bs-12) Transport And Mass Transit Department, Irrigation Department PPSC 2024

In MS Word a character that is raised and is smaller above the baseline is called...?

(A) Outline

(B) Superscript

(C) Raised

(D) Subscript

Source: This question is taken from the Junior Clerk Board of Revenue, Punjab-2023 43j2022

Which of the following is an example of spreadsheet application service...?

(A) Microsoft Excel

(B) Microsoft Word

(C) Microsoft PowerPoint

(D) None of these

Source: This question is taken from the Microsoft Excel MCQs

In a computer spreadsheet, each cell contains a...?

(A) Label

(B) value

(C) formula

(D) *All of these*

Source: This question is taken from the Microsoft Excel MCQs

In Excel, which is used to perform what if analysis...?

(A) Goal seek

(B) Solver

(C) Scenario Manager

(D) All of above

Source: This question is taken from the Microsoft Excel MCQs

To select all of the boxes of an organization chart in Ms PowerPoint...?

(A) Clicking and edit and select all

(B) Right click the chart background and then click select all

(C) Press and hgold the SHIFT key and click each box

(D) All of above

Source: This question is taken from the Microsoft PowerPoint MCQs

Which of the following keystroke update a bibliography field...?

(A) F9

(B) F3

(C) F5

(D) None of these

Source: This question is taken from the Microsoft Word MCQs

A placeholder that is applied in a document so that user will continue from that point next time is called:...?

(A) Hyperlink

(B) Cross reference

(C) Bookmark

(D) Reference

Source: This question is taken from the Clubbed Case Canal Patwari First Phase (Morning) 2023

What is a motion path in Powerpoint...?

(A) A type of animation entrance effect

(B) A method of advancing slides

(C) A method of moving items on a slide

(D) All of the above

Source: This question is taken from the Microsoft PowerPoint MCQs

The _________, or typeface, defines the appearance and shape of letters, numbers, and special characters in Word Document....?

(A) font

(B) font size

(C) point

(D) paragraph formatting

Source: This question is taken from the Microsoft Word MCQs

Which menu do you choose to create header in Office 365...?

(A) format, header and footer

(B) view, header

(C) insert, header and footer

(D) view, header and footer

Source: This question is taken from the Microsoft Word MCQs

Another name for a pre programmed formula in excel is ___...?

(A) Cell

(B) Graph

(C) Function

(D) Range

Source: This question is taken from the Microsoft Excel MCQs

Which of the following is associated with Excel program...?

(A) Graphic program

(B) Word Processor

(C) Presentation

(D) Spreadsheet

Source: This question is taken from the Sub Inspector BS 14 (open Marit) 2016

How can you apply exactly the same formatting you did to another text in Ms Word...?

(A) Copy the text and click on Paste Special tool on new place

(B) Select the text then click on Format Painter and select the new text

(C) Copy the text and paste in new location. Then type the new text again

(D) All of above

Source: This question is taken from the Microsoft Word MCQs

Which enables us to send the same letter to different persons...?

(A) Status bar

(B) Tool bar

(C) Menu bar

(D) Title bar

Source: This question is taken from the Microsoft Word MCQs

To change margin settings in Word 2016, click ________ on the menu bar and then point to the Page Margins....?

(A) File

(B) Layout

(C) Format

(D) Tools

Source: This question is taken from the Microsoft Word MCQs

Which generation computers used transistors...?

(A) First generation

(B) Second generation

(C) Third generation

(D) Fourth generation

Source: This question is taken from the Data Entry Operator in the Punjab Police 2020

The founder of Amazon is:...?

(A) Jeff Bezos

(B) Paul Allen

(C) Steve Ballmer

(D) None of these

Source: This question is taken from the OFFICE ASSISTANT (BS-16) Housing Urban Development

The Movement of an object is created by using...?

(A) Animation

(B) Motion

(C) Slide Layout

(D) Presentation

Source: This question is taken from the Microsoft PowerPoint MCQs

In MS Word. "Delete" key delete letters from the side of curser...?

(A) Right

(B) Up

(C) Down

(D) Left

Source: This question is taken from the Data Entry Operator in the Punjab Police 2020

Spreadsheet is also known as ____...?

(A) Document

(B) Workbook

(C) Presentation

(D) None of these

Source: This question is taken from the Junior Computer Operator PPSC Past Paper 2024

Material consisting of text and numbers is best presented as_____________...?

(A) A table slide

(B) A bullet slide

(C) A title slide

(D) All of above

Source: This question is taken from the Microsoft PowerPoint MCQs

Which of the following increases the rate of a chemical reaction...?

(A) Catalyst

(B) Inhibitor

(C) Reactant

(D) None of these

Source: This question is taken from the Tehsildar Past Paper PPSC Solved

Block arrows, stars and banners, and callouts are all examples of_______________...?

(A) Different types of children’s building blocks

(B) Auto Shape categories

(C) Clip art categories located in the Microsoft Clip Gallery

(D) More technical terms that I don’t understand

Source: This question is taken from the Microsoft PowerPoint MCQs

When Word flags a possible spelling or grammar error, it also changes the mark on the Spelling and Grammar Status icon to a ___________....?

(A) green X

(B) green check mark

(C) red X

(D) red check mark

Source: This question is taken from the Microsoft Word MCQs

The shortcut keys for the _________ character formatting are Ctrl+ Shift+ Plus sign...?

(A) case of letters

(B) underline words, not spaces

(C) superscript

(D) all capital letters

Source: This question is taken from the Microsoft Word MCQs

MS PowerPoint is example of _____...?

(A) Multimedia software

(B) Application software

(C) Entertainment software

(D) All above mentioned

Source: This question is taken from the Assistant Sub Inspector (ASI) Punjab Police Service Quota

Computer is better performance than mechanical calculator due to:...?

(A) Speed

(B) Versatility

(C) Storage

(D) Accuracy

Source: This question is taken from the Assistant Director BS-17 Home Department

Which one is the spreadsheet application that comes with MS Office software group...?

(A) MS Word

(B) MS Excel

(C) MS PowerPoint

(D) MS Access

Source: This question is taken from the Microsoft Word MCQs

Which PowerPoint view works best for adding slide transitions ________ ...?

(A) Slide view

(B) Slide show view

(C) Notes view

(D) Slide sorter view

Source: This question is taken from the Microsoft PowerPoint MCQs

Which shortcut key key is used to start a presentation from the beginning in PowerPoint...?

(A) F1

(B) F5

(C) F4

(D) None of these

Source: This question is taken from the Microsoft PowerPoint MCQs

Manual line break shortcut key in MS Word...?

(A) Ctrl+ Enter

(B) Shift+ Enter

(C) Alt + Enter

(D) Enter

Source: This question is taken from the Canal Patwari (BS-11) Irrigation ppsc past papers

From the following who invented Slide Rules...?

(A) John Napier

(B) Gottfried Leibnitz

(C) William Oughtred

(D) Blaise Pascal

Source: This question is taken from the Microsoft PowerPoint MCQs

In PowerPoint which shortcut key is used to open the transitions tab...?

(A) Alt+K

(B) Ctrl+C

(C) Ctrl+X

(D) Ctrl+W

Source: This question is taken from the Microsoft PowerPoint MCQs

____ is used for motions to slides in slide show....?

(A) Animation scheme

(B) Slide transition

(C) word art

(D) none

Source: This question is taken from the Assistant Service and General Administration (S&GAD) Paper

Excel is a program that is used to prepare a...?

(A) Database

(B) Text Document

(C) Spreadsheet

(D) Workbook

Source: This question is taken from the Junior Clerk Board of Revenue, Punjab-2023 43j2022

Which of the following is an example for automatic text formatting:...?

(A) Underlining hyperlink

(B) Adjusting extra space

(C) Replacing two -'s with an em hyphens

(D) All of these

Source: This question is taken from the Junior Computer Operator (Bs-12) Transport And Mass Transit Department, Irrigation Department PPSC 2024

A light sensitive device that converts drawing, printed text or other images into digital form is called...?

(A) Keyboard

(B) Scanner

(C) OMR

(D) None of the above

Source: This question is taken from the Punjab Police Sub Inspector Service Quota PPSC Past Paper

To create table of columns and rows for statistical or mathematical calculations using spreadsheet, which software is used...?

(A) Excel

(B) Word Pad

(C) Word Perfect

(D) Corel Draw

Source: This question is taken from the Assistant Punjab Police Department PPSC Past Paper

in Microsoft Word the Text boundary can be displayed or hidden from...?

(A) Customize from Tools menu

(B) Auto text option from Insert menu

(C) Options from Tools menu

(D) All of above

Source: This question is taken from the Microsoft Word MCQs

what is ............ is the process of dividing the disk into tracks and sectors...?

(A) Crashing

(B) Allotting

(C) Formatting

(D) Tracking

The options Portrait and Landscape comes under:...?

(A) Paper size

(B) Page Orientation

(C) Page Layout

(D) Page Row

Source: This question is taken from the Clubbed Case Canal Patwari First Phase (Morning) 2023

Which shortcut key is used to create chart in MS Excel...?

(A) F10

(B) F12

(C) F11

(D) None

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Key Tip

(B) Screen Tip

(C) Chart Tip

(D) Chart Key

Source: This question is taken from the Microsoft PowerPoint MCQs

In Excel which key is used for format number in currency format...?

(A) Ctrl+Shift+1

(B) Ctrl+Shift+4

(C) Ctrl+1

(D) Shift+1

Source: This question is taken from the Microsoft Excel MCQs

Small squares, called _________, on the selection rectangle that surrounds a graphic can be used to change the dimensions of the graphics in Ms Word....?

(A) scroll boxes

(B) sizing handles

(C) status indicators

(D) move handles

Source: This question is taken from the Microsoft Word MCQs

Which of the following is not an element of a computer spreadsheet interface?...?

(A) Pencil work

(B) Active cell

(C) Menu bar

(D) Workbook

Source: This question is taken from the Data Entry Operator BS-14 Lahore High Court 2022

What is the shortcut key to "Center Align" selected text?...?

(A) Ctrl+E

(B) Ctrl+U

(C) Ctrl+1

(D) Ctrl+T

Source: This question is taken from the Assistant BS-16 & Junior Clerk BS-11 Agriculture Department

In MS Excel, by pressing Shift and Space keys at a time from the keyboard you can select...?

(A) Two adjacent columns

(B) Two adjacent rows

(C) One row of the worksheet

(D) None of these

Source: This question is taken from the Microsoft Excel MCQs

Web browser stores previous information for web pages is termed as ______...?

(A) Auto complete

(B) Feed

(C) Web slices

(D) None of these

Source: This question is taken from the Naib Tehsildar General Knowledge PPSC Past Paper

Microsoft office spreadsheet program is ...?

(A) Microsoft word

(B) Microsoft excel

(C) Microsoft powerpoint

(D) none of these

Source: This question is taken from the Microsoft Excel MCQs

What is the full form of SQL...?

(A) Structured Query Language

(B) Structured Query List

(C) Simple Query Language

(D) None of these

Source: This question is taken from the Assistant (BS-16) Code-53 PPSC Past Paper

Which of the following is a correct email format of Email address...?

(A) Name@website,com

(B) Name website com

(C) Name@website@info

(D) All of these

Source: This question is taken from the Junior Computer Operator (Bs-12) Transport And Mass Transit Department, Irrigation Department PPSC 2024

A cooling agent that has lower temperature than water ice, is solid form of...?

(A) Nitrogen gas

(B) Ammonia

(C) Carbon dioxide

(D) None of these

Source: This question is taken from the Assistant Sub Inspector Punjab Police 2021

A group of adjacent cells to perform operations on the selected cells is called _____...?

(A) Range

(B) Row

(C) Column

(D) Both B and C

Source: This question is taken from the Microsoft Excel MCQs

Which key deletes the character to the right of the cursor in Ms Word...?

(A) End

(B) Backspace

(C) Home

(D) Delete

Source: This question is taken from the Microsoft Word MCQs

_____is the set of instructions given to the computer to perform a specific task...?

(A) Monitor

(B) Hardware

(C) Software

(D) Printer

Source: This question is taken from the Data Entry Operator BS-14 Lahore High Court 2022

In MS Word Ctrl+E is used to align the text in _____ slide of a paragraph....?

(A) Left

(B) Centre

(C) Right

(D) None of these

Source: This question is taken from the Junior Computer Operator PPSC Past Paper 2024

___________is used to create a chart in MS Excel...?

(A) CTRL+Y

(B) F11

(C) ALT+F11

(D) All of these

Source: This question is taken from the Intelligence Officer (Bs-14) Punjab Police, Special Branch Assistant (Bs-16) Cooperatives Department PPSC Past Paper 2024

The Greater Than sign is an example of operation...?

(A) Arithmetic

(B) Logical

(C) Conditional

(D) Greater

Source: This question is taken from the Clubbed Case Canal Patwari First Phase (Morning) 2023

What does moving from cell C9 to C11 mean in MS Excel...?

(A) C9:C11

(B) C9-C11

(C) C9 to C11

(D) None of these

Source: This question is taken from the Junior Computer Operator PPSC Past Paper 2024

What is the shortcut to justify a paragraph in Word:...?

(A) Ctrl+E

(B) Ctrl+R

(C) Ctrl+J

(D) Ctrl+Q

Source: This question is taken from the Junior Computer Operator (Bs-12) Transport And Mass Transit Department, Irrigation Department PPSC 2024

Default file name in MS Excel is...?

(A) Document 1

(B) Workbook 1

(C) Book1

(D) Worksheet

Source: This question is taken from the Microsoft Excel MCQs

CNN is a multinational news channel and website, what does CNN stands for...?

(A) Commercial News Network

(B) Common News Network

(C) Cable News Network

(D) None of these

Source: This question is taken from the Junior Clerk (BS-11) Board of Revenue PPSC Past Paper

Which is also known as a mechanical agent?...?

(A) Computer

(B) Barcode Reader

(C) Processor

(D) Robots

Source: This question is taken from the Data Entry Operator BS-14 Lahore High Court 2022

How are data organized in a spreadsheet...?

(A) Lines and spaces

(B) Layers and planes

(C) Rows and columns

(D) Height and width

Source: This question is taken from the Microsoft Excel MCQs

What is an other name for junk Email...?

(A) Spam

(B) Spoof

(C) Spill

(D) Spat

Source: This question is taken from the Assistant Service and General Administration (S&GAD) Paper

_________ is used to move from one web to another...?

(A) Browser

(B) Surfing

(C) Navigation

(D) None of these

Source: This question is taken from the Assistant Director Processing Agriculture Dep. (Bs-17) 2022

You can set page border in excel from: __________...?

(A) From Border tab in Format Cells dialog box

(B) From Border tool in Formatting toolbar

(C) From Line Style tool in Drawing toolbar

(D) You can not set page border in Excel

Source: This question is taken from the Microsoft Excel MCQs

The hardware or software used to stop traffic information:...?

(A) Firewall

(B) Gateway

(C) Virus checker

(D) Router

Source: This question is taken from the Assistant director (Bs-17) local government & community development department PPSC 2024

The oldest Internet following is: Search Engine among the...?

(A) Google

(B) MSN Search

(C) Yahoo

(D) Alta Vista

Source: This question is taken from the Sub Inspector Punjab Police Open Marit

Which of the following is an example for automatic text formatting...?

(A) Adjusting extra space

(B) Underlining hyperlink

(C) Replacing two -‘s with an em hyphens

(D) All of above

Source: This question is taken from the Microsoft PowerPoint MCQs

The size of the organization chart object is _____________...?

(A) Is determined by the presentation design and can not be changed

(B) Is determined by the presentation design but can be changed in PowerPoint

(C) Is dependent on the amount of text within the organization chart

(D) b and c

Source: This question is taken from the Microsoft PowerPoint MCQs

In MS Word, which tab is used for citation and bibliography...?

(A) Home

(B) Insert

(C) Review

(D) References

Source: This question is taken from the Microsoft Word MCQs

Which of the following is not considered a formatting feature...?

(A) Redo and Undo

(B) Font Style

(C) Font Size

(D) Underline

Source: This question is taken from the Microsoft PowerPoint MCQs

What device accept data from outside the computer and transfer it into the CPU...?

(A) Analogue to digital Converters

(B) Sensors

(C) Input devices

(D) Digital Devices

Source: This question is taken from the PROVINCIAL MANAGEMENT SERVICE, ETC. BS-17(2016)

What will be the result of formula '=16/2^3' in a cell in MS Excel...?

(A) 512

(B) 124

(C) 2

(D) 124

Source: This question is taken from the Microsoft Excel MCQs

Which of the following is used to create newspaper style columns in Ms Word...?

(A) Format Columns

(B) Table Insert Table

(C) Format Tabs

(D) Insert Textbox

Source: This question is taken from the Microsoft Word MCQs

What is the extension of files created in Ms-Word 97- 2003...?

(A) dot

(B) doc

(C) dom

(D) txt

Source: This question is taken from the Microsoft Word MCQs

which Excel tool allows you to set specific conditions for data entry ensuring accuracy and consistency in your analysis...?

(A) goal seek

(B) data validation

(C) scenario manager

(D) pivot table

Source: This question is taken from the Canal Patwari (BS-11) Irrigation ppsc past papers

What is the shortcut-key for manual line break in MS Word:...?

(A) Shift+Enter

(B) Ctrl+Enter

(C) Alt+Enter

(D) Ctrl+Shift+Enter

Source: This question is taken from the Junior Clerk Deputy Commissioner Office BOR

Verification of a login name and password is known as:...?

(A) authentication

(B) configuration

(C) accessibility

(D) None

Source: This question is taken from the Punjab Police Sub Inspector (SI) Service Quota PPSC Past

In MS excel, a _____________ identifies a range by the cells located at diagonally opposed corners....?

(A) Range

(B) Range Address

(C) Cell

(D) None of these

Source: This question is taken from the Microsoft Excel MCQs

Which PowerPoint feature allows the user to create a simple presentation quickly _______ ...?

(A) AutoContent Wizard

(B) Transition Wizard

(C) Chart Wizard

(D) Animations

Source: This question is taken from the Microsoft PowerPoint MCQs

In MS Excel, " ____ " is not an example of a value....?

(A) Obtained marks - 87

(B) July 16, 1982

(C) 57845

(D) None of these

Source: This question is taken from the Microsoft Excel MCQs

What is the purpose of inserting header and footer in document...?

(A) to enhance the overall appearance of the document

(B) to mark the starting and ending of page

(C) to make large document more readable

(D) to allow page headers and footers appear on document when printed

Source: This question is taken from the Microsoft Word MCQs

What do you call ‘a collection of character and paragraph formatting commands’...?

(A) the defaults

(B) a template

(C) a style

(D) a boilerplate

Source: This question is taken from the Microsoft Word MCQs

Suppose there is a text in a document that is Bold, Red in Color with Green Background We want to apply all of these formatting to another paragraph in one go. Which option will we use...?

(A) Format Painter

(B) Format Menu

(C) Format Button

(D) Format Macro

Source: This question is taken from the Canal Patwari (BS-11) Irrigation ppsc past papers

In a computer spreadsheet, which is true if the current or active cell is B4 and you pressed Enter key ...?

(A) you will be in the cell A1

(B) you will be in the cell B5

(C) you will be in the cell B3

(D) you will be in the cell B6

Source: This question is taken from the Microsoft Excel MCQs

Which of the following is not the Section Break Option in Ms Word...?

(A) Next Page

(B) Previous Page

(C) Odd Page

(D) Even Page

Source: This question is taken from the Microsoft Word MCQs

What is a portion of a document in which you set certain page formatting options...?

(A) Page Setup

(B) Section

(C) Page

(D) Document

Source: This question is taken from the Microsoft Word MCQs

It is possible to __________ a data source before performing a merge in Ms Word....?

(A) Modify

(B) Sort

(C) Create

(D) all of the above

Source: This question is taken from the Microsoft Word MCQs

How you can update the values of formula cell.If auto calculate the mode of excel cell is disabled...?

(A) f9

(B) f2

(C) f7

(D) none