PPSC Past Papers & Solved MCQs

Correct answer: To summarize and analyze data. A pivot table summarizes and analyzes large amounts of data interactively.

• Print data: Printing is done with the Print command.
• Sort data: Sorting is done with the Sort command.
• Filter data: Filtering is done with the Filter command.

Correct answer: Application Software. Application software is designed to help users perform specific tasks such as writing, calculating, or browsing.

• System Software: System software runs and manages the hardware.
• Utility Software: Utility software maintains and optimises the computer.
• Programming Software: Programming software is used by programmers to write programs.

Correct answer: Vint Cerf. Vint Cerf and Bob Kahn designed the TCP/IP protocols in the 1970s.

• Bill Gates: Bill Gates co-founded Microsoft.
• Charles Babbage: Charles Babbage designed the Difference Engine.
• Steve Jobs: Steve Jobs co-founded Apple.

Correct answer: Computer Hardware. The operating system controls and manages computer hardware and provides services for applications.

• Applications Software: It supports applications, but its core job is managing hardware.
• Personal Software: “Personal software” is not a standard term in this context.
• None of these: “None of these” is incorrect because computer hardware is correct.

Correct answer: Being able to work for hours without fatigue. Diligence means a computer can work for long hours without tiredness or loss of accuracy.

• Ability to do multiple things at once: Doing multiple things at once is multitasking.
• Works fast: Working fast is speed.
• None of these: “None of these” is incorrect because working without fatigue is correct.

Correct answer: Over the internet. Cloud computing provides data and services over the internet.

• On hard disk: A hard disk is local storage.
• On pen drive: A pen drive is local, portable storage.
• On CD: A CD is local, physical storage.

Correct answer: Mesh. In a full mesh every computer connects to every other, which requires n(n − 1)/2 = 300 links for 25 computers.

• Star: A star needs one link per computer (25) to a central hub.
• Bus: A bus uses one shared backbone cable.
• Ring: A ring needs about one link per computer (25).

Correct answer: To open Task Manager. Ctrl + Shift + Esc opens Task Manager directly in Windows.

• Shutdown: Shutdown is done from the Start menu or power options.
• Restart: Restart is done from the Start menu or power options.
• Log Off: Log Off is done from the Start menu or Ctrl + Alt + Delete screen.

Correct answer: Multiprocessor. A multiprocessor system uses two or more processors.

• Multitasking: Multitasking is running several tasks at the same time.
• Multiprogramming: Multiprogramming keeps several programs in memory so the CPU stays busy.
• Multiusers: Multiusers means several people using the system.

Correct answer: Multitasking. Multitasking is when an operating system runs more than one task at the same time.

• Multiprocessing: Multiprocessing means using more than one processor.
• Batch Processing: Batch processing runs a group of jobs without user interaction.
• Time Sharing: Time sharing lets several users share the CPU in turns.

Correct answer: CPU. The CPU fetches, decodes, and executes instructions.

• ALU: The ALU only performs arithmetic and logic operations inside the CPU.
• Hard Disk: A hard disk stores data.
• Software: Software is a set of instructions, not the part that executes them.

Correct answer: Machine & Assembly. Machine language and assembly language are low-level languages.

• C++, Java: C++ and Java are high-level languages.
• Python: Python is a high-level language.
• BASIC: BASIC is a high-level language.

Correct answer: Facebook. Facebook is a social media platform.

• MS Word: MS Word is word-processing software.
• Chrome: Chrome is a web browser.
• Excel: Excel is spreadsheet software.

Correct answer: Machine language. Machine language, made up of binary code, is the only language a computer executes directly.

• Assembly language: Assembly language must be translated by an assembler.
• High Level language: High-level languages must be translated by a compiler or interpreter.
• Binary language: “Binary language” is not the standard term; the standard term is machine language.

Correct answer: GUI. A GUI (Graphical User Interface) lets users interact using windows, icons, menus, and buttons.

• OS: An operating system manages the computer and may offer a graphical or a command-line interface.
• MacOS: MacOS is a specific operating system that uses a GUI, not the type of interface itself.
• All of the above: “All of the above” is incorrect because GUI is the only option that names a type of interface.

Correct answer: Spelling error correction. AutoCorrect automatically fixes common spelling and typing errors as you type.

• Format text: Formatting is done with the formatting tools.
• To create a table: Tables are inserted from the Insert tab.
• To print a document: Printing is done with the Print command.

Correct answer: 4.7 GB. A standard single-layer DVD-ROM holds 4.7 GB.

• 700 MB: 700 MB is the capacity of a CD-ROM.
• 1.44 MB: 1.44 MB is the capacity of a floppy disk.
• 25 GB: 25 GB is the capacity of a single-layer Blu-ray disc.

Correct answer: $. The dollar sign ($) fixes the row or column of a cell reference, such as $A$1.

• #: # appears in error values such as #REF!.
• @: @ is used in e-mail addresses and some references, but not absolute references.
• &: & joins text in a formula.

Correct answer: Content Management System. CMS stands for Content Management System, such as WordPress.

• Computer Management System: “Computer Management System” is not the standard meaning.
• Central Monitoring System: “Central Monitoring System” is not the standard meaning.
• Coding Management System: “Coding Management System” is not the standard meaning.

Correct answer: Recycle Bin. In Windows, deleted files go to the Recycle Bin, where they can be restored.

• My Documents: My Documents is a folder for saved files.
• Trash: Trash is the name used on macOS.
• Permanently Deleted: Files are permanently deleted only after the Recycle Bin is emptied or Shift + Delete is used.

Correct answer: Right click on column header > Column Width. Right-clicking a column header and choosing Column Width lets you enter an exact width.

• Double click on row: Double-clicking a row border adjusts row height, not column width.
• Home Tab > Font: The Font group formats text only.
• View Tab: The View tab changes the display and does not set column width.

Correct answer: Cache. Cache memory sits closest to the CPU and is the fastest of the options listed.

• RAM: RAM is slower than cache.
• Hard Disk: A hard disk is much slower than both.
• None of these: “None of these” is incorrect because cache is correct.

Correct answer: 32 bits. One byte is 8 bits, so 4 bytes = 4 × 8 = 32 bits.

• 8 bits: 8 bits is one byte.
• 16 bits: 16 bits is two bytes.
• 64 bits: 64 bits is eight bytes.

Correct answer: A single page of a presentation. A slide is a single page of a presentation.

• A collection of slides: A collection of slides is called a presentation.
• A sound file: A sound file is an audio file, not a slide.
• A video clip: A video clip is a media file that can be inserted in a slide.

Correct answer: To move to the previous sheet. Ctrl + Page Up moves to the previous worksheet in the workbook.

• To move up one screen: Page Up alone moves up one screen.
• To go to the top of the sheet: Ctrl + Home goes to the top of the sheet (cell A1).
• To move to the next sheet: Ctrl + Page Down moves to the next sheet.