PPSC Past Papers & Solved MCQs

Microsoft Word provides various document views to help users work on different aspects of their documents, from content creation to final presentation. These views change how the document appears on screen without altering the actual content.

• The correct answer is Five. MS Word typically offers the following main views:
  • Print Layout
  • Read Mode (or Full Screen Reading)
  • Web Layout
  • Outline
  • Draft
• The other options (Two, Three, Four) are incorrect as they do not account for all the standard document views available in Microsoft Word.

Keyboard shortcuts are essential for efficient navigation and window management in applications like Microsoft Excel. Minimizing a window helps in managing screen space and focusing on other tasks.

• Ctrl + F9 is the correct keyboard shortcut used to minimize the active workbook window in Microsoft Excel. This action minimizes the specific workbook within the Excel application frame, not the entire Excel application to the taskbar.
• Ctrl + F8 is used for resizing the window.
• Ctrl + F10 is used to maximize or restore the window.
• Ctrl + F11 is used to insert a macro sheet.

Sorting data is a fundamental function in Microsoft Excel, allowing users to organize information in a meaningful order. This organization can be based on text, numbers, or dates.

• Ascending Order is the correct term for sorting data from A to Z. This means arranging text alphabetically from A to Z, numbers from smallest to largest, and dates from oldest to newest.
• Descending Order is the opposite, sorting from Z to A or largest to smallest.
• Filtering hides data that does not meet specific criteria, rather than reordering it.
• Custom Sorting allows users to define their own specific sort orders, but A-Z is a standard ascending sort.

The correct answer is 1,048,576. This represents the maximum number of rows available in a Microsoft Excel worksheet for versions from Excel 2007 onwards. Understanding these limits is fundamental for effective data management in spreadsheets.

• 65,536 was the row limit for older versions of Excel, specifically Excel 2003 and earlier, making it a common distractor for those familiar with older software.
• 104,857 and 16,384 are incorrect values and do not correspond to any standard Excel row limits.

Modern Excel versions significantly expanded capacity to handle more extensive datasets.

The correct answer is Office Vista. This is not a valid version of Microsoft Office. It's crucial to differentiate between Microsoft's operating systems and its application suites.

• Office 2003, Office 2007, and Office 2016 are all legitimate and widely recognized versions of the Microsoft Office suite, each released in their respective years with new features and improvements.
• Vista, however, refers to Windows Vista, which was an operating system released by Microsoft, not a productivity suite like Office.

Microsoft Office versions are typically named by their release year, not by operating system names.

The correct answer is Theme. In PowerPoint, a theme is a predefined set of colors, fonts, and visual effects that you can apply to your slides to give them a unified, professional, and consistent look. It's a foundational concept for creating polished presentations.

• Design is the tab in PowerPoint where you typically find the options to apply themes, but it's not the theme itself.
• Animation refers to the movement effects applied to objects or text on a slide, not the overall visual style.
• Layout defines the arrangement of placeholders on a slide, such as title, content, or picture placeholders, but doesn't include colors or fonts.

The correct answer is Raised. This option is not a type of character spacing. Character spacing refers to the horizontal distance between characters in a text block.

• Expanded character spacing increases the space between characters, making the text appear wider.
• Condensed character spacing decreases the space between characters, making the text appear narrower.
• Raised, on the other hand, refers to the vertical positioning of text, moving it slightly above the baseline, similar to a superscript effect, rather than adjusting the horizontal space between characters.

Understanding these distinctions is key for precise text formatting.

The correct answer is = (equals sign). In Microsoft Excel, every formula must begin with an equals sign. This fundamental rule signals to Excel that the cell contains a calculation to be performed, rather than just text or a number.

• + (plus sign) can be used within a formula for addition, but it cannot initiate a formula on its own.
• $ (dollar sign) is used for absolute cell referencing, fixing a row or column reference when copying formulas, but it doesn't start a formula.
• @ (at symbol) is not typically used to start a standard Excel formula; it's more common in some programming contexts or specific Excel functions like structured references in tables.

The correct answer is Title Bar. The title bar is a standard graphical user interface element located at the very top of most application windows. Its primary function is to display the name of the open document or program, providing immediate context to the user.

