Search Previous Year Questions

The correct answer is Equal (=)

Key Points

• Equal (=): This is the correct symbol to start a formula in an Excel cell.
• Any calculation or formula in Excel begins with this equal sign. For example, =A1+10 would add 10 to the value in cell A1.

Additional Information

• Dollar ($) sign: In Excel, the dollar sign is used to create absolute references. For example, if you want to refer to cell A1 in a formula and you don't want that reference to change when you copy the formula to another cell, you would use $A$1. However, the dollar sign doesn't signal the start of a formula.
• Ampersand (&): The ampersand is not used to start a formula in Excel, but rather within formulas to concatenate (link together) different text strings or cell values. For example, the formula =A1&B1 would join together the contents of cells A1 and B1.
• Percent (%): In Excel, a percent sign is neither used to start a formula nor within a formula typically. It's usually used to represent percentage values. While you can include this in a formula (e.g. =A1*20% to get 20% of the value in A1), it's not used to initiate a formula$.

The Correct answer is Internet Service Provider.

Key Points

• An Internet Service Provider (ISP) is a company or organization that provides individuals, businesses, or other entities with access to the internet.
• ISPs can offer a variety of services, including broadband connections such as DSL, fiber optics, cable, and satellite internet.
• ISPs often provide additional services such as email hosting, web hosting, domain registration, and internet security services.
• They serve as the gateway for users to access content, browse websites, and use online services via the World Wide Web.
• ISPs can operate at different levels, such as local, regional, national, or even international scales.
• Some well-known ISPs include Comcast, AT&T, Verizon, BSNL, Airtel, Jio, and Vodafone.
• The role of ISPs is critical in modern society, enabling functions such as remote work, education, e-commerce, and entertainment.
• ISPs are also responsible for assigning IP addresses to their clients to facilitate connectivity.

 Additional Information

• International Security Protocol
• This option may refer to protocols or measures designed to ensure security in international data communications, but it is unrelated to internet access services.
• Some widely used security protocols include SSL/TLS (Secure Sockets Layer/Transport Layer Security) for encrypted communication.
• Internet System Protocol
• This term is likely a confusion with Internet Protocol (IP), which is a set of rules governing how data is sent over the internet.
• IP is a fundamental component of internet communication, but it does not represent the term ISP.
• Internet Security Program
• This term might refer to software or strategies for ensuring online safety, such as antivirus programs, firewalls, or anti-phishing tools.
• While important, this is unrelated to the concept of an ISP, which provides internet access.

The correct answer is Loading of program code from disk to memory for execution.

Key Points

• A loader is a system software component that is responsible for loading program code from disk to memory for execution.
• It ensures that the program is placed into memory correctly and is ready for the CPU to execute.
• This is a crucial step in the execution of any program as it allows the CPU to access and run the program code.

Additional Information

• Option 2: Editing the source file - This is typically done by a text editor or an Integrated Development Environment (IDE), not by a loader. The loader's function starts after the source code has been compiled into machine code.
• Option 3: Loading object file - This might seem similar to the loader's job, but loading object files is usually part of the linkage process. The loader deals with the final executable code.
• Option 4: Loading header files - Header files are included during the compilation process and are not handled by the loader. They are used to define structures, constants, and function prototypes.

The Correct answer is Expansion board.

Key Points

• An Expansion board, also referred to as an expansion card, is a printed circuit board that is used to enhance a computer's capabilities.
• It is installed into the expansion slot of a computer's motherboard.
• Common functions of expansion boards include increasing memory, improving graphics, enhancing audionetwork functionality.
• Examples of expansion boards include graphics cards, sound cards, network interface cards (NICs), and storage controllers.
• Expansion boards are essential for users who require specialized functionality, such as gamers who use advanced graphics processing units (GPUs) to improve gaming performance.
• They are widely used in both consumer PCs and professional workstations, allowing users to customize their systems according to their needs.
• Modern motherboards often come with multiple PCI Express slots, which support high-speed expansion boards.

 Additional Information

• Writing tablet
• A writing tablet is a device used for digital handwriting or drawing. It is commonly used by graphic designers and digital artists.
• Writing tablets do not enhance a computer’s internal functionality like memory or graphics; instead, they serve as an input device.
• Examples of writing tablets include Wacom tablets, which are widely used for illustration and animation.
• Keyboard
• A keyboard is a primary input device used to type text and execute commands in a computer.
• While keyboards are essential for interaction with a computer, they do not directly enhance internal components such as memory or graphics.
• Modern keyboards can include features like RGB lighting and programmable keys for specialized uses.
• NIC controller
• A Network Interface Controller (NIC) is a type of expansion board that enables computers to connect to a network.
• NICs are specifically designed for network functionality, such as wired or wireless communication.
• While NICs are a type of expansion board, they are not broadly categorized as expansion boards for general purposes like memory or graphics enhancement.

