PPSC Past Papers & Solved MCQs

The question asks to identify the type of software that organizes data into rows and columns. Different software applications are designed for specific data handling and presentation tasks.

The correct answer is C: Spreadsheet. Spreadsheet software, such as Microsoft Excel or Google Sheets, is specifically engineered to create, organize, analyze, and store data in a tabular format. This format inherently consists of a grid of rows and columns, with individual data points entered into cells at their intersections. Spreadsheets are widely used for financial calculations, data tracking, and various analytical tasks due to their structured layout and powerful functions.

• A: Database software manages large, structured collections of data, often using tables with rows and columns, but the software itself is not *called* 'rows and columns'; it's a system for data management.
• B: Drawing software (e.g., Adobe Illustrator, Paint) is used for creating and editing visual graphics and images, not for tabular data organization.
• D: Word Processing software (e.g., Microsoft Word) is designed for creating and editing text documents, focusing on text formatting, layout, and content, not structured data in rows and columns.

Thus, software built around the row-and-column structure is precisely what defines a spreadsheet application.

In word processing and document navigation, various keyboard shortcuts allow users to move the cursor efficiently through a document. The Ctrl + Page Down shortcut is specifically designed to move the cursor to the beginning of the next logical page or the next full screen of content within the document. This is incredibly useful for quickly navigating through lengthy documents without having to scroll manually. While 'one screen down' might seem similar, 'one page down' more accurately reflects the typical behavior of this command, which often respects actual page breaks. The other options are incorrect: Moving 'one line down' is achieved by pressing the Down Arrow key. Moving 'one paragraph down' is typically done using Ctrl + Down Arrow. Therefore, Ctrl + Page Down is the precise command for advancing the cursor by one full page.

The question concerns the method to completely close or exit the PowerPoint application window. Understanding the difference between closing a document and closing the application is crucial in Windows environments.

The correct answer is B: Double-click the application’s control menu icon. In Windows, every application window has a control menu icon (usually a small program icon) located at the top-left corner of the window title bar. Double-clicking this icon is a standard and quick method to send a 'close' command to the entire application, effectively shutting down PowerPoint and all its open presentations.

• A: Document close button (the 'X' on the document window) typically closes only the currently active presentation file, leaving the PowerPoint application itself running.
• C: Double-click the document control menu icon would also only close the current presentation, not the entire PowerPoint application.
• D: Minimize button (the underscore symbol) reduces the application window to the taskbar, keeping PowerPoint running in the background but not exiting it.

Therefore, to fully exit the PowerPoint program, double-clicking the application's control menu icon is the correct action.

The question asks which menu in Excel is used to remove duplicate values. Microsoft Excel organizes its functionalities into various tabs on the Ribbon interface, each grouping related commands for specific tasks.

The correct answer is A: Data. The 'Data' tab on the Excel Ribbon is specifically dedicated to tools for managing, analyzing, and manipulating data within a worksheet. This tab contains commands for sorting, filtering, data validation, text to columns, and importantly, the 'Remove Duplicates' feature. This tool allows users to quickly identify and eliminate redundant entries from a selected range or table, which is essential for data cleaning and ensuring data integrity.

• B: Tools is incorrect. While older versions of Excel might have had a 'Tools' menu, modern Excel uses the Ribbon interface, and 'Tools' is not a standard tab for this function.
• C: Formatting is incorrect. The 'Formatting' commands (found primarily on the 'Home' tab) deal with the appearance of cells and data, such as fonts, colors, and borders, not with the structural manipulation or removal of data entries.
• D: Layout is incorrect. The 'Page Layout' tab is primarily concerned with page setup options for printing, including margins, orientation, and themes, not with data cleaning or manipulation.

Thus, for tasks involving data management like removing duplicates, the 'Data' tab is the appropriate menu.

In presentation software like Microsoft PowerPoint, various features enhance the visual appeal and engagement of slides. The feature that applies motion effects to individual slide objects (such as text, images, charts, or shapes) is called Animation Objects, or simply 'Animations.' These effects control how specific elements appear on, move within, or disappear from a slide, adding dynamic movement and drawing attention to key information. For example, text can fly in, or an image can zoom. The other options are distinct features: Animation Schemes are predefined sets of animations that apply to an entire slide's content, offering a quick way to animate multiple objects together. Slide Transition refers to the visual effect that occurs when you move from one slide to the next during a presentation. Slide Design refers to the overall visual theme, layout, and background of the slides, not individual object motion.

Understanding keyboard shortcuts is crucial for efficient computer usage, especially in applications like Microsoft Word. The question asks for the shortcut to open a new document.

• Ctrl + N is the correct answer. This shortcut is universally recognized across many applications, including MS Word, for creating a new, blank document. The 'N' stands for 'New'.
• Ctrl + C is incorrect. This shortcut is used to 'Copy' selected text or objects.
• Ctrl + W is incorrect. This shortcut is typically used to 'Close' the currently active document or window.
• Ctrl + T is incorrect. In MS Word, Ctrl + T is used to create a 'Hanging Indent' for a paragraph, while in web browsers, it often opens a 'New Tab'. It does not open a new document.

