Search Previous Year Questions

The correct answer is - It repeats an action that was undone using Undo

Key Points

• Redo Command
• The Redo command is used to reverse the effects of an Undo action.
• It allows users to re-apply changes or formatting that were recently removed or reversed.
• This feature is only active if at least one Undo action has been performed in the current editing session.
• In the Microsoft Word interface, the command is typically represented by a curved arrow pointing to the right.

Additional Information

• Undo Command
• The Undo command reverses the most recent action performed in the document.
• The keyboard shortcut for Undo is Ctrl + Z.
• It helps in error correction by allowing users to step back through their editing history.
• Keyboard Shortcuts for Redo
• The standard keyboard shortcut for the Redo command is Ctrl + Y.
• In many versions of Word, the F4 key can also be used as a shortcut for Redo or to Repeat the last action.
• Quick Access Toolbar
• Both the Undo and Redo buttons are located by default on the Quick Access Toolbar at the top left of the window.
• Users can click the small drop-down arrow next to these buttons to see a list of multiple actions that can be undone or redone at once.
• Repeat Command
• If no action has been undone, the Redo button often functions as the Repeat button.
• The Repeat command duplicates the very last action, such as typing a specific word or applying a font style.

The correct answer is - Convert it to PDF and optionally mark the original Word document as final

Key Points

• PDF (Portable Document Format)
• Converting a Word document to PDF ensures that the formatting, fonts, and layout are preserved exactly as intended across different platforms and devices.
• PDF files are inherently more difficult to edit than standard Word documents, acting as a primary deterrent against unauthorized alterations by recipients.
• Mark as Final
• This feature in Microsoft Word sets the document to read-only mode, communicating to the reader that the document is the completed version.
• When a document is marked as final, typing, editing commands, and proofing marks are disabled, and the status property is set to "Final".
• Document Integrity
• Combining conversion to PDF with marking the source as final is a standard professional practice to ensure data integrity and version control.

Additional Information

• Restrict Editing Feature
• Microsoft Word includes a Restrict Editing pane (found under the Review tab) that allows authors to limit formatting changes or restrict editing to specific types, such as comments or filling in forms.
• This can be enforced with a password, providing a higher level of security than simply marking a document as final.
• Encryption with Password
• For sensitive information, users can Encrypt with Password via the File menu, which prevents unauthorized users from opening the document entirely.
• PDF Standards
• PDF is an ISO standard (ISO 32000), making it a universal format for electronic document exchange that does not rely on the recipient having specific word processing software installed.

The correct answer is - www.example.org

Key Points

• Domain Name (www.example.org)
• The domain name is the human-readable address used to identify a specific web server on the internet.
• In the URL structure, it follows the protocol and precedes the path.
• It is converted into a numerical IP address by the Domain Name System (DNS) to facilitate network communication.
• A fully qualified domain name (FQDN) like www.example.org consists of a host name (www), a second-level domain (example), and a top-level domain (.org).

Additional Information

• Protocol (https)
• The protocol (or scheme) specifies the rules used for data transfer; HTTPS stands for Hypertext Transfer Protocol Secure.
• It indicates that the communication between the browser and the server is encrypted using SSL/TLS.
• Path (/about)
• The path identifies the specific resource, file, or subdirectory on the web server that the user wants to access.
• It typically follows the top-level domain and begins with a forward slash (/).
• Subdomain (www)
• The subdomain is an optional part of the domain hierarchy used to organize different sections of a website.
• While www (World Wide Web) is the most common subdomain, others like blog or mail are frequently used to point to different servers.
• Top-Level Domain (TLD)
• The TLD is the last segment of the domain name, such as .com, .org, or .net.
• It helps classify the purpose or geographical location of the website (e.g., .org for organizations, .in for India).

The correct answer is - To store small pieces of data on the user's device related to website preferences

Key Points

