FPSC Information Technology Mcqs

In a cell reference like $A$1, the dollar symbol ($) represents an absolute reference. An absolute reference locks either the column, the row, or both, so that when a formula containing this reference is copied to other cells, the locked part of the reference does not change. This is crucial for maintaining consistent references to specific cells in complex calculations.

• A relative reference (A) is incorrect; a relative reference (e.g., A1) changes when copied, adjusting based on its new position.
• A text string (B) is incorrect; while text can be in cells, the dollar sign here has a specific functional meaning in formulas.
• A currency value (D) is incorrect; although the dollar sign is a currency symbol, in the context of cell references, it denotes absolute referencing, not a currency format.

Upgrading a computer's RAM from 4 GB to 8 GB primarily benefits the system by allowing more programs to run simultaneously. RAM acts as a computer's short-term working memory, holding data and applications currently in use. With more RAM, the operating system has a larger temporary workspace, reducing the need to swap data to slower storage (like the hard drive). This significantly improves multitasking capabilities and overall system responsiveness when many applications are open.

• A: Faster processor speed is achieved by upgrading the CPU, not RAM.
• C: Larger files can be stored permanently is the function of permanent storage devices like HDDs or SSDs, not volatile RAM.
• D: Faster internet browsing is primarily dependent on internet connection speed and browser efficiency, not directly on RAM capacity.

The motherboard is the main printed circuit board found in general-purpose computers and other expandable systems. It is also commonly known as the System Board. This name reflects its central role as the primary hub that connects and allows communication between all the computer's essential components. It provides the electrical connections and communication pathways for the CPU, memory, storage devices, expansion cards, and other peripherals, enabling them to function together as a cohesive system.

• CPU Board (A) is incorrect because while the CPU is mounted on the motherboard, the motherboard encompasses much more than just the CPU.
• Memory Board (C) is incorrect; RAM modules are inserted into slots on the motherboard, but the motherboard itself is not solely dedicated to memory.
• Power Board (D) is incorrect; the power supply unit (PSU) provides power, and the motherboard distributes it, but it is not called a power board.

Microsoft Word's ribbon interface organizes commands into logical tabs. The question asks under which tab the "Insert Table" option is found.

• The Insert tab is the correct answer. This tab is specifically designed for adding various elements into a document that are not part of the main text flow. This includes tables, pictures, shapes, charts, headers, footers, page numbers, text boxes, and symbols. The "Table" group within this tab provides options to draw, insert, or convert text to a table.
• The Home tab is incorrect; it contains the most frequently used commands for basic editing, formatting, and styling, such as font, paragraph, and clipboard options.
• The Design tab is incorrect; it focuses on document themes, colors, fonts, and page backgrounds, affecting the overall aesthetic.
• The References tab is incorrect; it is used for academic features like citations, bibliographies, table of contents, and indexes.

Hence, for adding new objects like tables, the Insert tab is the designated location.

PowerPoint uses a structured approach for content placement to maintain consistency and ease of editing. In PowerPoint, objects such as text, charts, images, and tables are placed inside placeholders. Placeholders are pre-defined boxes on a slide layout that reserve a specific space for different types of content. They guide the user on where to add information, ensuring a consistent design and making it easier to organize content effectively within the slide's structure.

• Frames is a generic term and not the specific terminology PowerPoint uses for these content containers.
• Text Blocks is too specific, referring only to text, whereas placeholders accommodate various object types.
• Holders is a vague term and not the precise terminology used within PowerPoint for these content containers.

To find the largest number in a range of cells in Excel, you would use the MAX function. The MAX function is specifically designed to return the largest numerical value from a set of values or a specified range of cells. For instance, =MAX(A1:A10) will identify the highest number within that particular range.

• MIN (A) is incorrect; this function is used to find the smallest number in a range.
• LARGE (C) is incorrect; while LARGE(range, 1) would yield the same result, MAX is the direct and most common function for finding the absolute largest value.
• COUNT (D) is incorrect; this function counts the number of cells that contain numbers in a range, not their maximum value.

The characteristic being utilized by a supercomputer performing 10²⁰ calculations for weather forecasting is Diligence. Computers possess the ability to perform a vast number of operations or calculations consistently and tirelessly, without experiencing fatigue, boredom, or loss of concentration. This unwavering dedication to executing repetitive, complex tasks over extended periods without error is a hallmark of their diligence, making them ideal for intensive computational tasks like scientific simulations.

