Clubbed Case Canal Patwari First Phase (Morning) – PPSC Past Paper 2023 Solved MCQs

Canal Patwari First Phase PPSC Past Paper 2023

Subject: Computer Science
Q1: Click the formula bar is a method employed for:
A. Selecting a range
B. Editing cell content
C. Inserting chart
D. None of these

Clicking the formula bar in Excel allows you to **edit** the content of a selected cell. This is useful for modifying formulas, text, or numeric entries without changing the cell directly.

Subject: Computer Science
Q2: Which of the following keys is used to insert the current date in a spreadsheet function:
A. Month ()
B. Today ()
C. Year ()
D. None of these

The `=TODAY()` function in Excel returns the **current date**. It updates automatically each day you open the file, making it useful for dynamic calendars and reports.

Subject: Computer Science
Q3: A software application that allows a user to set page number and spell check of a document is known as:
A. Database
B. Word processor
C. Spreadsheet
D. None of these

A **word processor** like MS Word lets users create and format documents, insert page numbers, and check spelling. It is ideal for writing letters, reports, and assignments.

Subject: Computer Science
Q4: What is the correct formula to sum the values in A1 and A2 in MS Excel:
A. A1 plus A2
B. =together(A1:A2)
C. =A1+A2
D. None of these

To **sum** values from two cells in Excel, you use the formula `=A1+A2`. Excel supports arithmetic operations like addition using `+` symbol.

Subject: Computer Science
Q5: We can apply border to:
A. Cell
B. Paragraph
C. Table
D. All of these

Borders can be applied to **cells**, **paragraphs**, and **tables** to visually separate or highlight content in Word or Excel, improving document readability.

Subject: Computer Science
Q6: In MS Word, adding a Ghost text, such as “confidential” behind the text is applied using:
A. Watermark
B. Embedded text formatting
C. Embossed text formatting
D. None of these

A **watermark** is a faded text or image displayed behind the main content in a Word document. It is often used to show document status like "Confidential" or "Draft".

Subject: Computer Science
Q7: What are two common wildcard characters that MS Excel recognizes:
A. * and ?
B. & and >
C. * and /
D. # and *

In Excel, `*` represents **any number of characters**, and `?` stands for **a single character**. These are useful in search and filter functions like FIND or VLOOKUP.

Subject: Computer Science
Q8: An electronic spreadsheet consists of:
A. Rows
B. Columns
C. Cells
D. All of these

A spreadsheet is made up of **rows**, **columns**, and **cells**. Each cell is the intersection of a row and column, where you input and manage data.

Subject: Computer Science
Q9: Which menu or toolbar will be used to change the case:
A. Ctrl+F4
B. Ctrl+Shift+F5
C. Alt+F6
D. Shift+F3

In MS Word, **Shift+F3** changes the case of selected text between lowercase, UPPERCASE, and Capitalize Each Word — a handy formatting shortcut.

Subject: Computer Science
Q10: In MS Excel the command used to combine / merge the consecutively selected cells and center aligned is:
A. Combine & Center
B. Combine
C. Merge & Center
D. None of these

The **Merge & Center** option in Excel combines selected cells into one and centers the text. It is often used for headers and titles across columns.

Subject: Computer Science
Q11: Which one is the spreadsheet application that comes with MS Office software group:
A. MS Word
B. MS Excel
C. MS PowerPoint
D. None of Above

MS Excel is a spreadsheet application included in the Microsoft Office suite. It helps users in organizing data, performing calculations, and generating reports using tables, rows, columns, and formulas.

Subject: Computer Science
Q12: When a new row is inserted:
A. All following rows are shifted to the right
B. All preceding rows are moved toward the top of the worksheet
C. All following rows are moving towards the bottom of the worksheet
D. Both A & C

In Excel, inserting a new row causes all the rows below it to shift downward automatically. This makes space for the new data without overwriting existing content.

Subject: Computer Science
Q13: Suppose there is a text in a document that is Bold, Red in color with Green background. We want to apply these formatting to another paragraph in one go, which component will we use:
A. Format Menu
B. Format Painter
C. Format Macro
D. None of these

Format Painter is a tool in MS Word that allows users to copy formatting from one section of text and apply it to another instantly. It's useful for saving time and maintaining consistency in document styling.

