Computer Knowledge PYQs

The correct answer is 4) A file containing multiple worksheets

Key Points

• An Excel workbook is a file that contains one or more worksheets.
• Each worksheet within a workbook can hold data, charts, and other information.
• Workbooks are used to organize and manage related data in one file, making it easier to analyze and share information.
• Users can add, delete, and rename worksheets within a workbook to suit their needs.
• The .xlsx file extension is typically used for Excel workbooks.

Additional Information

• Excel is a powerful tool for data analysis and visualization, widely used in various fields such as finance, research, and administration.
• Workbooks can contain various types of data, including numbers, text, formulas, and functions.
• Excel provides numerous features for data manipulation, including sorting, filtering, and pivot tables.
• Workbooks can be saved in different formats, such as .xls, .csv, and .pdf, depending on the user's needs.
• Excel also supports collaboration, allowing multiple users to work on the same workbook simultaneously.

The correct answer is Ctrl + V

Key Points

• The keyboard shortcut Ctrl + V is used to 'Paste' copied content from the clipboard in most Windows applications.
• Other common keyboard shortcuts include Ctrl + C for copying, Ctrl + X for cutting, and Ctrl + Z for undoing the last action.
• These shortcuts are widely used across various applications to enhance productivity and streamline workflow.
• Learning and using keyboard shortcuts can significantly speed up your tasks and improve efficiency.

Additional Information

• Keyboard shortcuts are combinations of keys that provide an alternative way to do something that you’d typically do with a mouse.
• They are especially useful for repetitive tasks, reducing the time required to switch between the keyboard and mouse.
• Most operating systems and software applications support a wide range of keyboard shortcuts, and they can often be customized to suit individual preferences.
• Using keyboard shortcuts can also help reduce the risk of repetitive strain injuries by minimizing the amount of movement needed to perform tasks.

The correct answer is Option 3

Key Points

• The 'BCC' field in email composition is used to send copies of the email without revealing the other recipients' addresses.
• BCC stands for Blind Carbon Copy.
• When you include an email address in the BCC field, the primary recipient and other BCC recipients will not see that email address.
• This feature is useful for maintaining privacy among recipients.
• It helps in preventing an email recipient from seeing the addresses of other recipients, which is particularly useful in business communications.

Additional Information

• Other fields in email composition include 'To', 'CC', and 'Subject'.
• The 'To' field is used for the main recipients of the email.
• The 'CC' (Carbon Copy) field is used to send a copy of the email to additional recipients, whose email addresses are visible to all other recipients.
• Using BCC can help to reduce the chances of recipients' email addresses being harvested for spam.

The correct answer is 2) SMTP (Simple Mail Transfer Protocol)

Key Points

• SMTP (Simple Mail Transfer Protocol) is the protocol used for sending emails.
• It is a part of the application layer of the TCP/IP protocol suite.
• SMTP is used to transfer messages from the sender's email client to the recipient's email server.
• For receiving emails, protocols like IMAP (Internet Message Access Protocol) and POP3 (Post Office Protocol) are commonly used.
• SMTP works in conjunction with these protocols to ensure the complete transmission and reception of email messages.

Additional Information

• SSH (Secure Shell Protocol) is used for secure remote login and other secure network services over an unsecured network.
• FTP (File Transfer Protocol) is used for transferring files between a client and server on a computer network.
• HTTP (Hypertext Transfer Protocol) is used for transmitting hypertext requests and information on the internet.
• Each of these protocols has its specific use case, and they are not interchangeable.

The correct answer is Printer

Key Points

• A Printer is an example of an output device.
• Output devices are used to send data from a computer to another device or user.
• Other examples of output devices include monitors, speakers, and projectors.
• These devices receive data from the computer and translate it into a form that is understandable to the user.

Additional Information

• A Microphone is an example of an input device, which is used to input sound data into the computer.
• A Scanner is also an input device, used to input images or documents into the computer.
• A Mouse is another input device, used for navigating and providing input to the computer's user interface.
• Output devices play a crucial role in the overall functioning of computer systems by providing a way for the computer to communicate information to the user.

The correct answer is 1) It executes program instructions by performing calculations and logical comparisons.

Key Points

