Model Paper PPSC 2023 Canal Patwari Second Phase Evening 10-12-2023

Total Questions: 100

1 - Which of the following is an absolute cell reference?

A ) !A!1

B ) $A$1 ✅

C ) #a#1

D ) A1

Explanation: An absolute reference is designated in a formula by the addition of a dollar sign ($) before the column and row. If it precedes the column or row (but not both), it's known as a mixed reference. You will use the relative (A2) and absolute ($A$2) formats in most formulas. Mixed references are used less frequently.

2 - A profit of rupees 12300 is distributed among the three partners in the ratio 4/3:7/6:11/12. Find the share of third partner?

A ) 4200

B ) 3300 ✅

C ) 4600

D ) None of these

3 - A computer program that translates one program instructions at a time into machine language is called:

A ) Compiler

B ) Simulator

C ) Interpreter ✅

D ) CPU

Explanation: Interpreter: An interpreter translates code written in a high-level programming language into machine code line-by-line as the code runs.

4 - 80% of 700 is:

A ) 560 ✅

B ) 570

C ) 580

D ) 590

5 - The price of a share in the stock exchange dropped from 62.50 to RS. 52.50 in a week. What was the percentage change in the price of share?

A ) 10%

B ) 12%

C ) 14%

D ) 16% ✅

6 - The pious Islamic Khilafat of Rashidun lasted from 632 AD to.......

A ) 658 AD

B ) 659 AD

C ) 660 AD

D ) 661 AD ✅

7 - Which key is used to copy the formula from the above cell:

A ) Ctrl+' ✅

B ) Ctrl+;

C ) Ctrl+:

D ) None of these

Explanation: Copy: Ctrl + C. Cut: Ctrl + X. Paste: Ctrl + V.

8 - Which type of data is used for inserting or placing content from clipboard into a document:

A ) Deleted data ✅

B ) Repeated data

C ) Existing data

D ) None of these

9 - In MS Word superscript subscript strikethrough are known as:

A ) Font Style

B ) Font Format

C ) Font Family

D ) Font Effect ✅

Explanation: n Microsoft Word, Superscript, subscript, and strikethrough are known as Font effects. On the Home tab, in the Font group, pick the Font Dialog Box Launcher. On the Font tab, under Effects, select the Superscript or Subscript check box.

10 - Tehzeeb-ul-Ikhlaq is a journal written by:

A ) Sir Syed Ahmad Khan ✅

B ) Shah Wali Ullah

C ) Abdul Kalam Azad

D ) None of these

Explanation: Sir Syed Ahmad Khan, one of the architects of modern India was born on October 17, 1817, in Delhi and started his career as a civil servant.

11 - An error in software or hardware is called a bug. What is the alternative computer jargon for it?

A ) Leech

B ) Squid

C ) Slug

D ) Glitch ✅

Explanation: A glitch is a problem that stops something from working properly or being successful.

12 - The extension of MS Excel is:

A ) xls ✅

B ) docx

C ) ppt

D ) None of these

Explanation: The XLS file extension is used for files saved as Microsoft Excel worksheets. Excel is a popular spreadsheet program used with data like numbers and formulas, text, and drawing shapes. Excel is part of the Microsoft Office Suite of software.

13 - To what temporary area can you store text and other data, and later paste them to another location?

A ) Clipboard ✅

B ) ROM

C ) Hard Disk

D ) None of these

Explanation: The clipboard is a buffer that some operating systems provide for short-term storage and transfer within and between application programs. The clipboard is usually temporary and unnamed, and its contents reside in the computer's RAM.

14 - In Excel,Columns are labelled as....

A ) A,B,C ✅

B ) A1,A2,A3

C ) 1,2,3

D ) $A$1,$B$2

15 - Which key is used for duplicate the selected text so that it can be used in another place:

A ) Ctrl+C ✅

B ) Ctrl+D

C ) Ctrl+O

D ) Ctrl+I

16 - ABC computer is used for:

A ) Specific purpose computer ✅

B ) General purpose computer

C ) Both A&B

D ) None of these

Explanation: The ABC was designed for a specific purpose – the solution of systems of simultaneous linear equations. It could handle systems with up to 29 equations, a difficult problem for the time. Problems of this scale were becoming common in physics, the department in which John Atanasoff worked.

