Search Previous Year Questions

The correct answer is - Entering, editing, formatting and saving text using a computer program

Key Points

• Word Processing
• It refers to the act of using a computer to create, edit, format, and print documents.
• Unlike manual writing, it allows for the manipulation of text, such as moving, deleting, or changing the appearance of words without re-writing the entire page.
• A word processor provides a digital workspace where users can perform saving operations to store documents in the computer's memory or external storage.
• It is the primary function of applications like MS Word, which offer tools for sophisticated document creation.

Additional Information

• Microsoft Word
• Developed by Microsoft, it is a graphical word processing program that users can use to type and save documents.
• It features advanced tools like Spell Check, Grammar Check, and Thesaurus to improve writing quality.
• Common file extensions for MS Word documents include .doc and .docx.
• Formatting Tools
• Refers to the visual style of the document, including font style, size, color, and paragraph alignment.
• Advanced formatting includes the use of headers, footers, page numbers, and tables.
• Text Editors vs. Word Processors
• Text Editors (like Notepad) handle only plain text and lack complex formatting capabilities.
• Word Processors provide a "What You See Is What You Get" (WYSIWYG) interface for professional document layout.

The correct answer is - Cloud synchronisation keeps a copy on the remote service that can be downloaded again

Key Points

• Cloud synchronisation
• It involves the process of ensuring that files on a local device and a remote server are identical.
• When a document is synchronised, a copy is maintained in the cloud infrastructure, which is independent of the local hardware.
• If the local copy is deleted, the version stored on the service provider's remote database remains accessible for restoration.
• Most cloud services feature a Trash or Recycle Bin for a specific period, preventing immediate permanent loss during a sync event.

Additional Information

• Cloud Storage Services
• Common platforms include Google Drive, Microsoft OneDrive, and Dropbox.
• These services use Data Redundancy to ensure that user files are stored across multiple physical servers to prevent data loss.
• Data Recovery and Versioning
• File Versioning allows users to recover previous drafts of a document, even if the current version was overwritten or corrupted.
• Recovery is possible because the cloud provider manages the file lifecycle separately from the local Operating System.
• Two-way vs. One-way Sync
• In two-way synchronisation, changes made on one device are reflected on all others; however, safety mechanisms like "Soft Delete" usually protect against accidental local deletion.
• In one-way synchronisation (backup), the file is simply uploaded to the cloud and is not affected by changes or deletions on the local machine.

The correct answer is - A worldwide network of interconnected computers and devices that communicate using standard protocols

Key Points

• Internet Definition
• The internet is a global system of interconnected computer networks that use the Internet Protocol Suite (TCP/IP) to communicate between devices.
• It is often described as a network of networks, linking millions of private, public, academic, business, and government networks.
• It carries a vast range of information resources and services, such as the World Wide Web, electronic mail, and file sharing.
• No single organization owns or controls the entire internet; it is a decentralized infrastructure.

Additional Information

• TCP/IP Protocol
• TCP (Transmission Control Protocol) ensures that data is delivered accurately and in the correct order.
• IP (Internet Protocol) handles the addressing and routing of data packets to their destination.
• World Wide Web (WWW)
• Often confused with the internet, the WWW is actually an information space where documents and other web resources are identified by URLs.
• It operates as an application layer service on top of the physical infrastructure of the internet.
• History and Origin
• The origins of the internet date back to ARPANET, a project funded by the U.S. Department of Defense in the late 1960s.
• The adoption of TCP/IP in 1983 became the standard that allowed different networks to merge into the modern internet.
• IP Address
• Every device connected to the internet is assigned a unique numerical label called an IP Address, which serves for host identification and location addressing.

The correct answer is - https://banksite.com/login

Key Points

• HTTPS (Hypertext Transfer Protocol Secure)
• HTTPS is the secure version of HTTP, which is the primary protocol used to send data between a web browser and a website.
• It is specifically designed to provide encrypted communication and secure identification of a network web server.
• Banking sites use HTTPS to ensure that sensitive data like login credentials, account numbers, and transaction details are protected from hackers.
• The presence of "https://" at the beginning of a URL indicates that the site is using an SSL/TLS certificate to encrypt the session.