• Cookies
• A cookie is a small text file created by a website that is stored in the user's computer either temporarily for that session only or permanently on the hard disk.
• The primary purpose is to help the web server identify the user and retrieve specific information about their preferences and history.
• They are essential for maintaining session states, such as keeping a user logged in while navigating different pages of a site.
• Cookies store stateful information like items added to a shopping cart or language settings for a personalized browsing experience.

Additional Information

• Types of Cookies
• Session Cookies: These are temporary and are deleted once the web browser is closed.
• Persistent Cookies: These remain on the device for a pre-defined period or until the user deletes them manually.
• First-party Cookies: Set directly by the website the user is visiting.
• Third-party Cookies: Set by domains other than the one currently being visited, primarily used for online advertising and cross-site tracking.
• Privacy and Security
• Cookies are not programs; they cannot carry viruses or install malware on the host computer.
• However, they can be used to track browsing history, which often leads to privacy concerns regarding user profiling.
• Most modern browsers offer settings to block or clear cookies to enhance user privacy.

The correct answer is - Move the message to a suitable folder or archive for long-term storage

Key Points

• Email Organization
• Moving important emails to folders or labels allows users to clear the main view without permanently removing essential data.
• This practice helps in managing inbox clutter, which refers to an accumulation of many messages that makes it difficult to find specific information.
• Archiving is a specific function that removes messages from the inbox but keeps them in the account's database for future retrieval via search.
• Proper categorization ensures that critical information is preserved for long-term storage and remains easily accessible.

Additional Information

• Inbox Management Techniques
• Filters/Rules: Automated systems that automatically move incoming emails to specific folders based on the sender or keywords.
• Archive vs. Delete: While deleting moves a message to the trash (often permanently removed after 30 days), archiving stores it indefinitely without an expiration date.
• Search Functionality: Email clients use metadata like subject lines, sender names, and attachments to find archived messages quickly.
• Spam and Redundancy
• Marking as Spam: This action identifies an email as junk or malicious and trains the system to block similar future messages; it is inappropriate for important information.
• Email Forwarding: Repeatedly forwarding a message to oneself creates redundant copies and increases clutter rather than solving the organization problem.

The correct answer is - Changes are discarded, only the last saved version remains

Key Points

• Discarding Changes
• When a user selects "Don't Save," Excel instructs the system to ignore all modifications, formatting updates, and data entries made since the file was last opened or saved.
• The file on the hard drive or permanent storage remains unchanged, preserving the integrity of the previous version.
• This action clears the temporary data stored in the RAM (Random Access Memory) without committing it to the physical disk.

Additional Information

• AutoRecover Feature
• Microsoft Excel includes an AutoRecover function that periodically saves temporary copies of the workbook to prevent data loss during system crashes.
• However, if a user manually chooses "Don't Save" during a controlled close, Excel typically deletes the temporary AutoRecover file.
• Save vs. Save As
• The Save command updates the current file with new changes.
• The Save As command allows the user to create a duplicate version of the workbook with a different name or file extension, leaving the original file in its last saved state.
• Excel File Extensions
• Standard Excel workbooks use the .xlsx extension, while macro-enabled workbooks use .xlsm.
• The file state behavior (saving vs. discarding) remains consistent regardless of the file format used.

The correct answer is - Saving the workbook regularly under a meaningful file name

Key Points

• Saving Regularly
• Frequent saving is the most fundamental precaution to prevent data loss resulting from power outages, system crashes, or application errors.
• Users can perform a manual save using the shortcut Ctrl + S or by clicking the disk icon on the Quick Access Toolbar.
• Using a meaningful file name ensures the file is easily identifiable and prevents accidental overwriting of other important data.
• It establishes a permanent record of the progress made during long data entry sessions on the storage drive.

Additional Information

• AutoRecover Feature
• Excel includes an AutoRecover function that automatically saves a temporary copy of the workbook at specific intervals (default is 10 minutes).
• This feature is designed to recover files if the program closes unexpectedly before the user can save manually.
• AutoSave
• When a file is stored on OneDrive or SharePoint, the AutoSave feature saves changes in real-time as they are made.
• This minimizes the risk of losing even a few seconds of work during intensive data entry.
• File Extensions
• Standard Excel workbooks are saved with the .xlsx extension, while workbooks containing macros use .xlsm.
• Choosing the correct file format is essential for maintaining the integrity of complex data structures and scripts.
• Version Control
• Saving different versions of a file (e.g., "Data_Entry_V1", "Data_Entry_V2") acts as a manual backup strategy against file corruption or accidental deletions.

