In Excel, Columns are labeled as:
In Excel, Columns are labeled as A B C D .....
PPSC Past Papers & Solved MCQs
📚 Table of Content
The main component of a computer system that performs calculations and makes decisions is:
The CPU (Central Processing Unit) is often referred to as the 'brain' of the computer. It is responsible for executing instructions, performing arithmetic and logical operations, and managing the overall flow of data and instructions within the computer system. Without a CPU, a computer cannot function.
- (A) CPU is correct because it is the primary component for calculations and decision-making.
- (B) RAM (Random Access Memory) is incorrect; RAM is used for temporary data storage, not processing.
- (C) Monitor is incorrect; a monitor is an output device that displays visual information.
- (D) Hard Drive is incorrect; a hard drive is a storage device for long-term data retention.
ABC computer is used for:
The Atanasoff-Berry Computer (ABC) is widely recognized as one of the earliest electronic digital computing devices. While its initial purpose was to solve systems of linear equations, its architectural innovations, such as binary arithmetic and regenerative memory, laid crucial groundwork for the development of modern computers. It was not a specific-purpose computer in the sense of being limited to a single, unchangeable task like a dedicated calculator. Instead, its design principles contributed significantly to the evolution of machines capable of performing a variety of tasks through programming, making it a precursor to general-purpose computers. Distractors like "Specific purpose computer" are incorrect as ABC's influence extended beyond a singular, fixed application.
Who invented the telephone?
Alexander Graham Bell is widely credited with inventing the telephone and securing the first U.S. patent for it in 1876. His invention revolutionized communication, allowing voices to be transmitted over long distances and fundamentally changing how people interacted globally.
- (A) Nikola Tesla is incorrect; he was known for his contributions to alternating current electricity and radio technology.
- (B) Thomas Edison is incorrect; he was a prolific inventor known for the light bulb, phonograph, and motion picture camera.
- (C) Alexander Graham Bell is correct as he invented the telephone.
- (D) Albert Einstein is incorrect; he was a theoretical physicist known for his theories of relativity.
Which tool in MS Office is used to copy and paste character and paragraph formats to existing text?
The Format Painter in MS Office is the correct tool for copying and pasting character and paragraph formats. It allows users to quickly replicate formatting attributes—like font style, size, color, bolding, italics, paragraph alignment, and line spacing—from one piece of text to another. This feature is invaluable for maintaining a consistent visual style throughout a document. Paste Special (B) is used for pasting content with specific data types or formats, not for copying existing formatting styles. A Text Box (C) is a container for text, not a formatting application tool. Therefore, Format Painter is the precise and most efficient option for this task.
The largest continent in the world is:
Asia is the largest continent in the world by both land area and population. It covers approximately 30% of Earth's total land area and is home to over 60% of the world's human population. Its vast size encompasses diverse climates, cultures, and geographical features.
- (A) Asia is correct because it is the largest continent in terms of both landmass and population.
- (B) Africa is incorrect; it is the second-largest continent.
- (C) Europe is incorrect; it is significantly smaller than Asia and Africa.
- (D) North America is incorrect; it is the third-largest continent by land area.
Which of the following is an absolute cell reference?
The correct answer is $A$1. In spreadsheet applications like Microsoft Excel, an absolute cell reference is used to keep a cell's location constant when a formula is copied or filled to other cells. This is achieved by placing a dollar sign ($) before both the column letter and the row number.
- A1 is a relative cell reference, meaning it changes based on the relative position of the cell where the formula is copied.
- IA1 is not a standard or valid cell reference format in most spreadsheet programs.
- The other A1 option is also a relative reference.
Which of the following print commands should be selected to view the whole document?
The correct command to view the entire document before printing is Print Preview. This essential feature allows users to see an exact representation of how their document will appear on paper, including all formatting, layout, and page breaks. It enables a thorough review to catch any errors or undesirable layouts, ensuring the final printed output matches expectations. In contrast, "Print Design" is not a standard command for this purpose, and "Print All" simply sends the document directly to the printer without offering a prior visual inspection. Print Preview is crucial for quality control and avoiding wasted paper.
Who is known as the “Father of Modern Physics”?
Albert Einstein is widely regarded as the 'Father of Modern Physics' due to his revolutionary theories of relativity (special and general relativity). These theories fundamentally altered our understanding of space, time, gravity, and the universe, laying the groundwork for much of 20th-century physics and beyond.
- (A) Isaac Newton is incorrect; he is considered the 'Father of Classical Physics' for his laws of motion and universal gravitation.
- (B) Albert Einstein is correct for his pivotal role in developing modern physics.
- (C) Galileo Galilei is incorrect; he is often called the 'Father of Observational Astronomy' and 'Father of Modern Science'.
- (D) Nikola Tesla is incorrect; he was an electrical engineer and inventor known for his work on AC electricity.
A profit of rupees 12300 is distributed among the three partners in the ratio 4/3:7/6:11/12. Find the share of the third partner?
To find the share of the third partner, first simplify the given ratio 4/3:7/6:11/12. The least common multiple (LCM) of the denominators (3, 6, 12) is 12. Multiplying each fraction by 12 gives us the simplified ratio: (4/3)*12 : (7/6)*12 : (11/12)*12 = 16:14:11.
- The sum of the ratio parts is 16 + 14 + 11 = 41.
- The third partner's share is (11/41) of the total profit.
- Share = (11/41) * 12300 = 11 * 300 = 3300.
The other options are incorrect because they do not result from the correct simplification of the ratio and subsequent calculation of the third partner's share.
The largest producer of electricity in the Islamic world is:
The correct answer is (C) Saudi Arabia. Saudi Arabia is the largest producer of electricity in the Islamic world, primarily due to its vast oil and natural gas reserves which fuel its power plants. The country has a high demand for electricity for industrial use, desalination, and air conditioning, leading to significant investment in its power generation infrastructure.
- (A) Kazakhstan, (B) Uzbekistan, and (D) Tajikistan are significant energy producers in Central Asia, but their overall electricity generation capacity and consumption are considerably lower than that of Saudi Arabia.
- Saudi Arabia's extensive fossil fuel resources and economic development have positioned it as the leading electricity producer among Islamic nations.
What is the capital city of Canada?
The question asks for the capital city of Canada. Ottawa is the correct answer because it is the official capital of Canada, serving as the seat of the federal government. It was chosen by Queen Victoria in 1857 due to its strategic location and as a compromise between the English-speaking and French-speaking regions.
- Toronto is the largest city in Canada and the capital of the province of Ontario, but not the national capital.
- Vancouver is a major city in British Columbia on the west coast, known for its port and natural beauty.
- Montreal is the largest city in Quebec and a significant cultural and economic center, but not the capital of Canada.
A tank in the shape of a cylinder with a diameter of 2.4 m and height 6.4 m contains oil up to the brim. Find the number of complete smaller cylindrical containers, each with a base radius of 8.2 cm and height 28 cm, that can be completely filled using the oil from the tank?
To determine the number of smaller containers that can be filled, we must calculate the volume of both the large tank and the small containers, ensuring consistent units.
- Large Tank: Diameter = 2.4 m = 240 cm, so Radius (R) = 120 cm. Height (H) = 6.4 m = 640 cm. Volume = π * R² * H = π * (120)² * 640 = 9216000π cm³.
- Small Container: Radius (r) = 8.2 cm. Height (h) = 28 cm. Volume = π * r² * h = π * (8.2)² * 28 = 1882.72π cm³.
- Number of Containers: Divide the large tank's volume by the small container's volume: (9216000π) / (1882.72π) ≈ 4895.19.
Since only complete containers can be filled, the answer is 4895. The 'm³' unit in the option is a mislabeling, as the question asks for a count.
What do you mean by vertical separation between columns?
The correct answer is (B) Gutter. In typography and page layout, a gutter refers to the vertical separation or space between columns of text or between facing pages in a bound publication. It's crucial for readability and aesthetics, ensuring text from one column doesn't visually merge with another.
- (A) Index is an alphabetical list of names, subjects, etc., with references to the places where they occur.
- (C) Margin refers to the blank space between the edge of the page and the main body of the text. While related to spacing, it's distinct from the internal separation between columns.
- (D) None of these is incorrect because 'Gutter' precisely defines the vertical separation.
The official currency of Japan is:
The question asks for the official currency of Japan. Yen (JPY) is the correct answer, as it is the official currency of Japan and one of the world's major reserve currencies, widely used in international finance and trade.
- The Won is the official currency of South Korea and North Korea.
- The Yuan (specifically Renminbi) is the official currency of the People's Republic of China.
- The Ringgit is the official currency of Malaysia.
Each country typically has its own distinct currency, making it a fundamental aspect of its economic identity.
بنیے کا بیٹا کچھ _____ کر ہی گرتا ہے۔
This is a common Urdu idiom. The complete proverb is "بنیے کا بیٹا کچھ دیکھ کر ہی گرتا ہے," meaning a cautious person acts only after careful observation. Other options like 'کھیل', 'سیکھ', and 'پڑھ' do not form the correct idiomatic expression.
ان میں سے کونسی ضرب المثل ٹھیک ہے؟
The correct proverb is "چیل کے گھونسلے میں ماس کہاں," which translates to "Where is meat in an eagle's nest?" It signifies that a place or person lacking resources cannot provide something valuable. The other options are incorrect variations of this established Urdu idiom.
غزل کا پہلا شعر جو ردیف قافیہ کی پابندی کرتا ہے کیا کہلاتا ہے؟
In Urdu poetry, the first couplet (sher) of a ghazal is specifically called مطلع. It establishes the rhyme and meter for the entire ghazal. مقطع is the concluding couplet, while مقدمہ and نقیب are unrelated terms in this context.
اقبال اور اس کا عہد کس نے لکھی؟
اقبال اور اس کا عہد (Iqbal and his Era) is a significant critical work on Allama Iqbal's life and poetry. It was authored by the renowned Urdu scholar and poet جگن ناتھ آزاد. The other listed authors did not write this specific literary critique.
جدیدیت کی تلاش کس نے لکھی ہے؟
The literary critique جدیدیت کی تلاش (The Quest for Modernism) explores modernism in Urdu literature. This influential work was penned by the distinguished scholar and critic وحید قریشی. The other options are incorrect authors for this specific book.
حسن کوزہ گر کس کی نظم ہے؟
حسن کوزہ گر (Hasan the Potter) is a seminal and highly acclaimed long poem in modern Urdu literature. It is a masterpiece by the pioneering free-verse poet ن م راشد. The other poets listed are not the authors of this particular work.
آب حیات کس کی تصنیف ہے؟
آب حیات (The Water of Life) is a foundational work in Urdu literary history. This biographical dictionary of Urdu poets and critical history of Urdu poetry was authored by محمد حسین آزاد. The other options are incorrect for this classic text.
Sohail Warraich is a:
Sohail Warraich is a prominent Pakistani journalist and political analyst. His career is primarily focused on media, making options A (Comedian), B (Politician), and D (Actor) incorrect as they do not represent his main profession.
21 binders can bind 1400 books in 15 days. How many binders will be required to bind 800 books in 20 days?
The correct answer is 9. This is a work and time problem, best solved using the "man-days" concept.
- Step 1: 21 binders bind 1400 books in 15 days.
- Total man-days = 21 × 15 = 315 man-days for 1400 books.
- Man-days per book = 315 ÷ 1400 = 0.225 man-days per book.
- Step 2: For 800 books, total man-days required = 800 × 0.225 = 180 man-days.
- Available days = 20.
- Number of binders required = 180 man-days ÷ 20 days = 9 binders.
Options 7, 12, and 14 are incorrect. Hence, 9 binders are required.
The 1965 war started due to the military operation named:
The 1965 Indo-Pakistani War was initiated by Pakistan's Operation Gibraltar, an infiltration strategy into Jammu and Kashmir. Options B, C, and D refer to different military operations unrelated to the outbreak of the 1965 conflict.