FPSC Information Technology Mcqs

File extensions are crucial identifiers that tell an operating system and applications what type of data a file contains and how to process it. In the context of PowerPoint, various file types can be inserted to enrich a presentation. A .wav file (Waveform Audio File Format) is a widely recognized standard for storing uncompressed digital audio. It is a common format for high-quality sound recordings and is readily supported for insertion into PowerPoint presentations. Therefore, a .wav file is unequivocally a type of Sound file. It is not a video file (e.g., .mp4), an image file (e.g., .jpg), or a presentation file itself (e.g., .pptx).

SRAM (Static RAM) and DRAM (Dynamic RAM) are distinct types of Random Access Memory. The statement that best explains their usage is that SRAM does not require constant refreshing, making it faster but more expensive. SRAM uses latches to store bits, maintaining data as long as power is supplied without needing periodic refreshes. This makes it significantly faster and more complex, hence more expensive per bit, ideal for the CPU's high-speed cache memory. DRAM, conversely, stores bits in capacitors that leak charge, requiring constant refreshing, which makes it slower but simpler and cheaper, suitable for larger main memory.

• Option A is incorrect; SRAM is faster, not slower.
• Option C is incorrect; both SRAM and DRAM are volatile, losing data when power is off.
• Option D is incorrect; DRAM has higher storage density due to its simpler cell structure.

The question asks about the type of software that manages a computer's internal operations and hardware. System Software is the correct answer because it comprises programs designed to operate and control the computer hardware and to provide a platform for running application software. Examples include operating systems (like Windows or macOS) and device drivers, which are crucial for the computer's fundamental functionality and resource management.

• Application Software (A) refers to programs that perform specific tasks for the user, such as word processors or web browsers, and relies on system software to run.
• Shareware (C) is a method of software distribution, not a category based on its function.
• Firmware (D) is a specific type of low-level software embedded directly into hardware devices (e.g., BIOS), but system software is the broader category responsible for overall operational control.

File extensions are crucial identifiers that indicate the type of a file and the software program associated with it. The question asks for the default file extension of MS Word 2016. The correct answer is .docx. This extension was introduced with Microsoft Word 2007 and has been the standard for all subsequent versions, including Word 2016. The 'x' signifies that it is based on Office Open XML (OOXML), an XML-based format that offers benefits like smaller file sizes, improved data recovery, and enhanced security compared to older formats. The .doc extension was the default for older versions of Word (Word 97-2003). .dot is the extension for Word document templates, used to create new documents with predefined settings. .word is not a recognized or standard file extension for Microsoft Word documents. Therefore, .docx is the correct default extension.

Microsoft PowerPoint provides tools to ensure a consistent and professional look across all slides in a presentation. The question asks for the term describing a ready-made set of slide layouts and formatting.

• Design Template is the correct answer. In PowerPoint, a Design Template (often referred to as a Theme in newer versions) is a pre-designed set of slide layouts, color schemes, fonts, background styles, and effects that can be applied to an entire presentation to give it a consistent and professional appearance.
• Placeholder is incorrect. A placeholder is a box with a dotted border on a slide layout that holds specific content, such as text, pictures, or charts. It's an element *within* a template, not the template itself.
• Transition is incorrect. Transitions are the visual effects that occur when moving from one slide to the next during a slideshow.
• Animation is incorrect. Animations are visual effects applied to individual objects on a slide, making them move or change appearance.

Design Templates are crucial for maintaining visual uniformity.

In Microsoft Excel, the primary file type is known as a Workbook. A workbook serves as a container for one or more individual worksheets, allowing users to organize and manage related data within a single file. This structure is fundamental to how Excel operates, enabling complex data analysis and presentation.

• Document (A) is incorrect because this term typically refers to files created in word processing software like MS Word.
• Slide (B) is incorrect as it refers to individual pages within a presentation program like MS PowerPoint.
• Worksheet (D) is incorrect because while a worksheet is a core component of Excel, it is only one sheet within the larger workbook file, not the file itself.

