Search Previous Year Questions

The correct answer is - The text scrolls down to later content

Key Points

• Scrolling Down
• When a user rolls the mouse wheel toward themselves (downward motion), the software application triggers a vertical scroll.
• This action shifts the viewport down, making the later content or bottom part of the document visible.
• It is the standard navigational behavior in operating systems like Windows and macOS (unless "natural scrolling" is toggled in settings).
• This movement allows for efficient reading and navigation through lengthy documents or web pages without using the scroll bar.

Additional Information

• Scrolling Up
• Rolling the mouse wheel away from the user moves the document view toward the top or earlier content.
• Zooming Functionality
• In most applications, holding the Ctrl key while rolling the mouse wheel acts as a shortcut for zooming in or zooming out.
• Rolling forward/away typically increases the magnification, while rolling backward/toward decreases it.
• Middle Click / Auto-Scroll
• Pressing down on the mouse wheel (acting as a button) often enables auto-scroll mode.
• Once activated, moving the mouse cursor up or down allows the user to scroll through the document at varying speeds without further rolling.
• Horizontal Scrolling
• Some advanced mice feature a tilt-wheel or a secondary thumb wheel to perform horizontal scrolling (left to right).
• In many browsers and editors, holding Shift + Scroll achieves the same horizontal movement.

The correct answer is - Clear All Formatting

Key Points

• Clear All Formatting
• This command removes all styles, font types, sizes, colors, and other formatting effects from the selected text.
• It is located in the Font group on the Home tab of the MS Word ribbon.
• The icon is typically represented by a capital letter 'A' with an eraser symbol.
• When applied, the text reverts to the default font and style settings defined in the document's Normal style.
• The keyboard shortcut to remove character-level formatting from selected text is Ctrl + Spacebar.

Additional Information

• Change Case
• Used to modify the capitalization of selected text to Sentence case, lowercase, UPPERCASE, Capitalize Each Word, or tOGGLE cASE.
• Select All
• A command used to highlight all text, images, and objects within a document simultaneously, typically executed using Ctrl + A.
• Find and Replace
• A feature that allows users to search for specific text or formatting throughout a document and replace it with a different entry; accessed via Ctrl + H.
• Format Painter
• A tool used to copy formatting from one piece of text and apply it to another, ensuring consistency across a document.

The correct answer is - To adjust to limited available bandwidth and maintain a stable connection

Key Points

• Bandwidth Optimization
• Video conferencing applications use algorithms to monitor network throughput in real-time.
• When available bandwidth drops, the application automatically lowers the video resolution to prevent the call from dropping or freezing.
• This ensures that audio data, which requires less bandwidth but is more critical for communication, remains clear.
• Connection Stability
• High-definition video consumes significant data; reducing quality lowers the bitrate, which helps maintain a stable connection on congested or weak networks.
• This process is often referred to as Dynamic Bitrate Scaling.

Additional Information

• Bandwidth
• Refers to the maximum capacity of a network link to transmit data over a specific period, usually measured in Mbps (Megabits per second).
• Insufficient bandwidth leads to buffering and pixelated video in real-time applications.
• Latency and Jitter
• Latency is the delay in data transmission, while Jitter is the variation in that delay.
• Lowering video quality reduces the amount of data processed, which can help mitigate the effects of high latency.
• Video Codecs
• Applications use codecs (like H.264 or VP9) to compress and decompress video data.
• Modern codecs are designed to scale quality efficiently based on CPU usage and network speed.
• Packet Loss
• Occurs when units of data fail to reach their destination. High data loads on weak networks increase packet loss, making quality reduction necessary.

The correct answer is - Send requests to web servers and display web pages on the screen

Key Points

• Web Browser Functionality
• A web browser is a software application specifically designed to access and view content on the World Wide Web.
• It functions by sending HTTP or HTTPS requests to a web server using the internet.
• The browser receives data (code) from the server and renders it, converting HTML, CSS, and JavaScript into a readable visual format.
• It serves as the primary user interface for navigating between different websites via hyperlinks.

Additional Information

• Client-Server Architecture
• In the context of the internet, the browser acts as the client, while the computer hosting the website acts as the server.
• The request-response cycle is the fundamental method by which data is exchanged between the browser and the server.
• URL and DNS
• A URL (Uniform Resource Locator) is the web address typed into the browser's address bar to locate a specific resource.
• The browser uses the DNS (Domain Name System) to translate human-readable domain names into IP addresses.
• Common Web Browsers
• Major examples include Google Chrome, Mozilla Firefox, Microsoft Edge, and Safari.
• These applications differ from search engines (like Google or Bing), which are websites used to find information, rather than the software used to access the web itself.

The correct answer is - To maintain a list of frequently used email addresses and related details

Key Points

• Address Book
• The primary function is to act as a database for storing contact details, making it easier to manage communications.
• It eliminates the need to manually type lengthy or complex email addresses every time a message is sent.
• Users can store additional information beyond just email addresses, such as phone numbers, physical addresses, and job titles.
• It enables the auto-complete feature, where the email client suggests addresses as the user begins typing in the "To" field.

Additional Information

• Distribution Lists
• An address book allows the creation of contact groups or mailing lists, enabling a single email to be sent to multiple people at once.
• Synchronization
• Modern email applications synchronize the contacts list across various devices like smartphones, tablets, and desktop computers.
• Import and Export
• Contacts can usually be moved between different email providers using standard file formats like CSV (Comma Separated Values) or vCard (.vcf).
• Email Management Folders
• Inbox: This folder is specifically designed to store incoming messages, not the address book.
• Drafts: Used to save messages that have been started but not yet sent.
• Trash/Bin: A temporary storage area for deleted messages before they are permanently removed.

