Search Previous Year Questions

The correct answer is - Show/Hide formatting marks

Key Points

• Show/Hide formatting marks
• The Show/Hide button, often represented by the Pilcrow symbol (¶), is located in the Paragraph group of the Home tab.
• It reveals non-printing characters such as spaces (dots), paragraph breaks (¶), and tab characters (arrows).
• This tool is essential for visualizing the exact structure of a document and troubleshooting layout issues caused by extra spaces or line breaks.
• The keyboard shortcut to toggle this feature is Ctrl + Shift + 8 (or Ctrl + *).

Additional Information

• Change Case
• Found in the Font group, this feature allows users to modify capitalization (e.g., lowercase, UPPERCASE, or Sentence case) without retyping text.
• Text Highlight Color
• This tool applies a vibrant color behind the text to make it stand out, functioning like a physical highlighter pen.
• It is primarily used to mark important information for editing or reviewing purposes.
• Clear All Formatting
• This button removes all styles, colors, and font changes from the selected text, resetting it to the default document style.
• It is highly effective when cleaning up text copied from websites or other documents with inconsistent formatting.

The correct answer is - The browser takes the URL in the link, sends a request to the target website server

Key Points

• HTTP Request Process
• When a user clicks a link, the browser acts as a client and identifies the URL associated with that link.
• The browser initiates a request specifically to the target website server where the page content is hosted.
• This communication typically uses the HTTP (Hypertext Transfer Protocol) or HTTPS (Secure) protocol.
• The server processes this request and sends back the necessary data for the browser to display.

Additional Information

• DNS Lookup
• Before connecting to the server, the browser uses the Domain Name System (DNS) to translate the human-readable domain name into a numeric IP address.
• This IP address is essential for routing the request across the internet to the correct physical server.
• Client-Server Architecture
• Web browsing is a classic example of the Client-Server model, where the browser (client) requests resources and the web server provides them.
• The search engine acts only as a directory or index; it does not host the actual content of the external sites it lists.
• HTTP Response and Rendering
• The server’s HTTP response usually contains HTML, CSS, and JavaScript files.
• The browser’s rendering engine then interprets these files to construct and display the final webpage on the user's screen.

The correct answer is - Google Search

Key Points

• Google Search
• It is a web search engine developed by Google, designed to find information on the World Wide Web.
• The engine functions by crawling (discovering pages), indexing (storing and organizing content), and ranking (displaying the most relevant results).
• It uses complex algorithms to provide users with links to websites, images, videos, and news based on specific keywords or queries.
• Unlike a browser, it is a service accessed through a website or application to locate data across the internet.

Additional Information

• Web Browsers
• Google Chrome and Mozilla Firefox are examples of web browsers, which are software applications used to access and view websites.
• A browser acts as an interface between the user and the internet, whereas a search engine is a tool used within a browser.
• Other popular browsers include Apple Safari, Microsoft Edge, and Opera.
• Search Engines
• Apart from Google, other notable search engines include Microsoft Bing, Yahoo! Search, DuckDuckGo, and Baidu.
• Communication Apps
• WhatsApp is an Instant Messaging (IM) platform and social media application used for communication, not for searching the public web.
• It provides end-to-end encryption for private text messages, voice calls, and video calls.

The correct answer is - To view and manage several different mailboxes from one interface

Key Points

• Centralized Management
• Desktop email clients allow users to consolidate multiple email accounts (such as personal, work, and school) into a single software application.
• This eliminates the need to open multiple web browsers or tabs to check different email providers.
• Users can perform tasks like searching across all accounts or moving messages between different mailboxes seamlessly.
• It streamlines the workflow by providing a consistent interface for managing various communications.

Additional Information

• Email Protocols
• IMAP (Internet Message Access Protocol): Allows the client to "sync" with the server, ensuring that changes made in the program are reflected on all devices.
• POP3 (Post Office Protocol): Typically downloads the email to the local storage and may remove it from the server.
• SMTP (Simple Mail Transfer Protocol): The primary protocol used by email clients for sending outgoing messages.
• Unified Inbox
• Many modern desktop clients offer a Unified Inbox feature that merges incoming mail from all configured accounts into one view.
• This feature helps in prioritizing unread messages regardless of which account they were sent to.
• Offline Access
• Desktop clients download and store emails locally, enabling users to read, search, and draft replies even without an active internet connection.
• Synchronized updates occur once the device reconnects to the network.

The correct answer is - Info

Key Points

• Info
• The Info option is found within the File tab (also known as the Backstage view) of Microsoft Excel.
• It displays comprehensive workbook properties such as file size, author, last modified date, and the time the document was last printed.
• This section provides the Protect Workbook command, which allows users to encrypt with a password, restrict access, or mark the file as final.
• It includes the Inspect Workbook tool to check the file for hidden metadata, personal information, or accessibility issues before sharing.
• Users can also manage different versions of the file and recover unsaved workbooks through this interface.

Additional Information

• Open
• Used to retrieve existing files from Local Folders, OneDrive, or the Recent documents list.
• Save As
• Allows the user to save a copy of the current workbook in a specific location or under a new file name.
• It provides options to change the file extension (e.g., from .xlsx to .csv or .xlsm).
• Export
• Facilitates the conversion of the Excel workbook into different formats like PDF/XPS documents.
• It allows users to Change File Type quickly without using the full Save As dialog.
• File Tab
• Introduced in Office 2010 to replace the Microsoft Office Button from the 2007 version.
• Clicking this tab takes the user out of the main editing interface into the Backstage view.

The correct answer is - Protect Workbook Structure

Key Points