Subject: Computer Science
Q14: Microsoft Excel functions arguments are always written in:
A. Columns
B. Rows
C. None of these
D. Parentheses

In MS Excel, function arguments are enclosed in parentheses. For instance, `=SUM(A1:A3)` includes a range as an argument within parentheses for proper function execution.

Subject: Computer Science
Q15: To add two cells (A1 and A2) together in MS Excel, __ formula is used:
A. =together(A1:A2)
B. A1 plus A2
C. =A1+A2
D. =Add(A1+A2)

The formula `=A1+A2` is used to add values from two cells in Excel. It follows the standard mathematical addition format and is a basic operation for data calculations.

Subject: Computer Science
Q16: In MS Word what is the shortcut key for center the selected text:
A. Ctrl+E
B. Ctrl+P
C. Ctrl+L
D. Ctrl+R

Ctrl+E is the shortcut key in MS Word used to center-align selected text. It is especially helpful when formatting titles, headings, or any text that needs to be visually centered.

Subject: Computer Science
Q17: By Default Footers are printed on:
A. First page
B. Even pages
C. All pages
D. None of Above

By default, MS Word includes footers on all pages of a document unless the settings are manually changed. Footers are often used for page numbers or document metadata.

Subject: Computer Science
Q18: In MS Word, When the user is reading a document on the screen and wants to hide all the elements except for the document, he chooses:
A. Web layout view
B. Full Screen reading view
C. Print layout
D. None of these

Full Screen Reading View in MS Word hides ribbons and menus, displaying only the document content. This mode enhances readability by providing a distraction-free interface.

Subject: Computer Science
Q19: The cell referencing, that does not change when copied is:
A. Comparative
B. Absolute
C. Reference
D. None of these

Absolute referencing in Excel, such as `$A$1`, keeps the reference fixed even when the formula is copied elsewhere. This is essential in consistent formula applications.

Subject: Computer Science
Q20: The top most bar of document file is called __ bar:
A. Top
B. Title
C. Home
D. Footer

The Title Bar is located at the top of the MS Word window. It displays the name of the document along with the program title and often includes control buttons like minimize or close.

Subject: Computer Science
Q21: Which menu/group will we use if we want to change the typeface of selected text:
A. Format
B. View
C. Edit
D. Insert

The "Format" menu in MS Word or the "Font" group in the Home tab is used to change the typeface (font style) of selected text. It provides options like font size, color, and effects.

Subject: Computer Science
Q22: To undo last action in MS Word, shortcut combination is used:
A. Ctrl+W
B. Ctrl+Z
C. Ctrl+S
D. Ctrl+K

Ctrl+Z is the shortcut for undoing the last action in MS Word and other MS Office programs. It helps users quickly reverse mistakes during editing.

Subject: Computer Science
Q23: Which of the following function is used to get the current date?
A. Exact ()
B. Today ()
C. Year ()
D. None of these

The `TODAY()` function in Excel automatically returns the current date. It updates every time the worksheet is recalculated, making it ideal for time-sensitive formulas.

Subject: Computer Science
Q24: Which one is not the correct method of editing a cell’s content:
A. Double click
B. Press the F2 key
C. None of these
D. Press the Alt key

Editing a cell can be done by double-clicking or pressing F2. The Alt key does not allow direct editing of a cell, so it's not a valid method for this task.

Subject: Computer Science
Q25: In MS Excel function to return one value if a condition is true and another value if it’s false:
A. Decimal function
B. IF function
C. True function
D. All of these

The IF function in Excel evaluates a condition and returns one value if the condition is TRUE and another if FALSE. It's useful for logical comparisons and decision-making in formulas.

Subject: Current Affairs
Q26: On the plea of weapons of mass destruction, US-led forces invaded Iraq on:
A. March 20, 2003
B. June 24, 2002
C. March 27, 2004
D. July 30, 2007

The U.S.-led invasion of Iraq began on March 20, 2003, citing the presence of weapons of mass destruction. This marked the start of a major conflict in the Middle East with global impact.

Subject: Pak Studies
Q27: RCD was established in:
A. 1960
B. 1964
C. 1967
D. 1969

