PPSC Past Papers 2026 Solved

Correct answer: Ctrl+F. Ctrl + F opens the Find box for searching text.

• Ctrl+H: Ctrl + H opens Find and Replace.
• Ctrl+G: Ctrl + G opens Go To.
• Ctrl+S: Ctrl + S saves the file.

Correct answer: Ctrl+Page Down. Ctrl + Page Down moves to the next worksheet.

• Ctrl+Page Up: Ctrl + Page Up moves to the previous sheet.
• Alt+Page Down: Alt + Page Down moves one screen to the right within a sheet.
• Shift+Page Down: Shift + Page Down extends the selection down one screen.

Correct answer: Ctrl+Y. Ctrl + Y redoes the action that was undone.

• Ctrl+Z: Ctrl + Z undoes the last action.
• Ctrl+R: Ctrl + R aligns text to the right in Word.
• Ctrl+D: Ctrl + D opens the Font dialog in Word.

Correct answer: Mailing Tab. The Mailings tab contains the Start Mail Merge group and related commands.

• Home Tab: The Home tab is for formatting and editing.
• Insert Tab: The Insert tab adds tables, pictures, and other objects.
• Review Tab: The Review tab contains proofing and comments tools.

Correct answer: Ctrl+Z. Ctrl + Z undoes the last action.

• Ctrl+Y: Ctrl + Y redoes an action.
• Ctrl+U: Ctrl + U underlines text.
• Ctrl+X: Ctrl + X cuts the selection.

Correct answer: Title Bar. The title bar sits at the top of the window and displays the document and program name.

• Menu Bar: The menu bar lists menus below the title bar.
• Tool Bar: The toolbar holds command buttons.
• Status Bar: The status bar is at the bottom of the window.

Correct answer: Shift+Enter. Shift + Enter inserts a line break within the same paragraph.

• Enter: Enter starts a new paragraph.
• Ctrl+Enter: Ctrl + Enter inserts a page break.
• Alt+Enter: Alt + Enter is not the line-break shortcut.

Correct answer: A red triangle on the right side of the cell. In Excel 2010, a small red triangle in the upper-right corner of a cell indicates a comment.

• Text on the left side of the cell: Comments are not shown on the left side of the cell.
• Text at the bottom of the cell: Comments are not shown at the bottom of the cell.
• Text in the formula: Comments are not part of the formula.

Correct answer: Data Tab > Sort & Filter. The Data tab’s Sort & Filter group contains the main sorting and filtering commands.

• Home Tab > Filter: The Home tab has a Sort & Filter menu in the Editing group, but the Data tab is where these commands are grouped.
• View Tab: The View tab changes display settings.
• Insert Tab: The Insert tab adds tables, charts, and pictures.

Correct answer: Letters A, B, C…. Excel columns are labelled with letters (A, B, C…), and rows with numbers.

• Numbers: Numbers label rows.
• Symbols: Symbols are not used for column labels.
• Roman Numerals: Roman numerals are not used for column labels.

Correct answer: Home Tab > Sort (A to Z or Z to A). The Sort button is in the Paragraph group of the Home tab.

• Insert Tab > Sort: The Insert tab does not contain the Sort command.
• Review Tab > Sort: The Review tab does not contain the Sort command.
• View Tab > Sort: The View tab does not contain the Sort command.

Correct answer: Word Wrap. Word wrap automatically continues text on the next line at the margin.

• Line Break: A line break is inserted manually.
• Justify: Justify spaces text to align both margins.
• Align: Align positions text left, right, or centre.

Correct answer: Animation. The Animations tab applies animation effects to objects.

• Design: The Design tab applies themes and backgrounds.
• Transition: The Transitions tab applies effects when moving between slides.
• View: The View tab changes how the presentation is displayed.

Correct answer: Slide Sorter View. Slide Sorter view shows all slides as thumbnails so they can be rearranged.

• Normal View: Normal view shows one slide for editing.
• Outline View: Outline view shows the text of the slides.
• Notes View: Notes view shows a slide with its speaker notes.

Correct answer: Slide Sorter View. Slide Sorter view displays many slides at once as thumbnails.

• Reading View: Reading view shows the presentation one slide at a time in the window.
• Normal View: Normal view edits one slide at a time.
• None of these: “None of these” is incorrect because Slide Sorter view is correct.

Correct answer: 10%–500%. MS Word allows zoom from 10% to 500%.

• 10%–300%: 300% is below Word’s maximum.
• 5%–200%: 5%–200% does not match Word’s range.
• 1%–1000%: 1%–1000% does not match Word’s range.

Correct answer: Slide Show View. Slide Show view displays each slide full-screen for presenting.

• Normal View: Normal view is the editing view.
• Outline View: Outline view shows the slide text.
• Notes View: Notes view shows speaker notes.

Correct answer: NOW(). NOW() returns the current date and time.

• DATE(): DATE() builds a date from year, month, and day values.
• TIME(): TIME() builds a time from hour, minute, and second values.
• TODAY(): TODAY() returns only the current date.

Correct answer: Print Preview. Print Preview shows how the document will look on paper before printing.

• Save: Save stores the file and does not show print output.
• Page Setup: Page Setup sets margins and size but does not show the final result.
• Print Properties: Print Properties are printer-specific settings.

Correct answer: Count cells containing numbers. COUNT counts the cells in a range that contain numbers.

• Sum cells: SUM adds the values.
• Find average: AVERAGE finds the mean.
• Find maximum: MAX finds the maximum.

Correct answer: LAN. A LAN (Local Area Network) covers a small area such as a room, building, or campus.

• WAN: A WAN covers large areas such as countries.
• MAN: A MAN covers a city.
• PAN: A PAN covers a person’s immediate surroundings (a few metres).

Correct answer: COUNT. COUNT counts only cells that contain numbers.

• COUNTA: COUNTA counts all non-empty cells, including text.
• COUNTBLANK: COUNTBLANK counts empty cells.
• COUNTIF: COUNTIF counts cells that meet a condition.

Correct answer: F5. F5 starts the slideshow from the first slide.

• F4: F4 repeats the last action.
• F7: F7 starts the spelling check.
• Ctrl+F5: Ctrl + F5 is not the standard key to start the slideshow from the beginning.

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.