• The Menu Bar is typically located below the title bar and contains drop-down menus (e.g., File, Edit, View) for accessing commands.
• The Status Bar is found at the bottom of a window and displays information about the current state of the program or document.
• The Tool Bar (or Ribbon in modern applications) contains buttons and icons for quick access to frequently used commands.

In spreadsheet applications like MS Excel, the fundamental unit where data is entered is called a Cell. It represents the intersection of a specific row and a specific column, uniquely identified by its address (e.g., A1, B5). This is where all data, formulas, and functions reside.

• Option A, "Box," is too generic and not the precise term used in spreadsheets.
• Option B, "Field," is typically used in database contexts to refer to a category of information.
• Option D, "Sheet," refers to the entire grid of cells, which is the complete workspace, not the individual intersection.

The keyboard shortcut Alt + = is used in Excel to quickly create a formula that sums all the cells directly above the active cell. This feature, known as AutoSum, automatically inserts the SUM function and selects the most probable range of cells to be summed, saving time and effort.

• Alt + S is not a standard shortcut for AutoSum in Excel.
• Ctrl + = is typically used for subscript formatting in some applications, not for summing cells in Excel.
• Shift + = is used to type the equals sign, which is the starting character for any formula in Excel, but it does not automatically insert the SUM function or select a range.

Gmail, Hotmail (now Outlook.com), and Yahoo Mail are all prominent examples of Email servers. These services provide the infrastructure for sending, receiving, and storing electronic mail messages for users. They host user accounts and manage the communication protocols necessary for email exchange.

• Option A, "Search engines" (like Google Search or Bing), are used to find information on the internet.
• Option B, "Web browsers" (like Chrome or Firefox), are software applications used to access and view websites.
• Therefore, "None of these" is incorrect as "Email servers" accurately describes them.

The Protect Document option in MS Word is found within the Review tab of the Ribbon. This tab is dedicated to tools for collaboration, proofing, tracking changes, and ensuring document security and integrity, making it the logical place for protection features.

• The Home tab contains basic editing, formatting, and styling options.
• The References tab is used for managing citations, bibliographies, tables of contents, and indexes.
• The term "Edit" is not a standalone tab in the Ribbon; editing functionalities are distributed across various tabs, primarily the Home tab.

Shimmer, Sparkle text, and Blinking Background are all visual enhancements applied to text or backgrounds to make them more dynamic or attention-grabbing. These are collectively known as Text effects. They go beyond basic formatting to add animation or special visual properties.

• Option A, "WordArt," is a specific feature for creating stylized text, but these are broader effects.
• Option B, "Font styles," refers to basic formatting like bold, italic, or underline, not animations.
• Option D, "Badge," is unrelated and typically refers to a small graphic or icon.

The functions of Copy and Paste are essential for duplicating or moving content within a document or between applications. In MS Word, these functions, along with Cut, reside in the Clipboard group on the Home tab. The Clipboard acts as a temporary storage area for the copied or cut content.

• Option A, "Home," is the tab itself, not the specific group.
• Option B, "Paragraph," is a group for paragraph-level formatting.
• Option C, "Style," is a group for applying predefined text styles.

Cookies in a web browser are small text files stored on a user's device by websites they visit. Their primary purpose is Storing user data and preferences. This allows websites to remember information about the user, such as login status, shopping cart contents, or personalized settings, for a more convenient browsing experience.

• Option A, "Cleaning the browser cache," is incorrect; cookies are distinct from the cache.
• Option B, "Displaying advertisements," is a secondary use by advertisers, not the fundamental function of cookies themselves.
• Option D, "Blocking pop-ups," is a browser setting, not a function of cookies.

To apply the formatting of one section or object to another without copying the actual text, the correct tool to use is the Format Painter. This tool allows you to copy only the formatting attributes (like font, size, color, paragraph spacing) and apply them elsewhere.

• Option A, "Copy-Paste," copies both the content and its formatting.
• Option C, "Format Text Box," is specific to the properties of a text box, not general formatting transfer.
• Option D, "Page Setup," is used for configuring page layout, margins, and orientation, not for copying formatting between elements.