Additional Information

• HTTP (Hypertext Transfer Protocol)
• Unlike HTTPS, standard HTTP does not encrypt data, meaning information is sent in plain text.
• Data transmitted via HTTP can be easily intercepted by third parties, making it unsuitable for secure transactions.
• FTP (File Transfer Protocol)
• FTP is a standard network protocol used for the transfer of computer files between a client and server on a computer network.
• It is not intended for web browsing or accessing interactive banking portals.
• mailto:
• The mailto scheme is used to create hyperlinks that lead to an email address rather than a website URL.
• When clicked, it typically opens the user's default email client to compose a new message.
• SSL/TLS Encryption
• HTTPS relies on Transport Layer Security (TLS) (formerly Secure Sockets Layer - SSL) to encrypt communications.
• This protocol provides data integrity (preventing modification during transfer) and authentication (proving the user is communicating with the intended website).

The correct answer is - To contain the main text and detailed message content

Key Points

• Primary Purpose
• The body section of an email is the designated area for the actual message or narrative intended for the recipient.
• It is used to hold detailed information, explanations, and any relevant text-based communication.
• The body supports formatting options like bolding, italics, bullet points, and hyperlinks when using HTML format.
• It is distinct from the header, which is reserved for technical and routing information.

Additional Information

• Email Header Fields
• To: Specifies the email address of the primary recipient.
• From: Displays the email address of the sender.
• Subject: A brief summary that identifies the topic of the email.
• Date/Time: Automatically recorded by the mail server to show when the email was dispatched.
• CC and BCC
• CC (Carbon Copy): Used to send the message to secondary recipients whose addresses are visible to all.
• BCC (Blind Carbon Copy): Sends the message to recipients without their email addresses being visible to others.
• Email Attachments
• Refers to external files (documents, images, spreadsheets) that are uploaded and sent alongside the message but are not part of the body text.
• Email Signature
• A standardized block of text at the end of the message area containing the sender's contact information or professional disclaimer.

The correct answer is - Dragging the column boundary to the right on the column header

Key Points

• Column Header
• The column header is the horizontal row at the top of a spreadsheet containing letters (A, B, C, etc.) that identify each column.
• To increase the width, the user must position the mouse pointer on the right boundary of the column letter until the cursor changes into a double-headed arrow.
• Dragging this boundary to the right manually increases the visible space, ensuring that long text or numbers are fully displayed.
• This action directly modifies the column width property of the selected column without affecting other structural elements like gridlines.

Additional Information