• A: Accuracy refers to the correctness of the results, not the ability to perform numerous tasks without tiring.
• C: Versatility describes a computer's capacity to perform a wide variety of different tasks.
• D: Storage refers to the capacity to hold data, which is essential but doesn't describe the act of tireless computation.

Understanding computer ports is fundamental to connecting peripherals. The Universal Serial Bus (USB) port is the correct answer because it is a versatile and widely adopted standard designed for connecting a broad range of peripheral devices, including mice, keyboards, printers, external storage, and more, to a computer. Its plug-and-play nature makes it incredibly convenient for users.

• HDMI (High-Definition Multimedia Interface) is primarily used for transmitting high-quality digital audio and video signals to displays like monitors, televisions, or projectors.
• VGA (Video Graphics Array) is an older analog interface specifically for video output to monitors.
• Ethernet ports (RJ-45) are used for wired network connections, enabling internet access or local area network communication, not for connecting input/output devices like mice or keyboards.

Efficient formatting is crucial in word processing. The question asks for the tool that copies formatting from one text to another.

• The Format Painter is the correct answer. This powerful tool allows users to quickly copy all formatting attributes (e.g., font type, size, color, bold, italics, paragraph alignment, line spacing) from a selected piece of text and apply them to other text selections. It ensures consistency across a document without manually reapplying each format.
• Clipboard is incorrect; the clipboard is a temporary storage area for cut or copied data, not a tool for applying formatting itself.
• Painter is too generic and not the specific name of the tool in common word processors.
• Style Copier is incorrect; while it describes the function, it is not the standard or recognized name for this feature in applications like Microsoft Word.

Therefore, for replicating formatting, the Format Painter is the precise tool.

PowerPoint offers master views to manage consistent elements across multiple slides efficiently. The most efficient method to ensure a company logo appears in the exact same position on all 50 slides is to insert the logo on the Slide Master. The Slide Master is the top-level slide in a hierarchy that controls the theme, layout, background, and common elements for all slides in a presentation. Any object placed on the Slide Master will automatically appear on every slide using that master, ensuring perfect consistency and saving significant time.

• Copy and paste logo to each slide is highly inefficient and prone to alignment errors for numerous slides.
• The Header and Footer dialog box is primarily for text-based headers, footers, dates, and slide numbers, not for positioning images like logos.
• Add logo to slide 1 and duplicate is less efficient than the Slide Master, as it doesn't apply the logo to existing slides without manual intervention or re-duplication.

In spreadsheet software like Microsoft Excel, data is organized in a grid structure. The fundamental unit for data entry within this grid is called a Cell. A cell is precisely defined as the intersection point where a column and a row meet. Each cell has a unique address, such as A1 or B5, formed by combining its column letter and row number.

• A: Cell is correct because it is the specific term for the intersection of a column and a row where data is stored.
• B: Sheet refers to an entire worksheet, which is a collection of many cells, not a single intersection.
• C: Box is a generic term and not the precise terminology used in spreadsheets for this element.
• D: Tab typically refers to the sheet tabs at the bottom of the workbook, used to navigate between different worksheets, or a key on the keyboard.

The characteristic of a computer that enables it to perform millions of calculations in a few seconds is Speed. Modern computer processors are designed to execute billions of instructions per second, allowing them to process vast amounts of data and perform complex computations with incredible rapidity. This high processing speed is fundamental to the efficiency and responsiveness of all computer operations, from simple tasks to demanding applications.

• A: Accuracy refers to the correctness and precision of the calculations, not how quickly they are performed.
• B: Diligence describes a computer's ability to perform tasks repeatedly without fatigue or error, regardless of the number of operations.
• C: Versatility refers to a computer's capacity to perform a wide range of different tasks, not the rate at which it performs them.

In the realm of computing, data is stored and processed in binary form. The smallest and most fundamental unit of data in a computer is a Bit. A bit is a binary digit, representing either a 0 or a 1. All other units of data are built upon this basic concept.

