MS Word MCQS

The traditional file extension for Microsoft Excel workbooks is .xls. This extension was primarily used for Excel files created in versions up to Excel 2003. While newer versions (Excel 2007 and later) introduced the .xlsx extension, .xls remains a widely recognized and compatible format for Excel files.

• .docx is the file extension for Microsoft Word documents.
• .dbx is an extension associated with Outlook Express mail folders or certain database files.
• Therefore, None of these is incorrect, as .xls is a valid and common extension for MS Excel.

In the context of technology, URL stands for Uniform Resource Locator. A URL is a reference to a web resource that specifies its location on a computer network and a mechanism for retrieving it. It is the fundamental addressing scheme for the World Wide Web.

• (A) Uniform Resource Locator is the correct full form of URL. It precisely describes its function as a standardized way to locate resources.
• (B) Universal Resource Locator is incorrect; 'Uniform' emphasizes standardization, not universality.
• (C) Unique Resource Locator is incorrect; while URLs often point to unique resources, 'Unique' is not part of the official acronym.
• (D) Uniform Resource Link is incorrect; 'Locator' accurately describes its role in finding resources, not just linking to them.

The clipboard is a temporary storage area in computer memory where cut or copied data is held before being pasted to another location.

The CPU (Central Processing Unit) is often referred to as the 'brain' of the computer. It is responsible for executing instructions, performing arithmetic and logical operations, and managing the overall flow of data and instructions within the computer system. Without a CPU, a computer cannot function.

• (A) CPU is correct because it is the primary component for calculations and decision-making.
• (B) RAM (Random Access Memory) is incorrect; RAM is used for temporary data storage, not processing.
• (C) Monitor is incorrect; a monitor is an output device that displays visual information.
• (D) Hard Drive is incorrect; a hard drive is a storage device for long-term data retention.

In Excel, Columns are labeled as A B C D .....

The Atanasoff-Berry Computer (ABC) is widely recognized as one of the earliest electronic digital computing devices. While its initial purpose was to solve systems of linear equations, its architectural innovations, such as binary arithmetic and regenerative memory, laid crucial groundwork for the development of modern computers. It was not a specific-purpose computer in the sense of being limited to a single, unchangeable task like a dedicated calculator. Instead, its design principles contributed significantly to the evolution of machines capable of performing a variety of tasks through programming, making it a precursor to general-purpose computers. Distractors like "Specific purpose computer" are incorrect as ABC's influence extended beyond a singular, fixed application.

The Format Painter in MS Office is the correct tool for copying and pasting character and paragraph formats. It allows users to quickly replicate formatting attributes—like font style, size, color, bolding, italics, paragraph alignment, and line spacing—from one piece of text to another. This feature is invaluable for maintaining a consistent visual style throughout a document. Paste Special (B) is used for pasting content with specific data types or formats, not for copying existing formatting styles. A Text Box (C) is a container for text, not a formatting application tool. Therefore, Format Painter is the precise and most efficient option for this task.

The correct command to view the entire document before printing is Print Preview. This essential feature allows users to see an exact representation of how their document will appear on paper, including all formatting, layout, and page breaks. It enables a thorough review to catch any errors or undesirable layouts, ensuring the final printed output matches expectations. In contrast, "Print Design" is not a standard command for this purpose, and "Print All" simply sends the document directly to the printer without offering a prior visual inspection. Print Preview is crucial for quality control and avoiding wasted paper.

The correct answer is (B) Gutter. In typography and page layout, a gutter refers to the vertical separation or space between columns of text or between facing pages in a bound publication. It's crucial for readability and aesthetics, ensuring text from one column doesn't visually merge with another.

• (A) Index is an alphabetical list of names, subjects, etc., with references to the places where they occur.
• (C) Margin refers to the blank space between the edge of the page and the main body of the text. While related to spacing, it's distinct from the internal separation between columns.
• (D) None of these is incorrect because 'Gutter' precisely defines the vertical separation.

The correct answer is (A) Store deleted file. The Recycle Bin (or Trash on macOS) is a temporary storage area for files and folders that have been deleted from a computer's hard drive. This allows users to recover accidentally deleted items before they are permanently removed from the system.

• (B) Store corrupt file is incorrect; the Recycle Bin does not specifically store corrupt files.
• (C) Store temporary file is incorrect; temporary files are typically stored in specific system directories and are not managed by the Recycle Bin.
• (D) Store document file is incorrect; document files are stored in various user-defined locations, not primarily in the Recycle Bin unless they have been deleted.

The correct answer is (C) Auto Save. Microsoft Word, along with many other modern applications, includes an 'Auto Save' feature that automatically saves changes to a document at regular, predefined intervals. This functionality helps prevent data loss in case of unexpected program crashes or power outages.

• (A) Auto Update refers to software updating itself, not saving a document.
• (B) Auto Recover is a related but distinct feature that helps recover unsaved changes from a document after a crash, often utilizing files created by the Auto Save process. While linked, 'Auto Save' is the direct action of saving at intervals.
• (D) None of these is incorrect as 'Auto Save' is a standard feature.

