Computer Science MCQS

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.

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.