• A Byte is a collection of 8 bits. It is a common unit for representing a single character, such as a letter or a number.
• A Nibble is half a byte, consisting of 4 bits. While it exists, it's less commonly used in everyday computing discussions.
• A Word is a larger unit of data, typically 16, 32, or 64 bits, depending on the computer's architecture. It represents the amount of data a CPU can process at one time.

Therefore, the bit is the foundational building block for all digital information.

When pasting content from external sources, unwanted formatting is a common issue. The question asks which paste option removes this formatting to match the destination document.

• Keep Text Only is the correct answer. This paste option is designed to strip away all source formatting, including fonts, colors, hyperlinks, and styles, leaving only the plain text. The pasted text then automatically adopts the formatting of the destination document or the paragraph it's inserted into, ensuring a clean and consistent look.
• Keep Source Formatting is incorrect; this option retains all the original formatting from the website, which is precisely what the user wants to avoid.
• Merge Formatting is incorrect; this option attempts to combine the source formatting with the destination formatting, which can still result in mixed or undesirable styles, not a clean match.
• Picture is incorrect; this option pastes the content as an image, making it uneditable as text and unsuitable for integrating into a document as text.

Thus, to eliminate unwanted styles, "Keep Text Only" is the most effective paste option.

PowerPoint utilizes keyboard shortcuts to enhance productivity and provide quick access to common functions. Pressing Shift + F5 in PowerPoint is a crucial shortcut that will start the slideshow from the current slide. This allows presenters to quickly jump into presentation mode from any selected slide, which is incredibly useful for practicing specific sections or resuming a presentation after an interruption without having to navigate back to the beginning. This shortcut provides flexibility and control during both preparation and delivery.

• The standard shortcut for saving the presentation is Ctrl + S.
• The shortcut for printing the presentation is Ctrl + P.
• The shortcut for closing the presentation is Ctrl + W or Alt + F4 for the application. Shift + F5 has no relation to these functions.

Spreadsheet programs offer a wide array of built-in functions to perform various calculations efficiently. To determine the average of a set of numbers, a specific function is used that sums the values and then divides by the count of those values.

• C: AVERAGE is the correct function. This function is specifically designed to calculate the arithmetic mean of a range of numbers, providing the sum of the values divided by the number of values.
• A: SUM is incorrect because it calculates the total sum of a range of numbers, not their average.
• B: COUNT is incorrect as it counts the number of cells in a range that contain numbers, but does not perform any arithmetic calculation like averaging.
• D: TOTAL is not a standard Excel function for calculating an average; it's a general term that might imply a sum, but not an average.

In computing, digital storage units are typically based on powers of 2. Therefore, 1 Gigabyte (GB) is equivalent to 1024 Megabytes (MB). This hierarchical system is standard for measuring data capacity, where each successive unit is 1024 times larger than the preceding one. For example, 1 Kilobyte (KB) equals 1024 Bytes, 1 Megabyte (MB) equals 1024 KB, and 1 Terabyte (TB) equals 1024 GB.

• A: 1024 KB is incorrect; 1 MB equals 1024 KB, so 1 GB is 1024 * 1024 KB.
• B: 1024 TB is incorrect; 1 TB is much larger than 1 GB, specifically 1 TB = 1024 GB.
• D: 1024 Bits is incorrect; 1 GB is vastly larger than 1024 bits (1 byte = 8 bits).

To minimize work loss in MS Word due to system crashes, configuring AutoRecover is the most effective solution. AutoRecover is a crucial feature that automatically saves temporary copies of your document at regular, user-defined intervals. If the application or system unexpectedly shuts down, Word attempts to recover the latest automatically saved version when you restart the program, significantly reducing data loss.

• While a save interval is a setting within AutoRecover, AutoRecover itself is the overarching feature that performs the recovery.
• A document password protects the document from unauthorized access, not from data loss caused by system failures.
• Print settings control how a document is printed (e.g., margins, paper size) and have no function related to data recovery after a crash.

Headers and footers are essential components of document formatting, providing consistent information at the top and bottom of each page, such as page numbers, dates, or document titles. In most word processing applications, including Microsoft Word, features related to adding new elements or objects to a document are consolidated under the Insert tab.