The correct answer is - Clear Contents clears only the data inside the cell, while Delete removes the cell itself and may shift surrounding cells

Key Points

• Clear Contents
• This command removes the data (text, numbers, or formulas) from the selected cell but leaves the cell itself intact.
• The formatting (such as borders, font color, or cell shading) and any attached comments usually remain in the worksheet.
• It does not cause any shifting of adjacent cells, rows, or columns.
• Delete Command
• The Delete command physically removes the selected cell(s) from the worksheet structure.
• When a cell is deleted, Excel must fill the resulting gap by shifting surrounding cells (typically up or to the left).
• Deleting a cell also removes everything associated with it, including its formatting and contents, because the cell object no longer exists at that address.

Additional Information

• Shift Options
• When using the Delete dialog box, users can choose to Shift cells left, Shift cells up, delete the Entire row, or delete the Entire column.
• Keyboard Shortcuts
• Pressing the Delete key on the keyboard typically performs the Clear Contents function for the selected range.
• The shortcut Ctrl + - (minus sign) is used to trigger the Delete dialog box to remove the physical cells.
• Clear All vs. Clear Contents
• The Clear All option in the Home tab removes data, formatting, comments, and hyperlinks, but like Clear Contents, it does not shift other cells.
• Clear Contents is the specific subset of the "Clear" menu that targets only the raw values or formulas.

The correct answer is - First line indent

Key Points

• First line indent
• This feature is found in the Paragraph dialog box under the "Special" indentation settings.
• It is used to shift only the first line of a paragraph to the right by a specific distance.
• All subsequent lines of the same paragraph remain aligned with the original left margin.
• It is a standard formatting requirement in many professional and academic writing styles to signal the start of a new paragraph.

Additional Information

• Hanging indent
• In a hanging indent, the first line starts at the margin, while all following lines in the paragraph are indented.
• This format is predominantly used for references, bibliographies, and works cited pages.
• Left indent
• This setting moves the entire paragraph (every line) away from the left margin toward the center.
• It is often used to set off block quotes or specific sections of text from the main body.
• Right indent
• This setting shifts the entire paragraph away from the right margin.
• Combining left and right indents allows a paragraph to be centered with wider margins on both sides.
• Paragraph Dialog Box
• Accessible via the Home tab or Layout tab in word processors like Microsoft Word.
• It controls alignment, spacing (line and paragraph), and indentation settings.

The correct answer is - Because it determines the order in which Excel performs operations and can change the final result

Key Points

• Operator precedence
• It defines the specific sequence in which Excel processes different parts of a mathematical formula.
• If a formula contains several operators, Excel performs calculations in a predetermined order, which can significantly alter the numerical output if not understood correctly.
• Using parentheses allows a user to override the default precedence, ensuring that specific parts of the formula are calculated first.
• Understanding this order is essential for troubleshooting complex formulas and ensuring the accuracy of data in spreadsheets.

Additional Information

• Standard Order of Evaluation
• Parentheses ( ): Calculations inside brackets are always performed first.
• Reference Operators: Operators like the colon (:), space (intersection), and comma (,) (union) are evaluated immediately after parentheses.
• Negation (-): Used to indicate negative numbers (e.g., -1).
• Percent (%): Converts a number to a percentage value.
• Exponentiation (^): Calculates the power of a number.
• Multiplication (*) and Division (/): These are evaluated from left to right.
• Addition (+) and Subtraction (-): These are evaluated last from left to right.
• Comparison Operators
• Operators such as equal to (=), greater than (>), and less than (<) have the lowest precedence.
• They are used to compare two values, resulting in a logical value of either TRUE or FALSE.