Search Previous Year Questions

p>The correct answer is - Vertical scroll bar

Key Points

• Vertical scroll bar
• The vertical scroll bar is located on the right side of the document window in most word processors and web browsers.
• It is specifically designed to allow users to move up and down through a document when the text or content is longer than the visible area.
• It contains a scroll box (or thumb) that can be dragged to navigate quickly to different sections of the document.
• The length of the scroll box often represents the proportion of the document currently visible on the screen.

Additional Information

• Horizontal scroll bar
• Appears at the bottom of the document window.
• It is used to move the view left and right when the document is wider than the display screen.
• Status bar
• Found at the bottom of the window, it displays information such as page numbers, word count, and view modes.
• It often includes the status indicator which shows the current state of the document or background tasks.
• Zoom control
• Located on the status bar, it allows users to increase or decrease the magnification of the document.
• Adjusting zoom helps in viewing fine details or seeing a full-page layout.

The correct answer is - Keep Text Only

Key Points

• Keep Text Only
• This option strips away all original formatting such as fonts, colors, and hyperlinks from the source website.
• It ensures that the pasted text automatically adopts the destination formatting (the font and style of the document it is being pasted into).
• It is the most effective way to maintain a consistent look throughout a Microsoft Word document when gathering data from multiple sources.

Additional Information

• Keep Source Formatting
• This option preserves the exact look of the original text, including its web-based CSS styles, sizes, and font families.
• It is often used when the user wants to retain the visual identity of the original source.
• Merge Formatting
• This feature changes the font and style to match the destination document but preserves emphasis like bold, italics, and list structures.
• It serves as a middle ground between keeping everything and removing everything.
• Paste as Picture
• This converts the copied text into a graphic image rather than editable text.
• Once pasted as a picture, the content cannot be modified or searched within the Word document using the standard text tools.

The correct answer is - Uploading

Key Points

• Uploading
• It refers to the process of sending data or a file from a local computer to a remote system, such as a server or another computer over a network.
• Common examples include posting photos to social media, sending an email attachment, or saving documents to cloud storage like Google Drive or Dropbox.
• In most residential internet connections, the upload speed is typically slower than the download speed.
• This process is essential for data sharing and web content creation.

Additional Information

• Downloading
• The opposite of uploading; it involves receiving data or a file from a remote server onto a local device.
• Examples include saving a PDF from a website or installing software from the internet.
• Streaming
• A method of transmitting or receiving data (especially video or audio) over a computer network as a continuous, steady flow.
• Unlike downloading, the user can start using the content before the entire file is transmitted.
• File Transfer Protocol (FTP)
• A standard network protocol used specifically for the transfer of files between a client and a server on a computer network.
• It is a common method used for uploading website files to a web server.
• Bandwidth
• The maximum rate of data transfer across a given path, which affects how quickly files can be uploaded or downloaded.

The correct answer is - Because an incorrect URL may lead to a fraudulent site designed to steal information

Key Points

• Phishing attacks
• Verifying a URL is the primary defense against phishing, where attackers create fake websites to mimic legitimate ones.
• Cybercriminals often use typosquatting (registering domains with common misspellings) to trick users into entering confidential data.
• Incorrect URLs are designed to harvest sensitive information such as login credentials, financial details, and personal identification.
• Ensuring the domain name is correct prevents the accidental transfer of data to unauthorized or malicious servers.

Additional Information

• HTTPS and SSL/TLS
• The presence of HTTPS (Hypertext Transfer Protocol Secure) indicates that the communication between the browser and the server is encrypted.
• A padlock icon in the address bar signifies that the site has a valid SSL/TLS certificate, though it does not guarantee the site is not fraudulent.
• URL Structure
• Users should examine the root domain carefully; attackers may use subdomains (e.g., legitimatebrand.com.malicioussite.com) to deceive users.
• URL shorteners can hide the final destination, making it difficult to verify the authenticity of a site before clicking.
• Browser Security Features
• Modern browsers include anti-phishing filters and Safe Browsing lists to block known fraudulent sites.
• Despite these automated tools, manual URL verification remains a critical component of cybersecurity hygiene.

The correct answer is - Information such as average of selected cells, view, zoom details

Key Points

• Status Bar
• The Status Bar is a horizontal bar located at the very bottom of the MS Excel window.
• It displays real-time AutoCalculate results for selected cells, such as Average, Count, Numerical Count, Minimum, Maximum, and Sum.
• It contains View Shortcuts that allow users to toggle between Normal view, Page Layout view, and Page Break Preview.
• The Zoom Slider and the Zoom level percentage are situated on the right side of the status bar to adjust worksheet magnification.
• It can be customized by right-clicking anywhere on the bar to enable or disable specific status indicators like Caps Lock or Num Lock status.

Additional Information

• Title Bar
• Located at the top of the window, it displays the workbook name (e.g., Book1) and the application name.
• It houses the Quick Access Toolbar and the window control buttons (Minimize, Maximize/Restore, and Close).
• Formula Bar
• Situated below the ribbon, it is used to enter or edit data and formulas in the active cell.
• The Name Box is located to the left of the Formula Bar and displays the cell reference of the active cell.
• Ribbon
• The primary user interface element containing tabs (like Home, Insert, Page Layout) that organize commands into logical groups.

The correct answer is - It improves readability, gives a professional appearance

Key Points