• The Arithmetic Logic Unit (ALU) is a critical component of the CPU that executes program instructions by performing calculations and logical comparisons.
• The ALU handles arithmetic operations like addition, subtraction, multiplication, and division.
• It also performs logical operations such as AND, OR, NOT, and XOR, which are essential for decision-making processes in programs.
• By executing these operations, the ALU enables the CPU to process data and run applications effectively.

Additional Information

• The Control Unit (CU) and the ALU together form the CPU's core, where the CU directs the operations and the ALU performs the actual data processing.
• The ALU can be found in various types of processors, including general-purpose CPUs, microcontrollers, and graphics processing units (GPUs).
• Modern CPUs may have multiple ALUs to handle parallel processing tasks, thereby improving performance and efficiency.
• The development and optimization of ALUs have been fundamental in advancing computer technology and enabling more complex computing tasks.

The correct answer is Press Ctrl + O

Key Points

• Press Ctrl + O is the shortcut to open an existing document in Microsoft Word 2016.
• Using this shortcut will bring up the Open dialog box, allowing you to browse and select the document you want to open.
• This shortcut is a quick and efficient way to access previously created documents without having to navigate through multiple menus.
• Other common shortcuts in Microsoft Word include Ctrl + S to save a document, Ctrl + P to print a document, and Ctrl + N to create a new document.

Additional Information

• Microsoft Word is a widely used word processing software developed by Microsoft.
• Word allows users to create, edit, format, and print documents.
• It includes various features such as spell check, grammar check, text formatting options, and templates for different types of documents.
• Microsoft Word is part of the Microsoft Office suite, which also includes other productivity tools like Excel, PowerPoint, and Outlook.
• Learning keyboard shortcuts can significantly improve efficiency and productivity when working with Microsoft Word.

The correct answer is Win + E

Key Points

• Win + E is the keyboard shortcut to open File Explorer in Windows 10.
• File Explorer, previously known as Windows Explorer, is a file management application that is part of the Windows operating system.
• Using the Win + E shortcut quickly opens File Explorer, allowing users to manage files and folders efficiently.
• Other common keyboard shortcuts in Windows include Ctrl + C for copy, Ctrl + V for paste, and Alt + Tab for switching between open applications.

Additional Information

• File Explorer is a crucial tool for navigating the file system in Windows.
• It provides a graphical user interface to access files, folders, and drives on your computer.
• File Explorer also includes features such as file search, quick access to frequently used folders, and the ability to manage network locations.
• In addition to Win + E, other useful Windows shortcuts include Win + D to show the desktop, Win + L to lock the computer, and Win + R to open the Run dialog box.

The correct answer is To search and retrieve relevant information from the web.

Key Points

• To search and retrieve relevant information from the web is the primary purpose of a search engine on the internet.
• Search engines use algorithms to index web pages and provide the most relevant results based on the user's query.
• Popular search engines include Google, Bing, and Yahoo, among others.
• They help users find websites, images, videos, and other content online.
• Advanced search features may include filters for date, type of content, and specific keywords.

Additional Information

• Search engines use web crawlers to gather information from websites.
• They store data in an index to quickly retrieve relevant results.
• Search engine optimization (SEO) is a practice to improve the visibility of a website in search engine results.
• Search engines also offer features like autocomplete to assist users in finding information faster.
• Besides web pages, search engines can also index images, videos, news articles, and academic papers.
• Users can perform advanced searches using operators like quotes for exact phrases, minus sign to exclude words, and site: to search within a specific website.

The correct answer is DHCP (Dynamic Host Configuration Protocol)

Key Points

• DHCP (Dynamic Host Configuration Protocol) is the networking protocol used to assign IP addresses dynamically to devices on a network.
• It allows devices to join a network without the need for manual configuration of IP addresses.
• DHCP operates on a client-server model where the DHCP server assigns an IP address from a defined range to a client device for a specific lease time.
• This protocol simplifies the management of IP addresses in large networks and ensures that IP address conflicts are minimized.

Additional Information

• FTP (File Transfer Protocol) is used for transferring files between computers on a network.
• HTTP (Hypertext Transfer Protocol) is the foundation of data communication for the World Wide Web.
• SMTP (Simple Mail Transfer Protocol) is used for sending emails across networks.
• DHCP is a critical protocol in modern networks, ensuring efficient IP address management and reducing administrative overhead.

