FPSC Information Technology Mcqs

Excel 2007 and subsequent versions dramatically expanded the worksheet capacity. The correct number of rows available on a single worksheet is 1,048,576. This vast increase allows users to manage significantly larger datasets compared to previous versions.

• 65,536 was the maximum number of rows in older Excel versions (Excel 2003 and earlier), making it incorrect for Excel 2007+.
• 16,384 is the maximum number of columns in Excel 2007 and later, not rows.
• 99,999 is an arbitrary number and does not represent any standard Excel dimension. Knowing these limits is fundamental for efficient spreadsheet design and data handling.

A mixed cell reference in Microsoft Excel fixes either the row or the column, but not both. This is done by placing the $ symbol before either the column letter or the row number.

• $A$1 – Absolute reference (both row and column fixed).
• A1 – Relative reference (both row and column change).
• $A1 – Mixed reference (column fixed, row relative). ✔
• $1A – Invalid cell reference.

Therefore, the correct answer is: $A1.

The feature that automatically fills cells based on a recognized pattern is AutoFill. This is commonly used by dragging the fill handle (the small square at the bottom-right corner of a selected cell or range) to extend a series of numbers, dates, or custom lists.

• AutoComplete helps complete text entries in a column based on existing entries, preventing retyping, but it doesn't fill a series of cells.
• AutoCorrect automatically corrects common typing errors or replaces specific text strings as you type.
• Flash Fill (introduced in Excel 2013) is a more advanced feature that intelligently parses and combines data based on patterns, often used for splitting or joining text, but AutoFill is the foundational feature for extending patterns in adjacent cells.

Keyboard shortcuts are essential for efficient navigation and formatting in various software applications, including word processors and spreadsheets. The question asks for the shortcut to apply or remove strikethrough formatting.

• The correct answer is Ctrl + 5. This shortcut toggles the strikethrough effect on selected text, drawing a line through the middle of the characters. It's a quick way to mark text as deleted or outdated without actually removing it.
• Ctrl + 4 is incorrect; it is commonly used to apply or remove underlining to text.
• Ctrl + 2 is incorrect; this shortcut is typically used to apply or remove bold formatting to text.
• Ctrl + 1 is incorrect; in many applications, like Microsoft Excel, it opens the 'Format Cells' dialog box, or in Word, it might change font formatting, but not specifically strikethrough.

In spreadsheet applications like Microsoft Excel, charts are powerful tools for visualizing data. They can be placed in different locations within a workbook, depending on how the user wants to view or present them.

• The correct answer is Chart Sheet. A Chart Sheet is a dedicated worksheet within an Excel workbook that contains only a single chart. This provides a full-page view of the chart, making it ideal for presentations or detailed analysis without the distraction of underlying data.
• Embedded Chart is incorrect. An embedded chart is placed directly on a regular worksheet, alongside the data or other content, appearing as an object within that sheet.
• Graph Sheet is incorrect. While charts are often referred to as graphs, 'Graph Sheet' is not the standard terminology used in Excel for a sheet dedicated to a chart.
• Pivot Chart is incorrect. A Pivot Chart is a specific type of interactive chart linked to a PivotTable, allowing dynamic data manipulation. However, a Pivot Chart can be either embedded or placed on a separate Chart Sheet; it describes the chart's functionality, not its location type.

Spreadsheet programs like Microsoft Excel offer a wide array of functions to manipulate and analyze data, including text strings. Understanding these functions is crucial for effective data processing.

• The correct answer is LEN. The LEN function (short for 'length') is specifically designed to return the number of characters in a given text string. For example, if a cell contains "Hello World", LEN() would return 11 (counting the space).
• COUNT is incorrect. The COUNT function is used to count the number of cells in a range that contain numbers, not the number of characters within a text string.
• MID is incorrect. The MID function extracts a specified number of characters from a text string, starting from a designated position. It does not return the total character count.
• CHAR is incorrect. The CHAR function returns the character corresponding to a specified number code (e.g., ASCII or Unicode), rather than counting characters in a string.

Software is broadly categorized into two main types: system software and application software. This distinction is fundamental to understanding how computers operate and how users interact with them.