17 - Which tool in MS Office is used to copy and paste character and paragraph formats to existing text:

A ) Format Painter ✅

B ) Paste special

C ) Text box

D ) None of these

18 - Which of the following print command should be selected to view the whole document:

A ) Print Layout

B ) Print Design

C ) Print All

D ) Print Preview ✅

19 - The largest producer of electricity in the Islamic World is:

A ) Kazakhstan

B ) Uzbekistan

C ) Saudi Arabia ✅

D ) Tajikistan

Explanation: Saudi Arabia had a total wealth of $2.26 trillion in 2022. Since 2012, Saudi Arabia's total wealth has increased by 80.80%. Ranked 25th on our list, Saudi Arabia is one of the wealthiest countries by per capita net wort

20 - What do you mean by vertical separation between columns:

A ) Index

B ) Gutter

C ) Margin ✅

D ) Indent

Explanation: In typography, a margin is the area between the main content of a page and the page edges. The margin helps to define where a line of text begins and ends. When a page is justified the text is spread out to be flush with the left and right margins.

21 - What is the function of Recycle Bin?

A ) Store deleted file ✅

B ) Store corrupt file

C ) Store temporary file

D ) Store document file

22 - A feature of MS Word that saves the document automatically after certain interval is:

A ) Auto update

B ) Auto recover

C ) Auto save ✅

D ) None of these

23 - Which shortcut is used to decrease the text font size:

A ) Ctrl+Shift+< ✅

B ) Ctrl+Shift+>

C ) Ctrl+Shift+F

D ) Ctrl+Alt+F

24 - Which of the following will happen when data is entered into a memory location?

A ) It will erase the previous content ✅

B ) It will change the address of one memory location

C ) It will add to the content of solution

D ) None of these

25 - In MS Excel, methametical formula contains:

A ) Label

B ) Numeric value

C ) Label & Numeric value ✅

D ) None of these

26 - Which option in file menu is used to close a file in MS word:

A ) Exit

B ) Close ✅

C ) Quit

D ) New

27 - To check spelling and grammar which key is used in MS Word:

A ) F3

B ) F5

C ) F7 ✅

D ) F9

28 - World War II began with the German invasion of:

A ) Russia

B ) Spain

C ) UK

D ) Poland ✅

29 - Which of the following is not a term of MS-Excel?

A ) Cell

B ) Row

C ) Column

D ) Document ✅

30 - By default,the page size of a new document is....inches by....inches.

A ) 8.5 and 11 ✅

B ) 7.5 and 12

C ) 7.5 and 11.5

D ) None of these

31 - One Atmospheric Pressure is equal to:

A ) 700 mm

B ) 730 mm

C ) 760 mm ✅

D ) 790 mm

32 - "Ctrl+End" is used to:

A ) Moves the cursor to the end of Line

B ) Moves the cursor to the end of Document ✅

C ) Moves the cursor to the end of Paragraph

D ) None of these

33 - Which key is press to enter the data in a cell in Excel:

A ) Enter ✅

B ) Shift

C ) Space

D ) None of these

34 - Socrates was born in:

A ) 449 BC

B ) 459 BC

C ) 469 BC ✅

D ) 479 BC

35 - The antonym of Furiously is:

A ) Mercifully ✅

B ) Angrily

C ) Happily

D ) Slowly

36 - The meaning of the idiom Kick the Bucket means:

A ) To kill

B ) To die ✅

C ) To be successful

D ) To achieve a goal

37 - In which Microsoft office suite,it allows you to create visually engaging presentations:

A ) MS Word

B ) MS PowerPoint ✅

C ) MS Excel

D ) None of these

38 - Which key is used for help in MS Word:

A ) F1 ✅

B ) F3

C ) F5

D ) F7

39 - In MS Word Go to is part of:

A ) Locate

B ) Find

C ) Search

D ) Replace ✅

40 - What is placed to the left of horizontal scroll bar:

A ) View buttons ✅

B ) Indicators

C ) Split buttons

D ) Tab stop buttons

41 - What is maximum zoom percentage in MS -Word:

A ) 100%

B ) 300%

C ) 500% ✅

D ) 600%