The correct answer is A1.

Key Points

• The first cell in EXCEL worksheet is labeled as A1.
• Each cell has a name, or a cell address based on which column and row it intersects.
• The cell address of a selected cell appears in the name box.
• Cells are the basic building blocks of a worksheet.
• They can contain a variety of content such as text, formatting attributes, formulas, and functions.
• To work with cells, we'll need to know how to select them, insert content, and delete cells and cell content.

The correct answer is "On the top of the vertical scroll bar".

Key Points

• In MS Word 2007, the horizontal split bar is found on the view tab at, the top of the vertical scroll bar.

• The steps to find the horizontal split bar are given below:

• Step 1: Click on the view tab.

• Step 2: Click on the Split menu.

• Step 3: It will print the current page horizontally. 

​

Thus the correct answer is "On the top of the vertical scroll bar".

The correct answer is Monitors.

Key Points

• The third generation of computers spanned from 1965 to 1971.
• During this period, keyboards and monitors started replacing punched cards and printouts for data input and output.
• This shift was facilitated by the development of more user-friendly interfaces and interactive computing.
• Monitors allowed users to see immediate feedback on their inputs, making computing more efficient and accessible.
• Monitors became an integral part of the computer system, paving the way for the graphical user interfaces (GUIs) we use today.

Additional Information

• Third Generation Computers
• These computers used integrated circuits (ICs) instead of transistors, leading to more compact and reliable machines.
• They were characterized by their increased speed, efficiency, and storage capacity.
• Examples include IBM 360 series and Honeywell 200 series.
• This generation marked the beginning of multiprogramming and time-sharing systems.
• Keyboards
• Keyboards are input devices that allow users to enter data into a computer system by pressing keys.
• The QWERTY layout, developed in the 19^th century, became the standard keyboard layout for most computers.
• Modern keyboards include additional function keys and shortcuts to enhance productivity.
• Monitors
• Monitors are output devices that display information in a visual form, making it easier for users to interact with the computer.
• The first monitors were monochrome (black and white), but color monitors became standard in the 1980s.
• Advancements in monitor technology have led to high-resolution displays, touchscreens, and flexible screens.
• Graphical User Interfaces (GUIs)
• GUIs use graphical icons, menus, and windows to interact with the computer, as opposed to text-based interfaces.
• They were popularized by systems like the Apple Macintosh and Microsoft Windows in the 1980s and 1990s.
• GUIs have made computing accessible to a broader audience, including those without technical expertise.

The correct answer is Bcc

Key Points

• To: This field is where you put the email addresses of your primary recipients--the individuals to whom the email is directly addressed. Every recipient in this field will see the other recipients' email addresses.
• Bcc: This stands for "blind carbon copy." When you put email addresses in this field, these recipients will receive the email, but other recipients (those in the To or Cc fields) will not see these addresses. This is useful when you want to send an email to multiple people without them knowing who else is receiving the email.
• Subject: This field is where you summarize the content or purpose of your email. It doesn't include any email addresses—just a brief summary or title for your email.
• Cc: Stands for "carbon copy". When you put email addresses in the Cc field, these people receive a copy of the email. Everyone who gets the email (including those in the To field) will be able to see who is in the Cc field. This is typically used to keep people in the loop, even if they're not the primary recipient of the email.

COUNTA()

• The COUNTA function provides the number of cells that are not empty in the range of the given cells. Its syntax is COUNTA(value1, value2...).
• If you have an array from A1 and A10, use the formula =COUNTA(A1:A10), and it returns the output as 0 because there are no empty cells.
• You can also count the number of cells in the array that meets the criteria using the COUNTIF function.
• Its syntax is =COUNTIF(A2:A10, "subject") counts the range of cells with the subject in cells A2 through A10.

The correct answer is Shift + Enter.

Key Points

• Keyboard shortcut to create a line break in a Word document is Shift + Enter.
• Keyboard shortcuts in Word:
• Alt + Enter: In Microsoft Word for spell checking quick-fixes
• Ctrl + Enter: In a multi-line edit control, It inserts a carriage return into the edit control rather than executing the default button on the dialog box.
• Space + Enter: It is not a shortcut in MS-word
• Shift+Enter: Insert a line break
• Ctrl+Enter: Insert a page break.
• Ctrl+Shift+Enter: Insert a column break.