• The correct answer is Windows 11. Windows 11 is an operating system, which is a prime example of system software. System software manages and controls the computer hardware and provides a platform for application software to run. It handles essential tasks like memory management, process scheduling, and input/output operations.
• MS Word is incorrect. Microsoft Word is an application software designed for word processing.
• MS Excel is incorrect. Microsoft Excel is an application software used for spreadsheet creation and data analysis.
• PowerPoint is incorrect. PowerPoint is an application software used for creating presentations.

All three (MS Word, MS Excel, PowerPoint) are part of the Microsoft Office suite, which are productivity applications that run on top of an operating system like Windows 11.

The BIOS (Basic Input/Output System) is a critical piece of firmware stored on a ROM (Read-Only Memory) chip on a computer's motherboard. It's the very first software that executes when you power on your computer.

• The correct answer is Run POST and boot computer. The primary function of the BIOS is to perform the Power-On Self-Test (POST), which checks if essential hardware components (like RAM, keyboard, and storage drives) are present and functioning correctly. After a successful POST, the BIOS locates and loads the operating system from a storage device into the computer's RAM, initiating the boot process.
• Perform calculations is incorrect; this is the role of the CPU and application software.
• Manage internet connections is incorrect; this task is handled by the operating system and network drivers.
• Store user files is incorrect; user files are stored on long-term storage devices like hard drives or SSDs, not the small, non-volatile memory of the BIOS chip.

Keyboard shortcuts are invaluable tools for increasing productivity and efficiency across various software applications. They provide a quick way to execute common commands without using a mouse or navigating through menus.

• The correct answer is Print file. The keyboard shortcut Ctrl + P is a widely recognized and almost universally applied command across most operating systems and applications (e.g., web browsers, word processors, image editors). It typically opens the print dialog box, allowing the user to configure print settings and send the current document or page to a printer. The 'P' stands for 'Print'.
• Open new file is incorrect; the standard shortcut for this action is usually Ctrl + N.
• Save file is incorrect; the standard shortcut for saving a file is typically Ctrl + S.
• Paste text is incorrect; the standard shortcut for pasting text is Ctrl + V.

The memory directly accessed by the CPU for executing instructions and processing data is Primary Memory (RAM). RAM, or Random Access Memory, is a volatile memory that holds currently active programs and data, offering the high speed necessary for the CPU's operations. Its direct connection to the CPU's bus enables rapid read and write access.

• Secondary Memory (HDD) stores data persistently but is too slow for direct CPU execution; data must first be loaded into RAM.
• Cache Memory is indeed directly accessed by the CPU and is even faster than RAM, acting as a small, high-speed buffer for frequently used data from RAM. However, RAM is the primary, larger pool of memory the CPU directly interacts with for active tasks.
• Virtual Memory is a memory management technique that uses secondary storage to simulate more RAM, not a physical memory component directly accessed for execution.

The correct Excel function for calculating loan payments is PMT. This function determines the periodic payment for a loan or an investment, assuming constant payments and a constant interest rate. It's widely used in financial modeling to understand the regular installments required to repay a debt, considering the principal, interest rate, and number of payment periods.

• FV (Future Value) calculates the value of an investment at the end of a period, not the payment itself.
• PV (Present Value) calculates the current value of a future stream of payments or a single future payment.
• RATE calculates the interest rate per period of an annuity, which is the inverse of what PMT does. Therefore, PMT is the specific and accurate choice for loan payment calculation.

The feature that creates a presentation by guiding users through a series of questions is the AutoContent Wizard. This tool, prominent in older versions of presentation software like Microsoft PowerPoint, would ask about the presentation's purpose, type, and audience. Based on the answers, it would then generate a basic outline, structure, and even some placeholder content, providing a quick starting point for users.

• Template provides a pre-designed layout and theme, but doesn't interactively build content through questions.
• Design Ideas (a newer feature) suggests visual layouts for existing slide content, rather than generating the content itself.
• SmartArt is used for creating graphical representations of information within a slide, not for generating an entire presentation structure.

Mail Merge in Word is a powerful feature that allows you to combine a document with a data source. Its primary purpose is to create multiple personalized documents, such as letters, envelopes, or labels, by taking a single main document (template) and populating it with unique information from a list or database (the data source). This automates the process of generating individualized communications efficiently.