42 - Female Anopheles mosquito acts as the carrier for dengue virus:

A ) Anophles

B ) Aedes Aegypti ✅

C ) Manson ides

D ) Culex

43 - To view the left side of the page we use in a document in MS Word, which scroll bar should be utilized:

A ) Vertical Scroll Bar ✅

B ) Left Margin Scroll Bar

C ) Vertical Scroll Bar

D ) None of these

44 - What is the height of mount K2:

A ) 7960 m

B ) 8611 m ✅

C ) 4848 m

D ) 8485 m

Explanation:

✅ K2 is also called: Mount Godwin-Austen

Key Points for Competitive Exams:

✅ Other Names: Mount Godwin-Austen, Chogori (Balti), Savage Mountain
✅ Height: 8,611 m – 2nd highest mountain in the world
✅ Location: Karakoram Range, Gilgit-Baltistan, Pakistan (near China border)
✅ Named After: Henry Godwin-Austen, British surveyor and geographer
✅ Survey Name: K2 (given in 1856 by T.G. Montgomerie; “K” for Karakoram, “2” for second peak)
✅ First Ascent: 31 July 1954 by Achille Compagnoni & Lino Lacedelli (Italy)
✅ Fame: Known as “Savage Mountain” due to extreme climbing difficulty and high fatality rate
✅ First to climb K2: Names: Achille Compagnoni & Lino Lacedelli
Country: Italy ,Date: 31 July 1954.

45 - What is the number of read-write heads in the drive for a 9- trac magnetic tape?

A ) 9 ✅

B ) 16

C ) 18

D ) 27

46 - In MS Word,"Ctrl+Page Up" is used to:

A ) Moves the cursor one Page Up ✅

B ) Moves the cursor one Line Up

C ) Moves the cursor one Screen Up

D ) Moves the cursor one Paragraph Up

47 - The synonym of Amplify is:

A ) Diminish

B ) Enlarge ✅

C ) Meager

D ) Enhance

48 - Kalabagh is located in which province:

A ) Punjab ✅

B ) Sindh

C ) KPK

D ) Balouchistan

49 - Which panes keeps specific rows or columns visible when you scroll in the worksheet.

A ) Split pane

B ) Freezing pane ✅

C ) Filter pane

D ) None of these

50 - I am sure that I meet your brother "(before)". The in bracket word is which part of speech.

A ) Verb

B ) Adverb ✅

C ) Adjective

D ) Conjunction

51 - Allama Iqbal delivered his famous Allahabad address in which city:

A ) Delhi

B ) Mumbai

C ) Lahore

D ) Allahbad ✅

52 - Which one of the following is an insectivorous plant:

A ) Venus flytrap

B ) Pitcher plant

C ) Bladderwort

D ) Venus flytrap ,Pitcher plant, Bladderwort ✅

53 - When working with formulas in Excel,how can you see the intermediate results of a calculation before the final answer is displayed:

A ) Evaluate on formula bar

B ) Shown on formula bar

C ) Middle of the formula

D ) Evaluation cannot be done in between the calculation ✅

54 - Which key do you press while clicking to select more than one file or folder?

A ) Ctrl ✅

B ) Shift

C ) Alt

D ) None of these

55 - What does a Chronometer measure:

A ) Sound waves

B ) Time ✅

C ) Color contrast

D ) Water waves

56 - The group of cells in MS Excel is known as:

A ) Set

B ) List

C ) Range ✅

D ) None of these

57 - Roger Penrose,Reinhard Genzel and Andrea Ghez awarded Nobel prize in which field:

A ) Physics ✅

B ) Medicine

C ) Chemistry

D ) None of these

58 - Choose the correct voice of the sentence Your services will be acknowledged by the government.

A ) The government will be acknowledge your services ✅

B ) The government will be acknowledging by your services.

C ) Your services will have acknowledged by the government

D ) None of these

59 - Burning of a candle is a:

A ) Physical change

B ) Chemical change

C ) Physical change & Chemical change ✅

D ) None of these

60 - The analogy of Bee: Honey is

A ) Cupboard: Carpenter

B ) Artist: Sculpture ✅

C ) Sonnet:Poem

D ) Sparrow:Nest

61 - Which one of the following is input device:

A ) Printer