Virtual memory is a crucial memory management technique that allows a computer to compensate for physical memory (RAM) shortages. When a computer's 8 GB of RAM becomes completely full, the operating system utilizes virtual memory by temporarily storing less frequently used data on the hard disk or SSD. This designated area on the storage drive is often called a 'page file' or 'swap file'. By moving data to disk, the system frees up physical RAM for more active processes, preventing crashes and allowing more applications to run than physical RAM alone would permit.

• CPU registers are tiny, extremely fast storage locations within the CPU, not used for overflow from RAM.
• Cache memory is a faster memory layer between the CPU and RAM, storing frequently accessed data, not an overflow for full RAM.
• ROM BIOS is Read-Only Memory containing firmware, not dynamic data storage.

The question asks to identify which device is NOT an output device. An output device receives data from a computer and displays or presents it to the user. Scanner is the correct answer because it is an input device. A scanner captures images, text, or objects from the physical world and converts them into digital data that the computer can process and store. It sends information *into* the computer.

• Projector (A) is an output device that displays images or video onto a screen or surface.
• Plotter (B) is an output device used for printing vector graphics, often on large sheets of paper, typically for architectural or engineering designs.
• Monitor (D) is an output device that visually displays information processed by the computer to the user.

Microsoft Word provides various document views, each optimized for different tasks. The question asks which view shows the document exactly as it will appear on the printed page. The correct answer is Print Layout view. This view is invaluable for final document preparation because it accurately displays all page elements, including margins, headers, footers, page breaks, columns, and the precise positioning of text and graphics. It gives a true "what you see is what you get" (WYSIWYG) representation. Web Layout view shows how the document would look as a web page, without traditional page breaks or margins. Outline view focuses on the document's structure using headings, aiding in organization. Draft view is a simplified mode that hides some formatting and objects to speed up text entry, not showing the full page layout. Hence, Print Layout is essential for print-ready accuracy.

Keyboard shortcuts are essential for efficient navigation and editing in Microsoft PowerPoint. The question asks for the shortcut key combination used to insert a new slide into an existing presentation.

• Ctrl + M is the correct answer. This shortcut is specifically designed to insert a new blank slide into your current presentation, typically using the default title and content layout.
• Ctrl + N is incorrect. This shortcut is used to create a *new, blank presentation* entirely, not just a new slide within the active presentation.
• Ctrl + S is incorrect. This is a universal shortcut across most applications, including PowerPoint, used to *save* the current presentation.
• Ctrl + I is incorrect. This shortcut is commonly used to apply *italic* formatting to selected text within a slide.

Using Ctrl + M significantly speeds up the process of building out a presentation slide by slide.

The default file extension for an Excel 2016 workbook is .xlsx. This extension signifies that the file is an XML-based Excel workbook, a format introduced with Excel 2007 to offer improved file recovery, smaller file sizes, and enhanced security compared to older versions. Understanding file extensions is crucial for identifying file types and ensuring compatibility.

• .docx (A) is incorrect; this is the default file extension for Microsoft Word documents.
• .pptx (B) is incorrect; this is the default file extension for Microsoft PowerPoint presentations.
• .xls (D) is incorrect; this was the default file extension for older Excel versions (Excel 97-2003) and represents a binary file format.

The clock speed of a CPU is a fundamental measure of its processing power, indicating how many processing cycles it can complete per second. The unit used to measure the clock speed of a CPU is Gigahertz (GHz). One Gigahertz represents one billion cycles per second. A higher clock speed generally means the CPU can execute instructions faster, leading to better overall computer performance.

• Bytes are units of digital information storage, used for measuring memory capacity (e.g., RAM, hard drive size), not speed.
• Megapixels are units used to measure the resolution of digital images or camera sensors, indicating the number of pixels.
• DPI (Dots Per Inch) is a measure of spatial printing or video dot density, used for printer resolution or screen density.

The process of starting or restarting a computer system is known as Booting. This fundamental process involves the computer's initial set of operations when power is turned on or reset. During booting, the system performs a Power-On Self-Test (POST), loads the operating system from storage into the computer's main memory (RAM), and initializes all necessary hardware and software components, making the computer ready for user interaction.