The correct answer is address

Key Points

• Address bus is used to transfer addresses between the CPU and the main memory in a computer system.
• It is a unidirectional bus, meaning that it only carries signals in one direction: from the CPU to the main memory or other devices.
• The address bus determines the location in the memory where data is to be read from or written to.
• The width of the address bus determines the maximum addressing capacity of the system, i.e., how much memory can be addressed.

Additional Information

• The data bus is used to transfer actual data between the CPU, memory, and other peripherals.
• The control bus carries control signals from the CPU to other components of the computer.
• The status bus is used to carry status signals that indicate the state of various components in the system.
• A typical computer system may have a 32-bit or 64-bit address bus, which allows it to address 4 GB or more memory, respectively.

The correct answer is option 2

Key Points

• The 'Table of Authorities' group can be found under the References tab in MS Office 365.
• This group is used primarily in legal documents to list the references to legal cases, statutes, and other authorities cited in the document.
• It helps in organizing and managing citations efficiently, making it easier for users to create comprehensive legal documents.
• Other tabs in MS Office 365 include View, Mailings, and Review, but they do not contain the 'Table of Authorities' group.

Additional Information

• MS Office 365 is a subscription-based service that offers access to various Microsoft Office applications and other productivity services over the internet.
• The References tab also includes other useful features such as Table of Contents, Footnotes, Citations & Bibliography, Captions, and Index.
• These features are designed to help users create well-structured and professionally formatted documents.
• The correct usage of these tools can significantly enhance the quality and clarity of the documents.

The correct answer is address

Key Points

• The width of the address bus determines the maximum possible memory that a computer system can address.
• An address bus is a part of the computer architecture that transfers data between the CPU and memory.
• The number of lines in the address bus determines the maximum memory capacity that the system can handle. For example, a 32-bit address bus can address 2³² memory locations.
• Other buses like the I/O bus, control bus, and data bus have different functions and do not directly determine the maximum possible memory supported by the system.

Additional Information

• The data bus is responsible for transferring actual data between the CPU, memory, and other peripherals.
• The control bus carries control signals from the CPU to other components to manage and coordinate the operations of the computer.
• The I/O bus connects the CPU to external devices and handles communication between them.
• Modern computer systems may have address buses with varying widths, such as 32-bit or 64-bit, based on the architecture and design of the system.
• Increasing the width of the address bus allows for a larger addressable memory space, which can be crucial for applications requiring large amounts of memory.

The correct answer is Both I and II

Key Points

• Both I and II statements are correct for email functionalities.
• Email header can be checked by the user prior to downloading the full email. This allows users to view details like the sender, subject, and date.
• Partial download of an email is possible, which means a user can download only a portion of the email content, such as the header or a specific part of the message body, without downloading attachments or the entire message.

Additional Information

• Emails are a critical part of modern communication, providing a reliable and efficient way to exchange messages and information.
• Understanding email functionalities, such as viewing headers and partial downloads, can enhance user experience and security.
• Checking the email header can help identify potential spam or phishing attempts by verifying the sender's information before opening the email.
• Partial downloads can save bandwidth and time, especially when dealing with large emails or limited internet connectivity.

The correct answer is primary

Key Points

• The CPU interacts directly with the primary memory to perform read or write operations.
• Primary memory, also known as main memory or RAM (Random Access Memory), is crucial for the CPU's operation as it stores data and instructions that are currently in use or being processed.
• It provides fast access to the CPU, allowing for quick retrieval and execution of instructions and data.
• Unlike secondary memory, primary memory is volatile, meaning it loses its content when the power is turned off.

Additional Information

• Secondary memory refers to storage devices like hard drives and SSDs, which store data permanently.
• Register memory is a small and fast type of memory located within the CPU itself, used for temporary storage of data and instructions during processing.
• Cache memory is a smaller, faster type of volatile memory that provides high-speed data access to the CPU and is used to store frequently accessed data and instructions.
• Effective use of primary memory is crucial for the overall performance and speed of a computer system.

The correct answer is double line

Key Points