RCD (Regional Cooperation for Development) was established in 1964 by Pakistan, Iran, and Turkey to promote socio-economic development among member countries.

Subject: English
Q28: Identify the part of speech of the underlined word: “He has done it.”
A. Adverb
B. Auxiliary verb
C. None of these
D. Interjective

In the sentence "He has done it," the word "has" is an auxiliary verb. It helps form the present perfect tense by supporting the main verb "done."

Subject: Computer Science
Q29: Where is a list of all functions displayed:
A. Function box
B. Dialog box
C. Category box
D. None of these

The Function Box (also known as the Insert Function tool) in Excel displays a list of all available functions. It assists users in selecting and applying formulas efficiently.

Subject: Computer Science
Q30: Main window in a computer spreadsheet is called:
A. Workbook
B. Work
C. Sheet
D. None of these

A Workbook in Excel is the main file that contains one or more worksheets. It is the primary interface where data entry, analysis, and calculation are done.

Subject: Islamic Studies
Q31: When Qadianis were declared non-Muslims:
A. 1974
B. 1972
C. 1977
D. 1978

In 1974, the Pakistani parliament passed a constitutional amendment declaring Qadianis (Ahmadis) as non-Muslims. This was a landmark event in the religious and political history of Pakistan.

Subject: English
Q32: Choose the correct meaning of the idiom: “Bag and Baggage”
A. With anger
B. With all belongings
C. With due respect
D. None of these

The idiom "bag and baggage" means to leave or arrive with all personal belongings. It often implies a complete departure or movement from one place to another.

Subject: History
Q33: The Truman doctrine was announced on:
A. 6th February 1946
B. 12th March, 1947
C. 3rd June 1948
D. 15th August 1949

The Truman Doctrine was declared on March 12, 1947, to support countries resisting communism. It became a cornerstone of American foreign policy during the Cold War.

Subject: Current Affairs
Q34: When did UN Security Council impose sanctions on Iran due to its nuclear program?
A. December 2006
B. April 2006
C. March 2005
D. January 2004

In December 2006, the UN Security Council imposed sanctions on Iran over its nuclear activities. These sanctions aimed to pressure Iran to suspend uranium enrichment.

Subject: Computer Science
Q35: Which command is used to generate a series of data directly from the values of the selected cells:
A. Row Fill
B. Fill
C. Range Fill
D. None of these

The "Fill" command in Excel helps to automatically generate a series based on the pattern of selected cells. It’s widely used for completing data sequences like numbers or dates.

Subject: Current Affairs
Q36: Agra conference was held between Pakistan and India in:
A. 1998
B. 2003
C. 2001
D. 2004

The Agra Summit between India and Pakistan was held in 2001 to discuss peace and resolve key bilateral issues, including Kashmir. However, it ended without a formal agreement.

Subject: Pak Studies
Q37: How many were the members of Basic Democracies from East Pakistan?
A. 40000
B. 80000
C. 90000
D. 70000

Under Ayub Khan’s Basic Democracies system, 40,000 members represented East Pakistan. This system aimed to decentralize governance and increase local participation.

Subject: English
Q38: Choose the word that is nearest in meaning of the capitalized word: ABRUPTLY
A. Suddenly
B. Clearly
C. Easily
D. None of these

The word "abruptly" means suddenly or unexpectedly. It describes something that happens without warning or preparation, often causing surprise or disruption.

Subject: Islamic Studies
Q39: The bar used to display the current cell and its contents is:
A. Function bar
B. Formula bar
C. Object bar
D. None of these

The formula bar in Excel displays the contents of the active cell. It also allows users to enter or edit data or formulas directly into a selected cell.

Subject: Current Affairs
Q40: Pakistan signed to become a full member of SCO in:
A. 2012
B. 2017
C. 2016
D. 2011

Pakistan became a full member of the Shanghai Cooperation Organisation (SCO) in 2017, aiming to strengthen regional cooperation in areas such as security, trade, and culture.

Subject: Pak Studies
Q41: In Pakistan, the first population census was administered in:
A. 1947
B. 1951
C. 1954
D. All of these

The first official population census of Pakistan was administered in 1951. It provided crucial demographic data after independence and laid the foundation for planning and development.

