Computer Knowledge PYQs

Concept

• An IP Address (Internet Protocol address) is a unique numerical label assigned to each device connected to a computer network that uses the Internet Protocol for communication.
• Static IP addresses are permanent and manually assigned to a device.
• Dynamic IP addresses are temporary and are automatically assigned to devices as they connect to the network.
• DHCP (Dynamic Host Configuration Protocol) is the standardized network protocol used on Internet Protocol networks for dynamically distributing network configuration parameters.

Explanation

The fundamental difference between these two types of IP addresses lies in their stability and the method of assignment.

1. Static IP Address: This type of address remains the same over time. It is manually configured by a network administrator and does not change unless the configuration is modified. This is critical for devices that need to be consistently reachable at the same address, such as web servers, DNS servers, and printers.
2. Dynamic IP Address: This is a temporary address that is assigned by a DHCP server. When a device connects to a network, the server selects an available address from a pool and leases it to the device. Because these addresses are leased, they may change periodically, such as when a device is restarted or the lease expires. This method is used by Internet Service Providers (ISPs) for most home and consumer devices because it is more efficient and cost-effective to manage a pool of addresses.

Hence, Static IPs remain the same, while Dynamic IPs are assigned temporarily by a DHCP server and may change.

Concept

• Keyboard shortcuts are combinations of keys that provide an alternative way to perform tasks that are typically done with a mouse.
• In Microsoft Word, these shortcuts help improve productivity and speed when managing documents.
• The Save function is critical for ensuring that any progress made on a document is stored on the disk to prevent data loss.

Explanation of Shortcuts

The following shortcuts are commonly used in MS Word for file management and editing:

• Ctrl + S: This is the standard shortcut used to Save the current document. If the document has never been saved before, it will trigger the Save As dialog box to allow the user to name the file.
• Ctrl + P: This shortcut is used to open the Print window, allowing the user to preview the document and send it to a printer.
• Ctrl + O: This command is used to Open an existing document from the storage location.
• Ctrl + X: This shortcut is used to Cut the selected text or graphic, removing it from the document and placing it on the Clipboard.

Hence, the keyboard shortcut used to quickly save a document in MS Word is Ctrl + S.

The correct answer is National Electronic Funds Transfer.

Key Points

• National Electronic Funds Transfer (NEFT) is a nationwide centralized payment system owned and operated by the Reserve Bank of India (RBI).
• It facilitates a one-to-one funds transfer mechanism where individuals, firms, and corporates can electronically transfer money from any bank branch to any other bank account in the country participating in the NEFT network.
• The settlement of funds in NEFT happens in batches rather than on a continuous basis. This system is known as Deferred Net Settlement (DNS), where transactions are netted out at specific intervals.
• Historically, the system operated during specific working hours; however, since December 16, 2019, the RBI made NEFT available on a 24×7×365 basis, including holidays, to promote digital adoption.
• There is no minimum limit on the amount that can be transferred via NEFT, making it highly accessible for retail customers for small-value remittances.

 Additional Information

• RTGS (Real Time Gross Settlement):
• Unlike NEFT, RTGS settles transactions individually and immediately on a gross basis.
• It is primarily intended for high-value transactions, carrying a minimum limit of Rs. 2 Lakhs.
• IFSC (Indian Financial System Code):
• This is a unique 11-digit alphanumeric code assigned by the RBI to identify every bank branch participating in the NEFT and RTGS systems.
• The first four characters represent the bank name, the fifth is 0, and the last six characters represent the branch code.
• IMPS (Immediate Payment Service):
• Managed by the National Payments Corporation of India (NPCI), it provides an instant 24-hour interbank electronic fund transfer service through mobile and internet banking.

The correct answer is Inserts a superscript reference mark and creates a note at bottom of current page.

Key Points

• In Microsoft Word, the Insert Footnote feature is located under the References tab in the Footnotes group.
• When activated, the software automatically places a superscript number (or symbol) at the cursor's location, which serves as a reference mark for the reader.
• The program then shifts focus to the bottom of the current page, beneath a short separator line, where a corresponding number is created for the user to enter detailed citations, definitions, or supplementary comments.
• Footnotes are page-specific; if the text containing the reference mark moves to a different page due to editing, MS Word automatically relocates the corresponding note to the bottom of that new page.
• This feature is essential for academic and professional writing to maintain document integrity and provide source attribution without interrupting the flow of the main narrative.

 Additional Information