• While Mail Merge can be used to send personalized emails, its fundamental operation is the merging of data into a document, not merely sending an email.
• "Merge two documents" typically refers to comparing and combining changes between two distinct document files, which is different from Mail Merge's function of populating a template.
• "Attach file to email" is a basic email client function, unrelated to Mail Merge's core capability.

The correct function to find the current date in Excel is TODAY(). This function returns only the current date, without any time component, and updates automatically whenever the worksheet is recalculated or opened. It's ideal for displaying just the date.

• NOW() is a common distractor because it returns both the current date and the current time, which is different from just the date.
• DATE is a function used to construct a date from separate year, month, and day values (e.g., DATE(2023, 10, 26)), not to retrieve the current system date.
• TIME is used to create a time value or extract time components, similar to how DATE works for dates, and does not find the current date.

The acronym GIGO stands for Garbage In Garbage Out. This fundamental principle in computer science and data processing highlights the critical importance of data quality. It asserts that the output generated by any system or program is only as good as the input it receives. If incorrect, irrelevant, or poorly formatted data ("garbage") is fed into a system, the resulting output will inevitably be flawed or meaningless, regardless of how sophisticated the processing algorithms are.

This concept underscores the necessity of accurate data entry, validation, and cleansing to ensure reliable and useful results from any computational process. The other options are not recognized acronyms in this context.

The function designed to look up a value in the first column of a table and return a corresponding value from another column in the same row is VLOOKUP. The 'V' stands for 'Vertical', indicating it searches down the first column.

• HLOOKUP is incorrect because it performs a 'Horizontal Lookup', searching for a value in the first row of a table.
• LOOKUP is a more general and older lookup function, but VLOOKUP is specifically designed and more commonly used for searching the first column of a vertical table array.
• FIND is a text function used to locate one text string within another, not for looking up values in a table based on a key in the first column.

Among the given options, Scanner is NOT a printer type. A scanner is an input device designed to convert physical documents, images, or objects into digital data that can be stored and manipulated on a computer. It captures information from the real world and brings it into the digital realm.

• Conversely, a printer is an output device that takes digital data from a computer and produces a physical hard copy.
• Laser Printer uses a laser beam to create high-quality prints.
• Inkjet Printer sprays tiny ink droplets onto paper.
• Plotter is a specialized printer used for large-format graphics and technical drawings.

All three (Laser, Inkjet, Plotter) are distinct types of printing devices, whereas a scanner serves an entirely different function in the computing process.

Memory in computers can be classified as volatile or non-volatile. Volatile memory loses its stored information when the power is turned off, while non-volatile memory retains it.

• RAM (Random Access Memory) is the correct answer. RAM is a type of volatile memory. It requires continuous power to maintain the stored data. When the computer is turned off or loses power, all data stored in RAM is lost. It serves as the computer's primary working memory for programs and data currently in use.
• ROM (Read-Only Memory) is incorrect. ROM is non-volatile memory. It retains its contents even when the power is off, typically storing essential boot-up instructions (firmware) that don't change frequently.
• Hard Disk is incorrect. A hard disk drive is a non-volatile storage device. It stores data persistently, meaning the data remains even after the computer is powered down.
• Pendrive (USB flash drive) is incorrect. Pendrives use flash memory, which is a type of non-volatile memory. Data stored on a pendrive remains intact without power.

Therefore, RAM's characteristic of losing data without power makes it the quintessential example of volatile memory.

Word processors like MS Word organize their functionalities into various tabs on the ribbon interface, each dedicated to specific tasks. The question asks which tab contains options for changing font, font size, and text color. The correct answer is the Home tab. The Home tab is the central hub for the most frequently used formatting tools, including the "Font" group. Within this group, users can easily modify the font type, adjust its size, change the text color, apply bolding, italics, underlining, and other character-level formatting. The Insert tab is for adding elements like tables, pictures, or headers. The Design tab focuses on document themes and page backgrounds. The Layout tab manages page setup, margins, and paragraph spacing. Therefore, the Home tab is where fundamental text appearance changes are made.