Subject: Everyday Science
Q42: The color of plant other than green is due to plastids named as:
A. Chloroplast
B. Chromoplast
C. Both A & C
D. None of these

Chromoplasts are plastids responsible for giving red, orange, and yellow colors to plants, especially fruits and flowers. They store pigments other than chlorophyll.

Subject: Pak Studies
Q43: What was the proportional share of Pakistan in the assets at the time of partition:
A. 715 million rupees
B. 750 million rupees
C. 645 million rupees
D. 750 million rupees

At the time of partition in 1947, Pakistan's agreed financial share was 750 million rupees. This was a contentious issue with delays caused by political tensions with India.

Subject: Geography
Q44: The Mangla Dam is located in district:
A. Gujrat
B. Rawalpindi
C. Mirpur
D. None of these

Mangla Dam is situated in the Mirpur District of Azad Jammu and Kashmir. It is one of Pakistan’s largest dams and plays a vital role in water storage and power generation.

Subject: English
Q45: Choose the word that is opposite in meaning of the capitalized word: BACKWARD
A. Developed
B. Pious
C. Soft
D. Intellectual

The word "backward" means underdeveloped or behind in progress. Its opposite is "developed," which refers to advanced, modern, or highly progressed areas or systems.

Subject: Current Affairs
Q46: North Korea cut off its hotlines with which nation in June 2020:
A. China
B. South Korea
C. US
D. None of these

In June 2020, North Korea severed communication hotlines with South Korea due to rising diplomatic tensions, particularly over propaganda leaflets and military concerns.

Subject: Current Affairs
Q47: Which country recently stopped its 12 million USD funding to World Wildlife Fund:
A. USA
B. China
C. Uzbekistan
D. India

The USA suspended its $12 million funding to the World Wildlife Fund over concerns regarding misuse of funds and human rights violations in some project areas.

Subject: English
Q48: Choose the correct meaning of the idiom: “Once in a blue moon”
A. Very easily
B. Very rarely
C. Sadly
D. None of these

The idiom “once in a blue moon” refers to something that happens very rarely. It originates from the rare appearance of a second full moon in a single month.

Subject: Everyday Science
Q49: Milk has pH:
A. 9.4
B. 6.5
C. 8.3
D. 7.1

Milk has a slightly acidic pH around 6.5. Its pH can shift based on factors like storage time and bacterial activity, which affects its freshness and taste.

Subject: Computer Science
Q50: The formula used to perform calculations in the worksheet can be inserted with the help of:
A. Insert OLE object icon
B. Insert Formula icon
C. Insert Plug-in icon
D. None of these

In Excel, formulas for performing calculations are inserted using the "Insert Formula" icon. This helps automate computations and ensures data accuracy in spreadsheets.

Subject: History
Q51: In whose regime the first census was executed in India?
A. Lord Dalhousie
B. Lord Mayo
C. Lord Rippon
D. Lord Minto

The first census in India was executed in 1872 under the regime of Lord Mayo. It was a non-synchronous census and laid the foundation for future population data collection in British India.

Subject: Geography
Q52: Which road connects Pakistan with China?
A. Silk route
B. National Highway
C. N-22
D. None of these

The Silk Route, specifically the Karakoram Highway, connects Pakistan with China. It is a key trade and travel corridor that passes through the scenic mountain ranges of Gilgit-Baltistan.

Subject: English
Q53: Money makes the _ go.
A. Time
B. Life
C. Mare
D. None of these

The correct idiom is "Money makes the mare go," meaning money is a powerful motivator and can influence actions or decisions that otherwise wouldn’t happen.

Subject: English
Q54: Where have you been all day?
A. Verb
B. Interjective
C. Adverb
D. Pronoun

In the sentence “Where have you been all day?”, the word "where" is functioning as an adverb of place, asking about the location of the subject's activity.

Subject: English
Q55: The birds are sitting _ the trees.
A. over
B. in
C. None of these
D. on

The correct preposition is “in,” as birds sitting "in the trees" implies they are among the branches. "On" would suggest being on top, which is uncommon usage in this context.

For more practice, you can also review the Canal Patwari 2nd Phase Morning 2023 paper and the Clubbed Case Canal Patwari Phase 2 Evening past paper. These papers will help you prepare better for upcoming PPSC Canal Patwari exams.