FPSC Information Technology Mcqs

In spreadsheet applications like Excel, the worksheet is structured as a grid to organize data efficiently. To uniquely identify each cell, a coordinate system is used, where columns and rows are labeled distinctly. This labeling system is fundamental for creating cell references in formulas and navigating the worksheet.

• B: Letters is the correct answer. Columns in Excel are labeled alphabetically (A, B, C, ..., Z, AA, AB, etc.) across the top of the worksheet. This convention allows for easy identification and referencing of vertical data sets.
• A: Numbers are used to label rows, not columns.
• C: Symbols are not used for labeling columns in standard spreadsheet software.
• D: Both letters and numbers combine to form a cell address (e.g., A1), but columns themselves are labeled solely with letters.

The question asks about the small, high-speed memory located directly within the CPU. Understanding different memory types and their proximity to the CPU is crucial.

• Registers are the correct answer. They are the smallest and fastest memory components, integrated directly into the CPU. Registers hold data and instructions that the CPU is actively processing, enabling extremely quick access for computations.
• Hard Disk is incorrect because it is a large-capacity, non-volatile storage device located external to the CPU, used for long-term data storage, and significantly slower than CPU-internal memory.
• RAM (Random Access Memory) is also incorrect. While faster than a hard disk, RAM is main memory, located on the motherboard, and serves as a temporary workspace for the CPU, but it is not *inside* the CPU itself and is slower than registers.
• ROM (Read-Only Memory) is incorrect. ROM is non-volatile memory primarily used for storing firmware (like the BIOS) and is much slower than registers, not located within the CPU for active data processing.

Therefore, registers are uniquely positioned for immediate, high-speed data access by the CPU.

Keyboard shortcuts are essential for efficient computer usage. The universal shortcut used to "Undo" the last action in most applications, including MS Word, is Ctrl + Z. This command reverses the most recent change, allowing users to correct mistakes or revert to a previous state of their work.

• Ctrl + Y is commonly used for "Redo," which reverses an "Undo" action, reapplying a change that was previously undone.
• Ctrl + A is used to "Select All" content within the active document or window, highlighting everything for further action.
• Ctrl + X is the shortcut for "Cut," which removes the selected content from its current location and places it onto the clipboard, ready to be pasted elsewhere.

The Tab key serves multiple functions in word processing, particularly when working with tables. Its primary role is to navigate between cells, but its behavior changes significantly when pressed in the very last cell of a table.

• The correct answer is Insert a new row. This is a convenient feature in applications like Microsoft Word. When your cursor is in the final cell of a table and you press the Tab key, the software automatically creates a brand new row at the bottom of the table and places the cursor in the first cell of this newly added row, streamlining data entry.
• Delete the row is incorrect; deleting a row requires a specific command, not the Tab key.
• Move to the next cell is what the Tab key typically does within a row, but once you're in the last cell of the entire table, there is no "next cell" within the existing structure.
• Close the document is an unrelated action, usually performed via the File menu or a specific keyboard shortcut like Alt+F4.

PowerPoint offers various views to help users efficiently create, organize, and present their slides. Understanding these views is fundamental to navigating the software effectively. The Normal View is the primary editing interface, displaying the slide, outline/thumbnails, and notes pane. The Outline View focuses on the text content, allowing for easy organization of bullet points and headings. The Reading View presents the slideshow in a window, ideal for reviewing without full-screen projection. However, Page Layout View is NOT a valid PowerPoint view. This view is a feature commonly found in word processing applications like Microsoft Word, where it's used for arranging text and objects on a page for printing purposes, focusing on margins and page breaks. PowerPoint does not utilize a "Page Layout View" for its slide-based presentations.

Spreadsheet programs like Excel organize data in a grid, using a coordinate system to identify each individual cell. This system relies on distinct labels for both columns and rows, which are crucial for navigation and for constructing cell references in formulas.

• C: Numbers is the correct answer. Rows in Excel are labeled sequentially with numbers (1, 2, 3, and so on) down the left side of the worksheet. This numerical labeling, combined with the alphabetical column labels, forms the unique address for every cell (e.g., A1, B5).
• A: Letters are used to label columns, not rows.
• B: Symbols are not used for labeling rows in standard spreadsheet software.
• D: Roman numerals are a type of number, but they are not the standard convention used for labeling rows in Excel; Arabic numerals are used.

This question focuses on the specific device used to bridge the gap between a computer's digital signals and an analog telephone line for dial-up internet.