• Keyboard Shortcut: The default shortcut to quickly insert a footnote in Windows is Alt + Ctrl + F.
• Footer:
• Unlike a footnote, a Footer is a section that appears in the bottom margin of every page in a document or section.
• It typically contains repetitive information such as page numbers, file names, or author credentials.
• Endnotes:
• While similar to footnotes, Endnotes (shortcut: Alt + Ctrl + D) are placed at the very end of the document or the end of a section rather than at the bottom of each individual page.
• Comments:
• This feature allows reviewers to add notations or feedback in the margin (markup area) that can be hidden, resolved, or deleted without affecting the primary text layout.
• Bibliography:
• This tool automates the creation of a list of sources used in the document, typically formatted according to styles like APA, MLA, or Chicago.

The correct answer is Ctrl + Shift + >.

Key Points

In Microsoft Word and similar word processing software, keyboard shortcuts are essential for productivity and maintaining a fast workflow without relying on the mouse.
The shortcut Ctrl + Shift + > is specifically designed to increase the font size of selected text by one increment based on the predefined values found in the Font Size dropdown menu (e.g., jumping from 12 to 14, or 14 to 16 points).
This shortcut functions by moving up the standard scale of font sizes, which often follows a non-linear progression in higher values.
To perform the opposite action, a user would press Ctrl + Shift + <, which decreases the font size by one increment in the same preset list.
These formatting commands allow for rapid document styling and are standard across various versions of Office Productivity Suites.

 Additional Information

Ctrl + ]:

This shortcut increases the font size of the selected text by exactly 1 point (e.g., from 12 pt to 13 pt), offering more granular control than the increment-based shortcut.
The companion shortcut Ctrl + [ decreases the font size by exactly 1 point.

Ctrl + F:

This is a universal shortcut used to open the Navigation Pane or the Find dialog box, enabling users to search for specific strings of text or formatting within the active document.

Ctrl + Alt + >:

This combination is not a standard built-in shortcut for font manipulation in Microsoft Word; standard resizing commands typically utilize the Shift or Bracket keys.

The correct answer is A range of cells (from A1 through C5).

Key Points

• In spreadsheet software such as Microsoft Excel, Google Sheets, and LibreOffice Calc, the colon (:) is known as the range operator.
• The reference A1:C5 identifies a continuous rectangular block of cells beginning at the top-left corner (A1) and ending at the bottom-right corner (C5).
• This notation encompasses all cells within Columns A, B, and C across Rows 1, 2, 3, 4, and 5, representing a total of 15 individual cells.
• The primary purpose of using a colon is to allow aggregate functions like SUM, AVERAGE, or MAX to process an entire set of data points simultaneously without manual entry of each cell address.

 Additional Information

• Other Spreadsheet Operators:
• Comma (,): Acts as the Union operator, used to combine multiple references that are not next to each other (e.g., A1, C5).
• Space: Serves as the Intersection operator, which finds the specific cells that are common to two different ranges.
• Reference Types:
• Relative Reference: Standard cell addresses (e.g., B2) that change based on the position when a formula is copied.
• Absolute Reference: Uses the dollar sign symbol (e.g., $B$2) to lock the row and column so they do not change during copy-paste operations.
• Named Ranges:
• A Named Range is a custom label (like Tax_Rate) assigned to a cell or range of cells to make complex formulas easier to understand and maintain.

The correct answer is The recipient's email address will be invisible to others.

Key Points

• The concept of invisibility in email correspondence is governed by the Blind Carbon Copy (Bcc) protocol, which is defined under RFC 5322 (Internet Message Format). When a recipient is added to this field, their identity is suppressed during the transmission process.
• During the SMTP (Simple Mail Transfer Protocol) transaction, the Mail Transfer Agent (MTA) uses the RCPT TO command to route the email to all listed addresses but excludes the Bcc addresses from the Message Header delivered to other recipients.
• This mechanism ensures Recipient Privacy, preventing the mass disclosure of contact information. In Corporate Communication and Marketing, this prevents Data Breaches where sensitive email lists could otherwise be exposed to third parties.
• Unlike the standard Carbon Copy (Cc), where all recipients are visible to one another, the hidden field ensures that only the sender and the hidden recipient themselves are aware of their inclusion in the thread.
• Using hidden fields is a strategic defense against Email Harvesting and the formation of uncontrolled Reply All threads, which can lead to excessive network traffic and privacy violations.

 Additional Information

• Understanding Email Fields and Protocols:
• Cc (Carbon Copy): Traditionally used for Informational Distribution. It allows all recipients to see the full list of stakeholders involved, fostering Transparency in Professional Environments.
• To Field: This is the primary destination field for recipients expected to act upon the email. It is part of the visible Envelope Header.
• SMTP Envelope vs. Header: The Envelope is the data used by the server for delivery, while the Header is the section containing metadata (To, From, Subject) that the user sees in their Email Client like Outlook or Gmail.
• Privacy Compliance: Utilizing hidden recipient fields is often a requirement under Cybersecurity Policies and Data Protection Acts to prevent the unauthorized sharing of personal identifiers.

Concept

• A Spreadsheet program, such as Microsoft Excel or Google Sheets, is a tool used for storing, organizing, and analyzing data in tabular form.
• Calculations in these programs are performed using Formulas and Functions.
• While a Formula is an expression defined by the user (e.g., =A1+B1), a Function is a built-in tool that simplifies complex operations.

Explanation

In the context of computer software like Excel, Functions are predefined formulas that are already available within the application to perform specific calculations. They eliminate the need for users to manually enter long mathematical or logical strings.

Common characteristics of Functions include:

• Pre-programmed Logic: They are designed to carry out specific tasks like addition (SUM), finding averages (AVERAGE), or logical testing (IF).
• Arguments: Most functions require inputs, known as arguments, which are usually provided within parentheses.
• Efficiency: Using Functions reduces errors and saves time, especially when dealing with large datasets or complex statistical analysis.

Other options like Cells refer to the individual boxes where data is stored, and Programs refer to the software application itself, not the internal calculation tools.

Hence, formulas that are inbuilt into a spreadsheet are called Functions.

Concept

• Data Pivoting is a powerful data processing technique used to summarize, sort, reorganize, group, count, total, or average data stored in a database or spreadsheet.
• A Pivot Chart provides a graphical representation of the data in an associated Pivot Table, allowing for interactive data exploration.
• It is specifically designed to handle quantified data, ranging from numeric values and currency to qualitative data that has been transformed into numeric form through counting.

Explanation

Pivot Charts are essential tools in data analysis software like Microsoft Excel or Google Sheets for the following reasons:

1. Versatility: They can handle various data types, including currency, integers, and floating-point numbers. Even qualitative data (like names of cities or categories) can be pivoted by using the Count function to quantify their occurrences.
2. Interactivity: Users can filter, sort, and hide data categories directly within the chart, which automatically updates to reflect the changes. This allows for a dynamic view of different data perspectives.
3. Data Summarization: They simplify large datasets by aggregating information into meaningful summaries, making it easier to identify trends, patterns, and outliers.
4. Comparison with Other Charts:

• Area Charts are used to show the magnitude of change over time but do not possess the dynamic pivoting capability.
• Hierarchy Charts (like Treemaps) show the structure of data but are not primarily used for pivoting numeric values.
• Radar Charts compare multiple quantitative variables but lack the flexible reorganization features of a Pivot Chart.

Hence, a Pivot Chart is the correct tool to pivot any data that can be quantified.

The correct answer is LOOKUP(2,1/(range<>''), range).

Key Points

• The expression (range<>'') is a logical evaluation that scans every cell in the selected Excel range. It returns an array of Boolean values: TRUE if a cell contains any data and FALSE if the cell is completely empty.
• When the formula performs the division 1/(range<>''), Excel implicitly converts TRUE to 1 and FALSE to 0. This mathematical operation generates an array containing 1s (for non-empty cells) and #DIV/0! errors (for empty cells).
• The LOOKUP function is uniquely programmed to automatically ignore error values like #DIV/0!, #N/A, or #VALUE! while searching through the lookup_vector.
• By setting the lookup_value to 2, which is strictly greater than any potential value in the array (where the maximum value is 1), the function is forced to identify the last numerical entry in the sequence.
• Because the function locates the position of the last 1 in the transformed array, it returns the corresponding value from the result_vector (the original range), successfully retrieving the last non-empty cell regardless of whether it contains strings, numbers, or dates.

 Additional Information

• Specific Data Type Lookups:
• LOOKUP(9^9, range): This is specifically used to find the last numeric value in a column. It will ignore text and errors but cannot identify the last non-empty cell if that cell contains a string.
• LOOKUP('zzz', range): This variant is designed to find the last text entry in a range. Since 'zzz' is alphabetically high, the LOOKUP function identifies the last string it encounters.
• Function Versatility:
• The LOOKUP function remains a vital tool for Legacy Excel compatibility, as it handles array-like operations without requiring the Ctrl+Shift+Enter (CSE) array formula entry.
• In Office 365 or Excel 2021, users can also use the XLOOKUP function with search mode -1 to achieve the same result with a more modern syntax.