• Protect Workbook Structure
• This command is specifically designed to maintain the integrity of the workbook's organization by preventing users from adding, deleting, hiding, or renaming worksheets.
• It ensures that the order of sheets remains fixed, which is critical for complex financial models that rely on specific sheet references.
• Unlike protecting a sheet, protecting the workbook structure allows data entry and editing within existing cells, provided the individual worksheets are not themselves protected.
• The feature can be accessed through the Review tab within the "Protect" group in Microsoft Excel.

Additional Information

• Protect Sheet
• Used to prevent changes to individual cell contents, formatting, or formulas within a specific worksheet.
• It allows the administrator to lock specific cells while leaving others (like input fields) unlocked for user interaction.
• Track Changes
• A collaborative tool used to record and highlight modifications made to the workbook by different users.
• It is primarily used for auditing and reviewing history rather than restricting structural or content changes.
• Password Protection
• When applying protection, users can set an optional password to prevent others from unprotecting the structure or sheets.
• This adds a layer of security, ensuring only authorized users can modify the file's configuration.
• Share Workbook
• An older Excel feature (replaced largely by Co-authoring) that allowed multiple users to work on the same file simultaneously, though it often placed restrictions on certain structural changes.

The correct answer is - Formula bar

Key Points

• Formula bar
• The Formula bar is a toolbar located at the top of the Microsoft Excel spreadsheet window, just below the ribbon.
• It is used to enter or edit formulas, text, or numbers in the active cell.
• Even if a cell is narrow and cannot display its full content, the Formula bar provides a dedicated space to view the entire value or logic.
• While the cell grid displays the calculated result of a formula, the Formula bar reveals the actual formula itself.

Additional Information

• Status bar
• Found at the bottom of the Excel window.
• Displays information about the current state of the worksheet, such as Page Numbers, and quick calculations like Sum, Average, and Count for selected cells.
• Includes the Zoom slider and View shortcuts (Normal, Page Layout, Page Break Preview).
• Title bar
• Located at the very top of the window.
• Shows the filename of the current workbook and the application name (Microsoft Excel).
• Contains the Minimize, Maximize/Restore, and Close buttons.
• Scroll bar
• Includes both vertical and horizontal bars.
• Used to navigate through a large worksheet that extends beyond the visible screen area.

The correct answer is - AutoCorrect

Key Points

• AutoCorrect
• It is a software feature that automatically detects and corrects misspelled words, common typos, and grammatical errors while the user is typing.
• The correction occurs immediately after the user presses the spacebar, the Enter key, or enters punctuation.
• It relies on a pre-defined AutoCorrect list that maps common mistakes (like "teh") to their correct forms (like "the").
• In addition to spelling, it can automatically fix capitalization errors, such as capitalizing the first letter of a sentence.

Additional Information

• Spell Checker
• A tool that scans a document and compares words against a built-in dictionary.
• Unlike AutoCorrect, it typically flags errors using a red wavy underline and often requires the user to manually select a correction from a list of suggestions.
• Thesaurus
• An software tool used to look up synonyms (words with similar meanings) and antonyms (words with opposite meanings).
• It is primarily used to enhance vocabulary and avoid word repetition within a document.
• AutoSummarize
• A legacy feature in word processors like Microsoft Word that identifies the key points of a document.
• It analyzes the text and assigns scores to sentences based on the frequency of keywords to generate a summary.

The correct answer is - Use the Change Case command on the selected paragraph and choose the UPPERCASE option

Key Points

• Change Case command
• The Change Case feature in word processing software (like Microsoft Word) allows users to modify the capitalization of text without the need to retype any content.
• Selecting the UPPERCASE option specifically converts every letter in the highlighted selection into capital letters instantly.
• This approach is the most efficient and consistent method for applying emphasis to specific sections of a document.
• In most interfaces, this command is represented by an 'Aa' icon located within the Font group of the Home tab.

Additional Information

• Types of Case Options
• Sentence case: Capitalizes only the first letter of the first word in a sentence.
• lowercase: Removes all capital letters from the selected text.
• Capitalize Each Word: Also known as Title Case, it capitalizes the first letter of every word.
• tOGGLE cASE: Switches the current case of every character (capitals become lowercase and vice versa).
• Keyboard Shortcuts
• The Shift + F3 shortcut is a quick way to cycle through different case options (Sentence case, UPPERCASE, and lowercase) for selected text.
• AutoCorrect Feature
• AutoCorrect is designed to fix common typos and automatically capitalize specific words, such as days of the week and months of the year, based on built-in dictionaries.

The correct answer is - The formula is trying to divide a number by zero or by an empty cell

Key Points

• #DIV/0! Error
• The #DIV/0! error occurs specifically when a formula attempts to divide a number by zero (0).
• It is also triggered when a formula refers to a blank or empty cell as the divisor, as Excel treats an empty cell as zero in this context.
• In mathematics, division by zero is undefined, and Excel uses this error code to indicate that the calculation cannot be performed.
• This error is commonly resolved by ensuring the divisor is not zero or by using the IFERROR function to manage the output.

Additional Information

• #NAME? Error
• Occurs when Excel does not recognize text within a formula, such as a misspelled function name (e.g., =SUMM instead of =SUM).
• It can also appear if a named range is referenced incorrectly or if text is not enclosed in double quotation marks.
• #VALUE! Error
• Indicates that the formula contains the wrong type of argument or operand.
• This most frequently happens when mathematical operations are performed on cells containing text strings instead of numerical values.
• #REF! Error
• Stands for Reference error and occurs when a formula refers to a cell that is no longer valid.
• This usually happens when the cells, rows, or worksheets used in the formula have been deleted.
• #N/A Error
• Stands for Not Available, meaning the formula cannot find the value it is tasked to search for.
• It is very common in lookup functions such as VLOOKUP, HLOOKUP, and MATCH when no match is found.