Therefore, to quickly start a fresh document in MS Word without navigating through menus, 'Ctrl + N' is the go-to command.

In modern versions of Microsoft PowerPoint (2007 and later), a new slide is inserted by selecting Home → New Slide. Users can also press the keyboard shortcut Ctrl + M, which is the quickest way to add a new slide.

In older versions of PowerPoint (2003 and earlier), the option Insert → New Slide was commonly used.

Correct Answer: Home → New Slide

Excel's 'Split Window' feature is incredibly useful for viewing different sections of a large worksheet simultaneously, allowing users to keep headers or specific data visible while scrolling through other parts. The question asks for the correct path to access this feature in Excel 2016.

• The correct option is View → Window → Split. In Excel 2016 and subsequent versions, the 'Split' command is located under the 'View' tab on the Ribbon, within the 'Window' group. Clicking this command divides the worksheet window into separate panes, which can be scrolled independently.
• 'Format → Window → Split' is incorrect. The 'Format' tab primarily deals with formatting cells, rows, columns, and objects, not window management.
• 'Page Layout → Split' is incorrect. The 'Page Layout' tab is dedicated to settings related to printing, such as margins, orientation, and page breaks, not splitting the view of the worksheet.

By using the 'View' tab, users can manage how their worksheet is displayed, including options like splitting, freezing panes, and arranging windows.

The terms 'shimmer,' 'sparkle text,' and 'blinking background' refer to dynamic visual enhancements applied to elements within a digital document or presentation, particularly in software like Microsoft PowerPoint. These are not just static styles but involve animation or special rendering to create a distinct visual effect.

The correct answer is A: Text effects. While 'blinking background' isn't strictly a text effect, the question groups it with 'shimmer' and 'sparkle text,' which are quintessential text effects. 'Text effects' is the most encompassing term among the choices for these types of decorative and often animated visual styles applied to text, including glow, reflection, shadow, and various animations.

• B: WordArt is a specific feature in Microsoft Office that allows users to create stylized text with predefined designs (e.g., curved, shadowed, 3D), but it's a tool for creating text, not the general category for all visual embellishments.
• C: Font Styles refer to basic text attributes like bold, italic, underline, or different font families (e.g., Arial, Times New Roman), which are about the fundamental appearance of the font, not dynamic visual effects.
• D: Font Effects is very similar to 'Text effects,' but 'Text effects' is often used in modern software to describe a broader range of advanced visual treatments and animations beyond basic font attributes.

Keyboard shortcuts are essential tools for efficient navigation and productivity in word processing and other software applications. They allow users to perform actions quickly without relying on a mouse.

The correct answer is A: Beginning of Document. The "Ctrl + Home" shortcut is a universal command in most text editors and word processors, including Microsoft Word. When pressed, it immediately moves the cursor to the very first character or position at the absolute start of the entire document, regardless of where the cursor is currently located within the text. This is incredibly useful for quickly reviewing or editing the initial parts of a long file.

Let's look at why the other options are incorrect. Beginning of Line (B) is typically achieved by pressing the "Home" key alone, without the "Ctrl" modifier. Beginning of Paragraph (C) does not have a standard, universal shortcut like "Ctrl + Home"; cursor movement within paragraphs is usually managed with arrow keys or mouse clicks. Beginning of Page (D) is also incorrect; "Ctrl + Home" specifically targets the document's start, not just the start of the current page, which might be achieved through scrolling or other navigation methods.

Keyboard shortcuts are invaluable for efficient navigation and editing in word processors, text editors, and other applications. The `Ctrl` key, when combined with arrow keys, typically modifies their default behavior to move the cursor in larger increments.

The correct answer is A: Move the cursor one word right. When you press `Ctrl + Right Arrow`, the cursor jumps to the beginning of the next word to the right. This shortcut is a standard feature across most operating systems and text-editing applications, significantly speeding up text navigation.

• B: Move the cursor to end of the line is achieved by pressing the `End` key (or `Fn + Right Arrow` on some compact keyboards).
• C: Move the cursor to end of the document is accomplished by pressing `Ctrl + End`.
• D: Move the cursor one paragraph down is performed using `Ctrl + Down Arrow`, which moves the cursor to the beginning of the next paragraph.

Understanding these shortcuts can greatly enhance productivity when working with text.

In file management, understanding the distinction between 'Save' and 'Save As' is fundamental. The question asks for the command used to save a file with a new name.

• Save As is the correct answer. This command is specifically designed to save an existing file under a different name, in a new location, or in a different file format. It creates a new copy of the document, leaving the original file unchanged. This is crucial for version control or creating templates.
• 'Save' is incorrect. The 'Save' command typically overwrites the existing file with the current changes. If it's a new, unsaved file, it will prompt for a file name and location, but for an already saved file, it doesn't offer the option to change the name directly without additional steps.
• 'Copy' is incorrect. 'Copy' is used to duplicate selected content (text, images, etc.) within a document or application, not to save an entire file with a new name.
• 'Paste' is incorrect. 'Paste' is used to insert content that has been previously copied or cut.

Therefore, when you need to preserve the original file while creating a modified version, 'Save As' is the appropriate command.