The World Wide Web (WWW) is a system of interlinked hypertext documents accessed via the Internet. Its primary function is to access and share information globally through web browsers.

• "Sending e-mails" (A) is a function of email protocols (like SMTP, POP3, IMAP), not the WWW itself, although email clients can be accessed via the web.
• "File printing" (B) is a local or network printer function, not directly related to the WWW's core purpose.
• "Operating system functions" (D) refer to the core tasks managed by an OS (e.g., memory, process, file management), which are distinct from the WWW's role as an information system.

Graphics typically consume the most memory because they are composed of many individual pixels, each requiring data to define its color and intensity. High-resolution images or complex 3D models contain vast amounts of pixel data, leading to significant memory usage.

• "Text" (A) and "Numbers" (B) are represented by character codes (e.g., ASCII, Unicode) or numerical formats, which are very compact.
• "Symbols" (D) are also character-based and require minimal memory, similar to text. The complexity and detail of graphical data far exceed that of simple textual or numerical representations.

The primary function of the Windows Task Manager is process and resource management. It allows users to monitor running applications, processes, and services, view system performance (CPU, memory, disk, network usage), and manage startup programs. Users can also end unresponsive tasks.

• "File management" (A) is handled by File Explorer.
• "System configuration" (B) is typically done through the Control Panel or Settings app.
• "Disk cleanup" (D) is a utility specifically designed to free up disk space, not the main role of Task Manager.

In many typical LAN systems, especially client-server architectures, the operation mainly depends on the server. The server provides centralized resources, services, and data to client nodes, managing network access, security, and shared applications. Without a server, many network functions would be unavailable or decentralized.

• A "Node" (A) is any device connected to the network, but it doesn't dictate the network's overall operation.
• A "Hub" (B) is a basic networking device that connects multiple devices, but it's a passive component and doesn't manage operations like a server. Modern LANs often use switches instead of hubs.
• A "Ring" (D) refers to a network topology, not a device that dictates operation. While a ring topology connects devices, the server still provides the core services.

In Microsoft Word, the keyboard shortcut Shift + F3 is used to cycle through different text cases for selected text: Sentence case, lowercase, and UPPERCASE. This is a highly efficient way to adjust text formatting without using the mouse.

• "Ctrl + Shift + A" (A) is used to toggle all caps for selected text.
• "Ctrl + F3" (C) is used to cut selected text to the Spike (a special clipboard).
• "Alt + F3" (D) is used to create a new building block from selected text. Therefore, Shift + F3 is the specific shortcut for changing case cyclically.

In Microsoft Excel, a range refers to a collection of two or more cells. It is typically represented by the cell address of the top-left cell, followed by a colon, and then the cell address of the bottom-right cell. Therefore, B1:B2 correctly denotes a range encompassing cells B1 and B2.

• "A1" (A) represents a single cell, not a range.
• "#REF!" (B) is an error message indicating an invalid cell reference.
• "100" (D) is a numerical value, not a cell reference or a range. Understanding ranges is fundamental for performing calculations and applying formatting to multiple cells simultaneously.

Kerning is a fundamental typographic concept that involves adjusting the space between specific pairs of characters to achieve a visually pleasing and evenly spaced appearance for an entire word. This feature is crucial for professional document presentation, preventing awkward gaps or overlaps between letters like "VA" or "To".

• Spacing is a general term for the distance between elements, not specifically character pairs for visual balance.
• Positioning refers to the placement of text blocks or objects on a page, not the fine-tuning of space between individual characters.
• Scaling involves changing the overall size of characters or objects, rather than their inter-character spacing.

The process of arranging data in a logical sequence, such as alphabetical, numerical, or chronological order, is known as Sorting. This is a core data management function that helps in organizing and analyzing information efficiently.

• Filtering involves displaying only the data that meets specific criteria, hiding the rest, but it does not rearrange the order of the data.
• Grouping organizes data into categories based on common attributes, but it doesn't necessarily sequence the entire dataset in a logical order.
• Formatting refers to changing the appearance of data, such as font, color, or cell borders, without altering its underlying order or content.