B ) Scanner ✅

C ) Monitor

D ) Speaker

62 - Identify the missing word which completes the proverb .........will not built in a day.

A ) London

B ) Rome ✅

C ) Spain

D ) Germany

63 - When did Cyprus gain independence from Britain:

A ) March 10, 1960

B ) August 16,1960 ✅

C ) October 20, 1960

D ) November 19,1960

64 - Recently deleted files are stored in:

A ) Taskbar

B ) Recycle Bin ✅

C ) Desktop

D ) None of these

65 - Pakistan joins United Nations on:

A ) 30th September 1947 ✅

B ) 1st January 1948

C ) 25 December 1947

D ) 10 December 1947

66 - Faisal Masjid is located in:

A ) Faisalabad

B ) Islamabad ✅

C ) Lahore

D ) Karachi

67 - Change narration: He asked his friends if he likes chess.

A ) He asked his friends,"why you like chess"?

B ) He asked his friend,"Did you like chess? ✅

C ) He said to his friend,"Did you like chess"?

D ) None of these

68 - In the Indian Rebellion of 1857, 80 soldiers who disobeyed Colonel Smith for using greased cartridges belongs to:

A ) Meerut ✅

B ) Agra

C ) Delhi

D ) Mumbai

69 - ------- is a set of commands grouped together that we can run

A ) Goal Seek

B ) Macros ✅

C ) What if analysis

D ) None of these

70 - How many articles of 1956 constitution of Islamic Republic of Pakistan:

A ) 234 ✅

B ) 250

C ) 280

D ) 290

71 - What is the meaning of the phrasal verb Break down:

A ) Stop working ✅

B ) Get up

C ) Rise

D ) Die

72 - When did Pakistan conducted nuclear test:

A ) 28 May 1998 ✅

B ) 29 May 1998

C ) 30 May 1998

D ) None of these

73 - The most populous city of Pakistan is:

A ) Karachi ✅

B ) Lahore

C ) Faisalabad

D ) Peshawar

74 - Which function is used to find string length in PPSC and give the answer 4:

A ) Length (PPSC)

B ) Len(PPSC) ✅

C ) Strl(PPSC)

D ) None of these

75 - When Pakistan left Central Treaty Organization (CENTO):

A ) 1971

B ) 1975

C ) 1979 ✅

D ) 1983

76 - Mona is afraid-----spiders.

A ) Of ✅

B ) By

C ) To

D ) At

77 - Analog Computer works on the supply of:

A ) Continuous electrical pulses ✅

B ) Electrical pulses but not continuous

C ) Magnetic strength

D ) None of these

78 - In which constitution of Islamic Republic of Pakistan adopted Presidential from of government:

A ) 1956

B ) 1962 ✅

C ) 1973

D ) None of these

79 - We can open the MS Word file by typing.....in the run dialogue box.

A ) Winword.exe ✅

B ) word.docx

C ) Word.exe

D ) None of these

80 - How many different positions can you set for drop cap in MS Word:

A ) 1

B ) 2 ✅

C ) 3

D ) 4

81 - The title of page of Microsoft Word document is called:

A ) Start page

B ) Cover page ✅

C ) Front page

D ) None of these

82 - What is the maximum angle you can rotate text within a cell in MS Excel:

A ) 90 ✅

B ) 180

C ) 270

D ) 360

Explanation: The text orientation options available on the ribbon only allow to make text vertical, rotate text up and down to 90 degrees and turn text sideways to 45 degrees. The Orientation option in the Format Cells dialog box enables you to rotate text at any angle, clockwise or counterclockwise.

83 - Which country border shared with Pakistan stretches for approximately 2250 km:

A ) India

B ) Afghanistan ✅

C ) Iran

D ) China

84 - The least significant bit of the binary number, which is equivalent to any odd decimal number,is

A ) 0 ✅

B ) 1

C ) 2

D ) 3

85 - Interest rate can be used in:

A ) Mathematics

B ) Statistics

C ) Financial

D ) Macroeconomics ✅

Explanation: Interest rates affect economic activity broadly, which is the reason why they are normally the main instrument of the monetary policies conducted by central banks. Changes in interest rates will affect firms' investment behaviour, either raising or lowering the opportunity cost of investing.