• The Insert tab is the correct answer because it houses commands for adding various items like tables, pictures, shapes, charts, page numbers, and indeed, headers and footers.
• The Home tab primarily contains basic editing and formatting tools like font styles, paragraph settings, and clipboard functions.
• The Layout tab is dedicated to page setup options, including margins, orientation, columns, and page breaks.
• The Review tab focuses on proofing tools, comments, tracking changes, and document protection. Therefore, Insert is the only logical choice for adding headers and footers.

PowerPoint offers various views, each designed for a specific purpose in the presentation creation and delivery process. The Slide Show View is specifically designed for presenting the final product to an audience on a monitor or projector. In this view, the slides fill the entire screen, hiding the PowerPoint interface elements, and animations and transitions are executed. This immersive experience is essential for delivering a professional and engaging presentation, allowing the audience to focus solely on the content without distractions.

• The Slide Sorter View displays all slides as thumbnails for reordering and managing flow, not for presenting.
• The Normal View is the main editing view, used for creating and modifying content.
• The Notes Page View allows users to see how speaker notes will appear when printed, not for audience presentation.

Spreadsheet software provides intuitive tools to streamline data entry and formula replication. One such tool is a small visual indicator that allows users to quickly extend data or formulas to adjacent cells without manually re-typing or copying and pasting repeatedly.

• B: Fill Handle is the correct answer. It is the small green square located at the bottom-right corner of an active cell or selected range. Dragging this handle allows users to copy formulas, extend data series, or replicate formatting to adjacent cells, automatically adjusting cell references when copying formulas.
• A: Copy handle is incorrect; while it performs a copying action, the specific name for this tool is the Fill Handle.
• C: Drag handle is a more general term for an interface element that allows dragging, but
  

For a computer that takes too long to boot and loads applications slowly, the most noticeable improvement would come from replacing the HDD (Hard Disk Drive) with an SSD (Solid State Drive). HDDs rely on spinning platters and mechanical read/write heads, which are inherently slow. SSDs, conversely, use flash memory and have no moving parts, offering significantly faster read and write speeds. This drastically reduces the time required for the operating system to load and applications to launch, making the entire system feel much snappier.

• A: A larger monitor only affects screen size, not performance.
• B: A faster processor primarily improves computational speed, but slow boot/load times are often I/O-bound, meaning storage speed is the bottleneck.
• D: Adding more USB ports provides connectivity but has no impact on system boot or application loading speed.

File extensions are crucial for identifying the type of a file and the software used to open it. By default, Microsoft Word documents are saved with the .docx file extension. This format was introduced with Microsoft Office 2007 and is based on XML, offering improved file integrity, smaller file sizes, and better compatibility compared to the older .doc format.

• .xls is the default file extension for Microsoft Excel spreadsheets.
• .ppt is the default file extension for Microsoft PowerPoint presentations (or .pptx for newer versions).
• .pdf (Portable Document Format) is a universal file format designed to present documents, including text formatting and images, in a manner independent of application software, hardware, and operating systems. While Word can export to PDF, it is not its native saving format.

Moving text from one location to another within a document is a fundamental editing task that involves two main steps: cutting the text and then pasting it. Keyboard shortcuts are highly efficient for performing these actions quickly.

• The correct answer is Ctrl + X. This shortcut is universally recognized for the "Cut" command. When you select text and press Ctrl + X, the text is removed from its original position and temporarily stored on the clipboard, ready to be pasted elsewhere.
• Ctrl + C is the shortcut for "Copy," which duplicates the selected text, leaving the original in place.
• Ctrl + V is the shortcut for "Paste," which inserts the content currently stored on the clipboard into the document at the cursor's position. While necessary for the second part of moving text, it doesn't initiate the move itself.
• Ctrl + Z is the shortcut for "Undo," which reverses the last action performed.

PowerPoint provides master views to customize the appearance and layout of different components of a presentation, including printed materials. The Handout Master is specifically used to control the layout and design of printed copies of slides for the audience. This master allows you to customize elements such as the number of slides per page, the placement of headers, footers, dates, and page numbers on the printed handouts. It ensures that the physical materials distributed to your audience are professional, consistent, and easy to follow, effectively complementing the on-screen presentation.

• The Slide Master controls the layout of individual slides within the presentation.
• The Notes Master controls the layout of printed speaker notes.
• The Handout Master affects how the title slide only appears when printed as part of a handout, not its on-screen design, which is controlled by the Slide Master.