• AutoFit Feature
• Double-clicking the column boundary on the header automatically adjusts the width to fit the longest entry in that specific column.
• This is an efficient alternative to manual dragging for handling varied content lengths.
• Number Formatting Issues
• In software like Microsoft Excel, if a numerical value is too long for the column width, it often displays as series of hash symbols (#####).
• Increasing the column width is the primary solution to reveal the hidden numerical data.
• Wrap Text
• Wrap Text is a formatting option that allows long text to appear on multiple lines within the same cell.
• This increases the row height instead of the column width to make the content visible.
• Row Height Adjustment
• Similar to columns, row height can be increased by dragging the boundary between row numbers on the left side of the worksheet.

The correct answer is - Groups related data in one file

Key Points

• Data Organization
• Using multiple worksheets allows a user to group related data within a single spreadsheet file, which improves logical structure.
• It prevents the clutter of having dozens of separate workbook files on a hard drive for the same project or period.
• Users can categorize data by time (e.g., January, February) or by category (e.g., Sales, Expenses) within individual tabs.
• Ease of Navigation
• Switching between worksheets using the tabs at the bottom is faster than opening and switching between different Excel windows.
• It facilitates cross-referencing, where formulas in one sheet can easily pull values from another sheet within the same file.

Additional Information

• Workbook vs. Worksheet
• A Workbook is the entire Excel file (usually with an .xlsx extension) that serves as a container.
• A Worksheet (or spreadsheet) is a single page or "tab" inside the workbook where data is entered into cells.
• Scalability
• Modern spreadsheet software like Microsoft Excel or Google Sheets allows for a very large number of worksheets in one file, limited primarily by the computer's available memory.
• Each worksheet maintains its own grid of rows and columns, ensuring that grouping data does not reduce the available space for data entry.
• Data Integrity
• Keeping related tables in one file ensures that links and formulas remain intact even if the file is moved to a different folder or shared with others.
• External links between separate workbooks are prone to breaking if file names or paths are changed.

The correct answer is - The name makes formulas more readable and allows the input to be moved without rewriting every formula

Key Points

• Named Ranges
• Converting a cell reference into a Named Range (e.g., "TaxRate") significantly improves Formula Readability by using descriptive language instead of abstract coordinates like $A$1.
• When an input cell is assigned a name, the spreadsheet software treats that name as a Permanent Reference, making it easier for users to audit and debug complex calculations.
• If the physical location of the input cell changes (e.g., moving it from cell A1 to B10), the Named Range automatically tracks the move, ensuring that every formula using that name remains valid without manual editing.
• This practice facilitates efficient maintenance of financial models and data sheets where key variables (like interest rates or tax percentages) are used across multiple worksheets.

Additional Information

• Absolute Referencing
• By default, Named Ranges act as absolute references. This means when a formula containing a named range is copied or dragged to other cells, the reference to the "TaxRate" does not shift.
• This eliminates the need to manually add dollar signs ($) to lock cell addresses in formulas.
• Scope of Names
• A Named Range can have a Workbook scope, allowing it to be recognized on any sheet within the file, or a Worksheet scope, limiting its use to a specific tab.
• Using a workbook-level scope prevents the need to include sheet names (e.g., 'Settings'!A1) in formulas, further simplifying Formula Editing.
• Name Manager
• Spreadsheet applications include a Name Manager tool that allows users to view, edit, and delete all Defined Names in one centralized location.
• This tool is essential for organizing data and ensuring that no two ranges have conflicting names$.

The correct answer is - Many formatting settings are stored with the paragraph mark

Key Points

• Paragraph mark
• In MS Word, the paragraph mark (¶) acts as a container that stores all the formatting instructions applied to that specific paragraph.
• Formatting attributes such as alignment (left, right, center, justified), line spacing, indents, and tab stops are embedded within this mark.
• When you delete a paragraph mark, the text before it merges with the next paragraph and inherits the formatting of the mark belonging to the combined paragraph.
• Maintaining these marks is essential for preserving the intended layout and structure of a document.

Additional Information

• Non-printing characters
• The paragraph mark is one of several non-printing characters, which are symbols that help with document editing but do not appear in the printed output.
• The symbol used for the paragraph mark is called the Pilcrow (¶).
• Other examples include dots representing spaces and arrows representing tab characters.
• Show/Hide Button
• Users can toggle the visibility of these marks using the Show/Hide (¶) button located in the Paragraph group of the Home tab.
• This feature is useful for troubleshooting spacing issues or identifying unexpected section breaks or page breaks.

The correct answer is - #N/A

Key Points

• #N/A Error
• The #N/A error stands for "Not Available" and is specifically triggered when a formula cannot find what it is asked to look for.
• It is most commonly encountered with lookup functions such as VLOOKUP, HLOOKUP, LOOKUP, and MATCH.
• This error occurs when the lookup_value does not exist within the first column or row of the table_array or lookup_range.
• It can also be intentionally produced using the NA() function to indicate that data is missing.

Additional Information

• #DIV/0!
• This error appears when a formula attempts to divide a number by zero (0) or by an empty cell.
• #VALUE!
• Occurs when there is a mismatch in the type of data expected; for example, trying to perform mathematical operations on cells containing text.
• #REF!
• Stands for Reference error; it occurs when a formula refers to a cell that is not valid, usually because the row, column, or worksheet was deleted.
• #NAME?
• This error occurs when Excel does not recognize text in a formula, often due to a misspelled function name or a named range that does not exist.