Computer Science MCQS

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 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.