• Modem is the correct answer. A modem (short for MOdulator-DEModulator) is essential for dial-up connections. It converts the digital signals from your computer into analog signals that can be transmitted over a telephone line (modulation) and converts incoming analog signals back into digital signals for the computer to understand (demodulation).
• Router is incorrect. A router connects multiple networks and typically works with broadband internet connections (like DSL or cable), distributing network access to multiple devices. It does not directly connect to a telephone line for dial-up.
• Switch is incorrect. A switch is a networking device that connects multiple devices within a local area network (LAN), allowing them to communicate with each other. It does not handle the conversion for telephone lines.
• Repeater is incorrect. A repeater is used to extend the range of a network signal by regenerating it, but it does not perform the digital-to-analog conversion required for dial-up internet over telephone lines.

The modem's unique modulation/demodulation function is critical for dial-up internet.

Keyboard shortcuts significantly enhance productivity in applications like MS Word. Pressing Ctrl + B in MS Word is the standard shortcut to apply or remove bold formatting to the selected text. This allows users to quickly emphasize words or phrases without navigating through menus.

• Opening a new document is typically done with the shortcut Ctrl + N.
• Saving the document is performed using the shortcut Ctrl + S.
• Closing the document is commonly achieved with Ctrl + W (or Alt + F4 to close the application itself).

Therefore, Ctrl + B is specifically designed for text styling, making selected text bold or unbolding it.

The "Find and Replace" feature is an indispensable tool in word processing, allowing users to efficiently locate specific text strings and substitute them with different text throughout an entire document. This feature is typically grouped with other common editing functions.

• The correct answer is the Home tab. In applications like Microsoft Word, the "Replace" command (often found alongside "Find") is located within the "Editing" group on the Home tab. This tab is designed to house the most frequently used tools for basic document creation, editing, and formatting.
• The Insert tab is used for adding various elements such as tables, pictures, shapes, and headers/footers, not for text replacement.
• The Design tab focuses on document themes, colors, fonts, and page backgrounds.
• The Layout tab deals with page setup options, including margins, orientation, columns, and page breaks. Therefore, the Home tab is the appropriate location for the "Replace" feature.

In Microsoft PowerPoint, the ribbon interface organizes commands into logical tabs, making it intuitive to find specific functions. When you want to bring external content into your presentation, the Insert tab is the correct destination. This tab is specifically designed for adding various elements such as pictures, shapes, tables, charts, text boxes, and crucially, media clips like sound and video files. The Home tab is for basic editing and formatting, while the Design tab is for applying themes and background styles. The Animations tab is used for applying motion effects to objects already on a slide, not for inserting new media. Therefore, to add a sound or video clip, you must navigate to the Insert tab.

Spreadsheet software provides various functions to analyze and summarize data within a range of cells. One common analytical task is to determine how many cells within a specified range contain numerical values, which is distinct from summing the values or counting all non-empty cells.

• A: COUNT is the correct function. The COUNT function specifically counts the number of cells in a range that contain only numerical values. It ignores empty cells, text, logical values (TRUE/FALSE), and error values.
• B: COUNTA is incorrect because it counts all non-empty cells, including those with text, numbers, logical values, and error values.
• C: COUNTBLANK is incorrect as it counts the number of empty cells within a specified range.
• D: SUM is incorrect because it calculates the total sum of numbers in a range, rather than counting the cells that contain numbers.

Computers are categorized based on their size, processing power, and intended use. This question asks for the classification of a single-user computer like a PC.

• Microcomputer is the correct answer. Microcomputers are personal computers (PCs) designed for individual use. They are characterized by their use of a microprocessor as their central processing unit and are common in homes, offices, and schools for general-purpose tasks.
• Mainframe is incorrect. Mainframes are large, powerful computers used by large organizations (e.g., banks, government agencies) to process vast amounts of data and support hundreds or thousands of users simultaneously.
• Supercomputer is incorrect. Supercomputers are the most powerful and fastest computers, designed for highly complex scientific and engineering calculations, such as weather forecasting or nuclear research, not for single-user general computing.
• Minicomputer is incorrect. Historically, minicomputers were mid-range computers, larger and more powerful than microcomputers but smaller than mainframes. They were often used by small to medium-sized businesses and could support multiple users, but they are not typically classified as single-user PCs.

The term 'microcomputer' accurately reflects the personal, single-user nature of a PC.