• Consistent formatting
• Applying uniform text alignment, fonts, and number formats ensures that the worksheet is visually organized and easy to navigate.
• It significantly improves readability, allowing stakeholders to quickly scan, compare, and interpret the data without confusion.
• Consistency conveys a professional appearance, which is essential for business reporting and collaborative environments.
• It helps establish a clear visual hierarchy, making it easier to distinguish between headers, sub-headers, and raw data.

Additional Information

• Text Alignment
• Standard spreadsheet logic often involves left-aligning text labels and right-aligning numbers to facilitate easier mathematical comparison.
• Proper alignment prevents the data from looking "jagged," which reduces cognitive load for the reader.
• Number Formats
• Consistent use of currency symbols, percentage signs, and decimal places ensures that the context of the numbers is immediately understood.
• Uniformity in date formats prevents ambiguity, especially when worksheets are shared across different geographical regions.
• Font Usage
• Using a single font family maintains aesthetic harmony across multiple tabs or sheets within a workbook.
• Varying font styles (like bold or italics) should be used purposefully to highlight key metrics or summary totals rather than randomly.

The correct answer is - It displays all amounts in a uniform style, making mistakes easier to spot

Key Points

• Visual Consistency
• Applying a uniform number format ensures that decimal points, thousands separators, and currency symbols are aligned vertically.
• Consistency allows for easier visual scanning, making it simple to compare values and identify anomalies or data entry errors.
• Standardized formatting reduces cognitive load, as the user does not have to mentally adjust for different styles (e.g., varying decimal places) while reviewing.
• Error Identification
• When numbers are not formatted consistently, an extra digit or a misplaced decimal point can easily be overlooked.
• Uniform styles highlight outliers or values that do not belong in the set, facilitating faster auditing and verification of financial data.

Additional Information

• Accounting Format
• The Accounting format is a specific number format that aligns the currency symbols and decimal points of numbers in a column.
• It displays zero values as dashes and encloses negative numbers in parentheses, which is a standard practice in professional financial reporting.
• Cell Formatting vs. Cell Value
• It is important to note that changing the number format only changes how the data looks, not the actual value stored in the cell.
• Consistent formatting ensures that formulas and functions (like SUM or AVERAGE) produce predictable results across the dataset.
• Custom Number Formats
• Users can create Custom Number Formats to handle specific data types like phone numbers, ZIP codes, or specialized units of measure while maintaining visual uniformity.

The correct answer is - Select all the required cells, type the heading and then press Ctrl + Enter

Key Points

• Ctrl + Enter
• The Ctrl + Enter shortcut is the standard method in Excel to enter the same data into multiple selected cells at the same time.
• This function works for both adjacent and non-adjacent cell selections.
• When you type into the active cell of a selection and press this shortcut, Excel automatically duplicates that entry into every other highlighted cell.
• It is particularly useful for applying the same formula or heading across a disparate range without using copy-paste.

Additional Information

• Selecting Non-Adjacent Cells
• To select cells that are not next to each other, you must hold down the Ctrl key while clicking on the individual cells or ranges.
• Fill Handle
• The Fill Handle is the small green square in the bottom-right corner of a selected cell; dragging it copies data to contiguous (adjacent) cells only.
• Fill Shortcuts
• Ctrl + D (Fill Down) is used to copy the content and format of the topmost cell of a selected range into the cells below it.
• Ctrl + R (Fill Right) is used to copy the content and format of the leftmost cell of a selected range into the cells to the right.
• Active Cell
• In a multiple-cell selection, the active cell is the one that remains white (unshaded) while the others are highlighted; this is where the initial typing occurs.

The correct answer is - Ctrl + Backspace

Key Points

• Ctrl + Backspace
• This shortcut is used to delete the entire word located to the left of the insertion point (cursor).
• It is widely supported in most text editing software, including Microsoft Word, Notepad, and modern web browsers.
• Using this combination significantly improves typing efficiency by avoiding multiple presses of the standard Backspace key.
• The command identifies the word boundary (usually defined by spaces or punctuation) to determine the segment to be removed.

Additional Information

• Ctrl + Delete
• This key combination deletes the entire word to the right of the insertion point.
• It functions similarly to Ctrl + Backspace but operates in the opposite direction.
• Standard Deletion Keys
• Backspace: Deletes a single character to the left of the cursor.
• Delete: Deletes a single character to the right of the cursor.
• Navigation Shortcuts
• Ctrl + Left Arrow: Moves the cursor to the beginning of the previous word.
• Ctrl + Right Arrow: Moves the cursor to the beginning of the next word.
• Ctrl + Shift + Arrow Keys: Used to highlight/select entire words at a time.

The correct answer is - Absolute column and relative row

Key Points

• Mixed Cell Reference
• The notation $C7 is a mixed reference because it combines an absolute component and a relative component.
• The dollar sign ($) appearing before the column letter (C) denotes an absolute column, meaning the column reference remains fixed when a formula is copied across columns.
• The row number (7) lacks a dollar sign, making it a relative row, which means the row reference will change automatically if the formula is copied up or down to different rows.
• In Excel, cell references are used to tell the software where to look for the data or values to be used in a formula.

Additional Information

• Relative Reference
• Represented as C7 (no dollar signs).
• When copied, both the column letter and the row number adjust based on the relative position of the destination cell.
• Absolute Reference
• Represented as $C$7 (dollar signs before both column and row).
• The reference remains constant and does not change, no matter where the formula is copied or moved.
• Other Mixed Reference
• Represented as C$7.
• In this instance, the column is relative (changes when copied horizontally) and the row is absolute (stays fixed when copied vertically).
• Function Key F4
• The F4 key is the standard keyboard shortcut in Excel used to toggle between relative, absolute, and mixed cell references$.