The correct answer is $A$1. In spreadsheet applications like Microsoft Excel, an absolute cell reference is used to keep a cell's location constant when a formula is copied or filled to other cells. This is achieved by placing a dollar sign ($) before both the column letter and the row number.

• A1 is a relative cell reference, meaning it changes based on the relative position of the cell where the formula is copied.
• IA1 is not a standard or valid cell reference format in most spreadsheet programs.
• The other A1 option is also a relative reference.

The correct answer is (C) Both A & B. In MS Excel, a standard formula often comprises both labels (cell references like A1, B2) and numeric values. For instance, a formula like =SUM(A1:A5, 10) includes cell labels (A1:A5) and a numeric value (10). Therefore, a comprehensive formula can contain both elements.

• (A) Label is partially correct but incomplete, as formulas frequently incorporate numbers.
• (B) Numeric value is also partially correct but incomplete, as cell references are fundamental.
• (D) None of these is incorrect because option (C) accurately describes the components.

A computer program that translates one program instruction at a time into machine language is known as an Interpreter. Interpreters execute code line by line, translating and running each instruction sequentially. This allows for immediate execution and easier debugging.

• Compiler: Translates the entire source code into an executable machine code file before any execution takes place.
• Simulator: Mimics the behavior of a system or device, often for testing or training purposes, rather than translating program instructions for direct execution.
• CPU (Central Processing Unit): This is the hardware component that executes machine language instructions, but it does not perform the translation from high-level code itself.

The correct answer is (C) F7. In Microsoft Word, the F7 key is the standard shortcut used to open the Spelling & Grammar dialog box, allowing users to check and correct errors in their document. This function key is widely recognized across various Microsoft Office applications for this specific purpose.

• (A) F3 is typically used for searching for text or graphics.
• (B) F5 is commonly used for the 'Go To' command or to refresh a web page in browsers.
• (D) F9 is generally used to update selected fields in a document.

The correct answer is Ctrl+Apostrophe ('). This keyboard shortcut in spreadsheet applications like Microsoft Excel is specifically used to copy the formula from the cell directly above the active cell into the active cell, displaying the formula itself rather than its calculated result. This is particularly useful for quickly replicating or inspecting formulas.

• Ctrl+C is used to copy the selected content (value or formula) to the clipboard, not specifically from the cell above.
• Ctrl+: (Ctrl+colon) is used to insert the current time.
• Ctrl+. (Ctrl+period) is used to select the corners of the selected range.

The correct answer is (D) Document. In MS Excel, the primary working environment consists of worksheets made up of cells, rows, and columns. The term 'document' is typically associated with word processing software like Microsoft Word, where users create text-based files.

• (A) Cell is the fundamental unit where data is entered in Excel.
• (B) Row refers to the horizontal arrangement of cells, identified by numbers.
• (C) Column refers to the vertical arrangement of cells, identified by letters. All three are core components of an Excel spreadsheet.

In MS Word, superscript and subscript are known as Font Format. These are specific modifications that alter the appearance and position of characters relative to the baseline, making them smaller and slightly raised (superscript) or lowered (subscript). They fall under the broader category of font formatting options that control how text looks.

• Font Style typically refers to attributes like bold, italic, or underline.
• Font Family refers to the typeface itself, such as Arial or Times New Roman.
• Font Effect is a related term, but 'Font Format' is a more encompassing category for these types of character alterations within MS Word's interface.

The correct answer is (A) 8.5 and 11. By default, the standard page size for a new document in most word processing applications, particularly in North America, is Letter size, which measures 8.5 inches wide by 11 inches high. This is the most common paper dimension for printing and general use.

• (B) 7.5 and 12 is not a standard default page size.
• (C) 7.5 and 11.5 is also not a standard default page size.
• (D) None of these is incorrect because option (A) represents the widely accepted default.

The correct answer is (A) USA. The first computer mouse was invented by Douglas Engelbart at the Stanford Research Institute (SRI) in Menlo Park, California, USA, in the 1960s. He publicly demonstrated it in 1968 as part of his pioneering work on human-computer interaction.

• (B) Japan is a major contributor to technology but did not invent the first computer mouse.
• (C) Germany has a rich history in engineering but is not credited with the invention of the computer mouse.
• (D) France also has technological advancements but did not develop the first computer mouse.

An error in software or hardware is commonly called a bug. An alternative jargon for it is a Glitch. A glitch typically refers to a minor, often temporary, malfunction or fault in a system. It's a widely used informal term to describe unexpected problems or hiccups in technology, similar to a bug but sometimes implying a less severe or transient issue.

• Leech refers to a parasitic worm or, in computing, someone who takes resources without contributing.
• Squid is a marine animal and also a type of proxy server software.
• Slug refers to a mollusk, a slow-moving object, or a part of a URL, none of which relate to a software error.

India gained independence from British rule on August 15, 1947. This historic event marked the end of nearly two centuries of colonial rule and the birth of India as a sovereign nation. The partition of British India into India and Pakistan also occurred in this year.

• (A) 1947 is correct because it is the year India achieved independence.
• (B) 1950 is incorrect; India adopted its constitution and became a republic in 1950.
• (C) 1960 is incorrect; this year holds no direct significance for India's independence.
• (D) 1952 is incorrect; India held its first general elections in 1952.