In Microsoft PowerPoint, specific function keys are assigned to control slideshow presentations efficiently. The question asks for the key that starts the slideshow from the very first slide.

• F5 is the correct answer. Pressing the F5 key initiates the presentation from the beginning, regardless of which slide is currently selected in editing view. This is a fundamental shortcut for starting a presentation.
• F1 is incorrect; this key typically opens the Help window in most Microsoft Office applications, including PowerPoint.
• Shift + F5 is also incorrect. While it starts a slideshow, it begins from the *current* slide that is selected in the editing view, not necessarily the first slide.
• F7 is incorrect; this key is commonly used to perform a spell check in Microsoft Office programs like PowerPoint, Word, and Excel.

Understanding these shortcuts enhances productivity when working with presentations.

In presentation and document software, specific areas are designated for information that needs to appear consistently across multiple pages or slides. The area at the bottom of a slide where you can place repeating information, such as dates, slide numbers, or company names, is called the Footer. This feature is incredibly useful for maintaining consistency and providing essential context throughout your presentation. Conversely, the Header is the corresponding area at the top of a slide or page for similar repeating information. Margins are the blank spaces around the content area, and Endnotes are typically found at the end of a document for citations, not as repeating slide elements.

A computer's memory hierarchy is designed to provide fast access to data while managing costs, with faster, smaller memory closer to the CPU. To minimize access time for frequently used instructions and data, optimizing cache memory hit rate has the greatest impact on CPU performance. Cache memory is a small, very fast memory located near the CPU that stores copies of data from main memory that the CPU is likely to need next. A high hit rate means the CPU finds the data it needs in the cache more often, avoiding slower main memory access.

• Hard Disk Drive capacity is for long-term storage and is far too slow for direct CPU access.
• RAM clock speed is important for main memory, but cache is even faster and directly serves the CPU's immediate needs.
• Virtual memory page file size relates to disk space used when RAM is full, which is significantly slower than cache.

This question differentiates between various forms of computer output, specifically focusing on what is displayed on a screen.

• Soft Copy is the correct answer. A soft copy refers to an electronic display of information, such as text, images, or videos, shown on a monitor, television, or any other display device. It is intangible, temporary, and can be easily modified or deleted.
• Printout is incorrect. A printout is a physical copy of data or information produced by a printer, typically on paper.
• Hard Copy is incorrect. A hard copy is a physical, tangible record of information, usually on paper or film, that can be held and touched. A printout is a type of hard copy.
• Duplicate Copy is incorrect. A duplicate copy simply means an exact replica of something, which could be either a soft copy or a hard copy. It doesn't specifically define the output displayed on a monitor.

The distinction between tangible (hard) and intangible (soft) forms of output is fundamental in computing.

Text formatting features allow for precise control over character appearance and positioning. The feature that places text slightly above the normal line, as seen in mathematical exponents like X², is called Superscript. Superscript raises the selected text above the baseline and often reduces its size, making it distinct from the surrounding text. It is commonly used for exponents, footnotes, or ordinal numbers (e.g., 1st, 2nd). In contrast, Subscript places text slightly below the baseline, typically used for chemical formulas (e.g., H₂O). Strikethrough draws a line through the middle of the text, indicating deletion or correction, but does not alter vertical positioning. Small Caps formats lowercase letters as smaller uppercase letters, affecting size and case but not vertical alignment. Thus, Superscript is the correct term for text positioned above the line.

PowerPoint offers various features to enhance the visual appeal and flow of a presentation. The question focuses on the visual effects that occur when moving from one slide to the next.

• Transitions is the correct answer. Slide transitions are the visual effects that play when you switch from one slide to the next during a presentation. They control how a slide appears on the screen and how the previous one exits.
• Animations are incorrect. Animations are visual effects applied to individual objects (like text, images, or shapes) *on* a single slide, making them move or change appearance, rather than affecting the entire slide change.
• Slide Master is incorrect. The Slide Master is a powerful feature used to define the overall design, layout, and formatting for all slides in a presentation, ensuring consistency. It doesn't control the visual effects between slides.
• Custom Shows are incorrect. Custom Shows allow you to create tailored versions of your presentation for different audiences by selecting a specific subset of slides from your main presentation. They don't relate to visual effects.