The correct answer is - It makes it easier to locate messages related to specific topics or tasks

Key Points

• Email Organization
• Organizing emails using folders or labels allows users to categorize communications based on projects, senders, or urgency.
• The primary advantage is improved searchability, enabling users to retrieve specific information without scanning through hundreds of unrelated messages in the inbox.
• This systematic structure helps in maintaining a clean inbox (often referred to as Inbox Zero) and boosts overall productivity.
• Unlike physical storage, digital folders do not change the storage capacity of the mailbox but manage the logical structure of the data.

Additional Information

• Folders vs. Labels
• Folders: Typically used in systems like Microsoft Outlook, where an email can exist in only one location at a time.
• Labels: Used in services like Gmail, allowing multiple tags to be applied to a single message, meaning an email can appear under several categories simultaneously.
• Filters and Rules
• Users can set up automated rules or filters to direct incoming mail into specific folders automatically based on keywords or sender addresses.
• Archiving
• Archiving moves messages out of the primary inbox view into a general storage area, preserving the data without the need for deletion.

The correct answer is - Headings describe the data in each column

Key Points

• Data Description
• Column headings act as labels that provide a clear description of the information stored in each vertical column.
• They allow users to quickly identify the category or attribute of the data, such as "Name", "Date", or "Price".
• Clear headings are essential for data organization, ensuring that the worksheet remains meaningful to both the creator and other users.
• Without headings, raw data in a worksheet becomes difficult to interpret, especially in large datasets.

Additional Information

• Data Management Features
• Features like Sorting and Filtering rely on column headings to define the criteria for organizing data.
• When creating a PivotTable, spreadsheet software uses the top row of headings to generate field names.
• Structured References
• In specialized table objects, headings are used as structured references in formulas (e.g., Summing the "Total" column), making calculations easier to audit.
• Using Freeze Panes on the top row ensures that headings remain visible even when scrolling down through thousands of rows.
• Visual Formatting
• Applying Bold or Borders to the header row helps visually distinguish metadata from the actual data entries.
• Standardized headings improve data integrity by guiding the user to enter the correct type of information in the correct place.

The correct answer is - Overwriting replaces the previous version

Key Points

• Overwriting
• When a user selects the Save command on an existing file, the system overwrites the previous version, meaning the old data is replaced by the current session's data.
• This action is permanent once the application is closed, making it impossible to retrieve the prior state of the file unless backups exist.
• Understanding this is vital for data integrity, as it prevents the accidental loss of original information when making experimental changes.
• Saving with a New Name
• Using the Save As command allows the user to store the workbook under a different filename.
• This process creates a duplicate file, leaving the original file untouched and preserved in its last saved state.

Additional Information

• File Management and Versioning
• Version control is a practice where users save multiple copies of a file (e.g., v1, v2) using Save As to track progress and maintain history.
• In many spreadsheet applications like Microsoft Excel, the F12 key serves as a shortcut for the Save As dialog box.
• File Formats
• The Save As feature is also used to change the file extension or format, such as converting a workbook to a PDF, CSV, or an older version of the software.
• Overwriting generally maintains the existing file format, whereas saving with a new name provides the option to modify the file type.

The correct answer is - A new blank row is inserted above the selected row and existing rows shift down

Key Points

• Insert Row Operation
• When a user selects an entire row and chooses the Insert command, the spreadsheet software creates a new blank row at the position of the current selection.
• The existing data in the selected row and all subsequent rows are shifted down to make room for the new entry.
• This operation ensures that no data is overwritten or lost; it simply re-positions existing content.
• The new row typically adopts the formatting of the row above it or the row that was shifted down.

Additional Information

• Column Insertion
• Similar to rows, selecting an entire column and clicking Insert will place a new blank column to the left of the selection.
• All existing columns from the selection point onwards are shifted to the right.
• Delete vs. Clear Contents
• The Delete operation removes the selected row entirely and shifts the data upwards to fill the gap.
• The Clear Contents command removes the data (text/numbers) from the cells but the row structure remains empty and in its original place.
• Keyboard Shortcuts
• In many spreadsheet programs like Microsoft Excel or Google Sheets, the shortcut Ctrl + Plus (+) can be used to insert rows or columns once they are selected.
• Conversely, Ctrl + Minus (-) is used to delete the selected rows or columns.

The correct answer is - AutoSave

Key Points

• AutoSave
• This is a feature available in cloud-integrated applications like Microsoft 365 (Word, Excel, PowerPoint) and Google Workspace.
• It automatically saves changes in real-time as the user types, provided the document is stored on a cloud service like OneDrive, SharePoint, or Google Drive.
• Its primary purpose is to ensure that the latest version of the work is preserved, preventing data loss during unexpected system shutdowns or crashes.
• Unlike traditional saving, it eliminates the need for the user to manually click the 'Save' button frequently.

Additional Information

• AutoCorrect
• A software function that automatically identifies and fixes misspelled words and typos.
• It can also be used to quickly insert symbols or formatted text using shorthand codes.
• AutoRecover
• Often confused with AutoSave, AutoRecover saves a temporary backup of a file at specific time intervals (e.g., every 10 minutes) to a local drive.
• It is used to recover files if the application crashes before the user could save the file manually.
• AutoFormat
• A feature that automatically applies formatting to text as you type, such as creating bulleted lists, converting fractions, or applying border lines.
• It helps in maintaining a consistent layout without manual intervention.
• AutoSummarize
• A legacy feature in older versions of word processors that attempted to identify the key points of a document to create a summary.
• It analyzed word frequency and sentence structure to highlight the most important parts of the text.