• Loading (B) is a general term for transferring data or programs into memory, but it doesn't encompass the entire startup sequence.
• Formatting (C) is the process of preparing a storage device (like a hard drive) for data storage by creating a file system, which typically erases existing data.
• Processing (D) refers to the general act of a computer performing operations on data, which is a continuous activity, not just the startup phase.

Understanding basic keyboard shortcuts is fundamental for efficient computer use. The question asks for the shortcut key to "Copy" text.

• Ctrl + C is the correct answer because it is the universal shortcut used across most operating systems and applications to copy selected text or objects to the clipboard without removing them from their original location.
• Ctrl + X is incorrect; this shortcut is used for "Cut," which removes the selected content from its original location and places it onto the clipboard.
• Ctrl + V is incorrect; this shortcut is used for "Paste," which inserts the content currently stored on the clipboard into the document at the cursor's position.
• Ctrl + P is incorrect; this shortcut is used to open the "Print" dialog box, allowing users to print their document.

Therefore, to duplicate text, Ctrl + C is the appropriate command.

PowerPoint allows users to adjust the zoom level of their slides to facilitate detailed editing or to get an overview of the slide content. The question asks for the maximum zoom percentage allowed.

• 400% is the correct answer. Microsoft PowerPoint, like many other Office applications such as Word and Excel, allows users to zoom in on their content up to a maximum of 400%. This high zoom level is useful for precise adjustments to small objects or text on a slide.
• 200% is incorrect; while 200% is a common zoom level, it is not the maximum.
• 300% is incorrect; similar to 200%, it's a possible zoom level but falls short of the maximum.
• 500% is incorrect; this percentage exceeds the maximum zoom limit set by the software. The typical zoom range in PowerPoint is from 10% (minimum) to 400% (maximum).

Knowing the zoom limits helps in effectively managing the workspace.

In Excel, a combination of a column letter and a row number, such as A1 or B4, is known as a Cell Address or Cell Reference. This unique identifier pinpoints the exact location of a single cell within a worksheet, allowing users to input data, apply formatting, and reference specific values in formulas. It's a foundational concept for navigating and manipulating data in spreadsheets.

• Cell Pointer (B) is incorrect; this refers to the highlighted border around the currently active cell.
• Range (C) is incorrect; a range refers to a selection of two or more cells (e.g., A1:B4), not the address of a single cell.
• Formula (D) is incorrect; a formula is an expression that performs calculations, often utilizing cell addresses, but it is not the address itself.

Computer hardware components are broadly categorized into input and output devices. An input device allows users to send data, commands, or signals into a computer system. The keyboard is a prime example of an input device, as it enables users to type text, numbers, and execute commands by pressing keys, thereby providing input to the computer.

• Monitor is an output device, displaying visual information from the computer.
• Printer is an output device, producing hard copies of digital documents.
• Speaker is an output device, generating audio from the computer.

Understanding this distinction is crucial for comprehending how users interact with computer systems.

The question describes a computer type that is the fastest, largest, most expensive, and used for complex scientific simulations. Supercomputer is the correct answer. Supercomputers are designed for immense computational power and speed, making them ideal for highly intensive tasks such as advanced scientific research, weather forecasting, nuclear simulations, and complex data analysis that require processing trillions of calculations per second.

• Mainframe Computer (A) is a large, powerful computer used by large organizations for critical applications and transaction processing, but not primarily for the extreme scientific simulations supercomputers handle.
• Mini Computer (C) is a mid-range computer, smaller and less powerful than mainframes, used for specific tasks in businesses or scientific labs.
• Workstation (D) is a high-performance computer designed for a single user, typically for technical or scientific applications, but it lacks the scale and power of a supercomputer.

Word processing software like Microsoft Word offers various tools to analyze and manage documents. The question asks which tool is used to count the number of words in a document.

• Word Count is the correct answer. This feature is specifically designed to provide statistics about a document, including the total number of words, characters (with and without spaces), paragraphs, and lines. It's invaluable for writers needing to meet specific length requirements.
• Thesaurus is incorrect; its purpose is to help users find synonyms and antonyms for selected words, enhancing vocabulary and writing style.
• Spell Check is incorrect; this tool identifies and suggests corrections for spelling and grammatical errors within the document.
• Translate is incorrect; this feature converts text from one language to another, facilitating communication across different languages.