The space around the printed area of a page (top, bottom, left, right) is called: Margin. Margins are the essential blank spaces that frame the content on a page, defining the boundaries for text and images. They are crucial for ensuring readability, providing a professional appearance, and allowing for binding or handling without obscuring content. Without margins, text would extend to the very edge of the paper, making it difficult to read and aesthetically unpleasing. In contrast, a Header is text or graphics appearing at the top of every page, within the top margin. Indentation refers to the space added to the beginning of a line or paragraph, pushing text inward from the margin, not the overall page boundary. A Footer is similar to a header but appears at the bottom of every page, within the bottom margin. Therefore, 'Margin' correctly identifies the unprinted area surrounding the entire content.

File extensions are crucial for identifying the type of a file and the software program associated with it. Each major Microsoft Office application uses a distinct default file extension for its native documents.

• The correct answer is .pptx. For PowerPoint 2007 and all subsequent versions, including PowerPoint 2019, the default file extension for a standard presentation is .pptx. The 'x' denotes that it is an XML-based file format, offering advantages like smaller file sizes and improved data recovery compared to the older .ppt format.
• .docx is the default file extension for Microsoft Word documents.
• .xlsx is the default file extension for Microsoft Excel spreadsheets.
• .pdf stands for Portable Document Format, a universal file format used for presenting documents independently of application software, hardware, or operating systems. It is not the native default extension for a PowerPoint presentation.

Slide orientation refers to the layout of a slide, determining whether it is taller than it is wide (portrait) or wider than it is tall (landscape). PowerPoint presentations are primarily designed for display on screens, such as computer monitors, projectors, or televisions. These display devices are almost universally wider than they are tall. Consequently, by default, slides in a PowerPoint presentation are oriented in a Landscape layout. This maximizes the usable screen area and provides a natural viewing experience for audiences. Portrait orientation is common for printed documents but not for digital presentations. Thumbnail refers to a small preview image, and Wide describes an aspect ratio, not the fundamental orientation.

This question tests knowledge of a fundamental component within a computer's Central Processing Unit (CPU).

• Arithmetic Logic Unit is the correct full form of ALU. The ALU is a crucial part of the CPU responsible for executing all arithmetic operations (like addition, subtraction, multiplication, and division) and logical operations (such as AND, OR, NOT, and comparisons). It is where the actual computation and decision-making within the computer take place.
• Array Logic Unit is incorrect. While 'array' is a term used in computing, it does not represent the 'A' in ALU.
• Application Logic Unit is incorrect. 'Application' refers to software programs, not a core hardware component of the CPU.
• Arithmetic Local Unit is incorrect. While 'arithmetic' is correct, 'local' is not the correct term for the 'L' in ALU; it should be 'Logic'.

Understanding the function of the ALU as the 'brain' for calculations and logical decisions is key to knowing its full form.

Page orientation dictates how a document is displayed or printed relative to its dimensions. The question asks for the orientation where the page is wider than it is tall. The correct answer is Landscape. In landscape orientation, the page is rotated so its horizontal dimension is longer than its vertical dimension, making it ideal for displaying wide tables, charts, images, or presentations where horizontal space is prioritized. Conversely, Portrait is the standard orientation where the page is taller than it is wide, commonly used for letters and most documents. Book is not a standard page orientation setting; it typically refers to a document type or a layout option for printing multiple pages per sheet in a book-like format. Legal refers to a specific paper size (8.5 x 14 inches), not an orientation itself. Thus, 'Landscape' accurately describes the wider-than-tall page setup.

PowerPoint offers several different views, each optimized for specific tasks in the presentation creation process. Understanding these views helps users efficiently manage their slides.

• The correct answer is Slide Sorter view. This view is specifically designed to display all the slides in your presentation as miniature thumbnails. This visual layout makes it incredibly easy to reorder slides by dragging and dropping them, delete multiple slides at once, or apply transitions to several slides simultaneously, providing an excellent overview of your presentation's flow.
• Normal View is the primary editing view, showing one large slide for content creation and a smaller thumbnail pane for navigation.
• Reading View presents the slideshow in a window, allowing for easy review without the full-screen presentation tools.
• Outline View displays only the text content of your slides in an outline format, which is useful for structuring your content and checking the logical flow of your presentation, but not for visual reordering.

PowerPoint offers dynamic visual effects to enhance presentations and engage audiences. These effects are categorized based on their application. Animations are the individual motion effects applied to specific text blocks, images, shapes, or other objects *within a single slide*. They control how these elements appear, disappear, or move during the slide show, drawing attention to particular content. In contrast, Transitions are visual effects that occur *between slides* as you move from one to the next. Schemes, in older PowerPoint versions, referred to predefined color sets, not object effects. Presets are pre-configured settings, but the specific term for these individual object effects is animations.