• A double line between two columns is an indicator that a column has been hidden in MS-Excel 365.
• When a column is hidden, the border between the adjacent columns appears as a double line, which helps users identify hidden columns quickly.
• This feature is useful for managing large datasets and maintaining a clean, organized view of the worksheet.
• To unhide a hidden column, you can simply drag the double line or use the "Unhide" option from the context menu.

Additional Information

• MS-Excel 365 offers various ways to hide and unhide columns, which can be accessed through the "Home" tab under the "Format" menu in the "Cells" group.
• Hidden columns can also be detected by the missing column letters in the column header row, such as when columns B and D are visible but column C is hidden.
• Maintaining hidden columns can be beneficial for data analysis, allowing users to focus on specific parts of the dataset without deleting any data.
• Excel's features for managing hidden columns are part of its broader suite of tools for data organization and manipulation, making it a powerful tool for data management tasks.

The correct answer is INDIRECT

Key Points

• INDIRECT function in MS-Excel 365 is used to change a cell reference within a formula without changing the formula itself.
• It allows you to create a reference from a text string, which can be particularly useful when you need to refer to different cells dynamically.
• The syntax for the INDIRECT function is INDIRECT(ref_text, [a1]), where ref_text is the text string containing the reference.
• For example, if you have a cell reference as a text string in cell A1, using INDIRECT(A1) will refer to the cell reference contained in A1.
• This function is handy for creating more flexible and dynamic formulas, especially in cases where the cell references need to be adjusted based on certain conditions or inputs.

Additional Information

• The TRANSPOSE function is used to change the orientation of a range of cells from vertical to horizontal or vice versa.
• The VLOOKUP function is used to search for a value in the first column of a table and return a value in the same row from a specified column.
• The MATCH function searches for a specified item in a range of cells and returns the relative position of that item within the range.
• Using the INDIRECT function with other Excel functions can enhance the flexibility and power of your formulas.

The correct answer is worm

Key Points

• A worm is a type of malicious software program whose primary function is to infect other computers while remaining active on infected systems.
• Unlike a virus, a worm does not need to attach itself to an existing program. Instead, it can self-replicate and spread independently over a network.
• Worms are designed to exploit vulnerabilities in operating systems and can cause significant damage by consuming bandwidth, overloading web servers, and spreading other types of malware.
• Examples of famous worms include the Morris Worm, ILOVEYOU, and WannaCry.

Additional Information

• Macro virus is a type of virus written in a macro language and embedded within a document or spreadsheet.
• Boot sector virus infects the master boot record of a storage device, making it difficult to remove.
• Trojan horse is a type of malware that disguises itself as a legitimate file or software to trick users into installing it.
• Unlike worms and viruses, a trojan horse does not self-replicate.

The correct answer is Packet filtering

Key Points

• Packet filtering firewalls operate at the Network layer (Layer 3) of the OSI model.
• These firewalls examine incoming and outgoing packets and make decisions to allow or block traffic based on predefined rules.
• They are used to control access to a network by analyzing the headers of packets, including source and destination IP addresses, ports, and protocols.
• Packet filtering firewalls are one of the oldest and simplest forms of firewalls, providing a basic level of security.

Additional Information

• Circuit-level gateways operate at the Session layer (Layer 5) and monitor TCP handshakes and sessions to determine whether a requested connection is legitimate.
• Application-level gateways, also known as proxy firewalls, operate at the Application layer (Layer 7) and filter traffic based on specific applications, such as HTTP or FTP.
• Network filtering is a general term and does not specifically refer to a type of firewall; it can encompass various methods of filtering traffic at different layers of the OSI model.
• Packet filtering firewalls are typically used in conjunction with other types of firewalls to provide a layered security approach.

The correct answer is Compact

Key Points

• To reduce the space between files in File Explorer of Windows 11, you should select the Compact view.
• This option is available under the View menu in File Explorer.
• The Compact view minimizes the space between file items, allowing more files to be visible on the screen.
• This feature can be particularly useful for users who need to manage a large number of files efficiently.

Additional Information

• Windows 11 offers various view options in File Explorer, including Extra large icons, Large icons, Medium icons, Small icons, List, Details, Tiles, and Content.
• Users can switch between these views to customize their file browsing experience according to their preferences.
• The Compact view is designed to maximize the number of items displayed without compromising readability.
• This view is especially helpful on smaller screens or when working with directories containing numerous files.