Thus, for a precise word count, the dedicated Word Count tool is essential.

Microsoft PowerPoint organizes its features into various tabs on the Ribbon interface to make them accessible. The question asks under which tab the "Slide Master" feature is located.

• The View tab is the correct answer. The Slide Master feature, which allows users to modify the main slide template to control the overall design and layout of all slides in a presentation, is found within the 'Master Views' group under the View tab. This tab is dedicated to changing how you see and interact with your presentation.
• The Home tab is incorrect. It contains basic editing tools like font, paragraph, drawing, and clipboard options.
• The Insert tab is incorrect. This tab is used for adding various elements to your slides, such as pictures, tables, shapes, charts, and text boxes.
• The Design tab is incorrect. While the Design tab is where you apply themes and customize slide size and background, the actual 'Slide Master' *view* for editing the master slides is accessed through the View tab. The Design tab utilizes the definitions set in the Slide Master.

To add a range of cells in Excel, the function used is SUM. The SUM function is one of the most fundamental and frequently used functions, designed to calculate the total of all numbers within a specified range of cells. For example, =SUM(A1:A5) will add all the values from cell A1 to A5.

• AVERAGE (A) is incorrect; this function calculates the arithmetic mean of a range of cells, not their sum.
• ADD (C) is incorrect; while addition is performed, 'ADD' is not a valid Excel function name for summing a range.
• TOTAL (D) is incorrect; similar to 'ADD', 'TOTAL' is not a recognized Excel function for this purpose.

RAM stands for Random Access Memory. It is a type of volatile computer memory that stores data and program instructions currently being used by the CPU. Its 'random access' nature means that any byte of data can be accessed directly and quickly, regardless of its physical location, which is crucial for fast system operation. Unlike sequential access memory, you don't have to read through preceding data to get to the desired information.

• A: Readily Accessible Memory is not the correct technical acronym, though it describes RAM's function.
• C: Read-Only Memory (ROM) is a different type of non-volatile memory that stores permanent firmware instructions and cannot be easily altered.
• D: Rapid Action Module is a fabricated term and not a recognized computer component.

In computer science, a byte is a fundamental unit of digital information. A byte is a combination of 8 bits. A bit, short for binary digit, is the smallest unit of data in a computer, representing either a 0 or a 1. Grouping eight bits together to form a byte allows for the representation of 256 different values (2^8), which is sufficient to encode a single character (like a letter, number, or symbol) in many standard character encoding schemes, such as ASCII.

• 4 (A) bits form a 'nibble', which is half a byte.
• 2 (B) bits can only represent four distinct values (00, 01, 10, 11).
• 16 (C) bits are often referred to as a 'word' or 'short integer' in some architectures, but the standard definition of a byte remains 8 bits.

In MS Word, organizing information into lists is a common formatting task. The question refers to creating a list with dots or numbers at the beginning of paragraphs.

• Bullets and Numbering is the correct answer. This feature allows users to create structured lists. "Bullets" add symbols (like dots, squares, or custom icons) before each paragraph, while "Numbering" adds sequential numbers or letters, ideal for ordered lists.
• Indent is incorrect; indenting adjusts the spacing of a paragraph from the left or right margins, affecting its position but not adding list markers.
• Shading is incorrect; shading applies a background color to selected text or paragraphs, primarily for visual emphasis.
• Borders is incorrect; borders add lines around text, paragraphs, or pages, used for separation or decorative purposes.

Therefore, to create visually distinct lists, the Bullets and Numbering tool is the appropriate choice.

PowerPoint's interface is designed for efficient navigation and editing. The Slides Pane, often referred to as the Thumbnail Pane, is located on the left side of the PowerPoint window in Normal view. Its primary function is to display miniature versions (thumbnails) of all the slides in the presentation. This visual list allows users to quickly navigate between slides, reorder them, or select specific slides for editing, providing a clear overview of the presentation's structure.

• The Status Bar, at the bottom, shows information like the current slide number and zoom level, not slide thumbnails.
• The Notes Pane, below the slide, is for adding speaker notes to the current slide.
• The Task Pane, typically on the right, is for specific tasks like formatting or animation, not for listing all slides.