Search Previous Year Questions

The correct answer is Wireless fidelity.

• Wireless fidelity is the full form of Wi-Fi.
• Wi-Fi is a wireless local area network.
• It was introduced in 1997.
• It allows an electronic device to exchange data wirelessly using radio waves.
• Wi-Fi provides services in private homes, businesses, as well as in public spaces.
• Wi-Fi positioning systems use the positions of Wi-Fi hotspots to identify a device's location.

The correct answer is Select cell → Right click → Format cell

Key Points

• To format a cell in an MS Excel Spreadsheet, you need to first select the cell you want to format.
• After selecting the cell, right-click on the selected cell to open the context menu.
• From the context menu, choose the "Format Cells..." option to open the Format Cells dialog box.
• This dialog box allows you to change various cell properties such as number format, alignment, font, border, and fill.
• Formatting cells can help make your data more readable and visually appealing.

Additional Information

• MS Excel is a powerful spreadsheet software developed by Microsoft, widely used for data analysis, financial modeling, and data visualization.
• It offers a range of features including formulas, charts, pivot tables, and conditional formatting to enhance data manipulation and presentation.
• Excel supports various file formats including .xlsx, .xls, .csv, and more, making it versatile for different types of data work.
• Users can also use Excel's built-in functions and macros to automate repetitive tasks and improve efficiency.
• Consistent use of cell formatting helps maintain a professional and organized appearance of your spreadsheets.

The correct answer is Third Generation.

Key Points

• The First generation of computer's period was from 1940 to 1956.
• Vacuum tubes were used in the first generation of computers for circuitry and magnetic drums were used for memory.
• Computers in this generation were enormous and they use to take entire rooms.
• Computers were very expensive to operate and used a great deal of electricity which generated a lot of heat which cause malfunctions.
• Computer relied on machine language to perform operations and so could solve one problem at a time.
• The UNIVAC (Universal Automatic Computer) and ENIAC (Electronic Numerical Integrator and Computer) are examples of first-generation computing devices.
• The UNIVAC (Universal Automatic Computer) was the first commercial computer delivered to a business client, the U.S. Census Bureau in 1951.
• The second generation of computer's period was from 1956-1963.
• Transistors were used in second-generation computers.
• The transistor was invented in 1947 but was used in computers in the late 1950s.
• The transistors were far superior to the vacuum tube, allowing computers to become smaller, faster, cheaper, more energy-efficient, and more reliable than their first-generation predecessor.
• Early versions of COBOL (Common Business-Oriented Language) and FORTRAN (Formula Translation) which are high-level programming languages were also being developed at this time.
• The third generation of computer's period was from 1964-1971.
• Integrated circuits were used in third-generation computers.
• These computers carry out instructions in billionths of a second.
• Computers for the first time became accessible to a mass audience because they were smaller and cheaper than their predecessor.
• Fourth Generation computer's period was from 1971 to the present.
• Microprocessors were used in fourth-generation computers.
• Fourth Generation computers saw the development of the Graphical User Interface (GUI's), the mouse, and handheld devices.
• Fourth-generation computers were small and more powerful as compared to other generations as a result they could be linked together to form networks and led to the development of the internet.
• Fifth Generation computers are in the present generation and will see further developments.
• Artificial Intelligence is used in this generation of computers.
• Games such as chess and checkers can be played on the computer.
• The term Artificial intelligence was coined for the first time by John McCarthy in 1956 at the Massachusetts Institute of Technology.
• Natural-language processing, Voice recognition, robotics, etc are some of the achievements of this generation of computers.

The correct option is (4)

Explanation:-

Restrict data entry:

1. Select the cells where you want to restrict data entry.
2. On the Data tab, click Data Validation > Data Validation.
3. In the Allow box, select the type of data you want to allow and fill in the limiting criteria and values.

 Important Points

Data validation:- It is a feature that restricts (validates) user input to a worksheet. Technically, you create a validation rule that controls what kind of data can be entered into a certain cell.

Additional InformationProtect Worksheet:- Worksheet level protection is not intended as a security feature. It simply prevents users from modifying locked cells within the worksheet.

Conditional Formatting:- It is a tool that allows you to apply formats to a cell or range of cells, and have that formatting change depending on the value of the cell or the value of a formula.

Allow users to Edit Ranges:- Select the worksheet that you want to protect. On the Review tab, in the Changes group, click Allow Users to Edit Ranges. This command is available only when the worksheet is not protected.

The correct answer is Exclamation Mark (!).

Key Points

• The Exclamation Mark (!) is commonly used in various email clients to mark an email as important or urgent.
• When an email is marked with an Exclamation Mark, it signifies to the recipient that the email should be read or acted upon promptly.
• This feature helps in prioritizing emails in the inbox based on their urgency or importance.

Additional Information

• At Symbol (@): This symbol is commonly used in email addresses to separate the username from the domain name, for example, user@example.com.
• Hash Tag (#): This symbol is widely used on social media platforms to tag or categorize content, making it easily searchable by other users.
• Asterisk (*): This symbol is often used in computing and programming to denote multiplication, pointers, or to signify a wildcard character in search functions.

The correct answer is Option (2).

Key Points

• A central processing unit (CPU), also called a central processor, main processor, or just processor is the electronic circuitry within a computer that executes instructions that make up a computer program.
• The CPU performs basic arithmetic, logic, controlling, and input/output (I/O) operations specified by the instructions in the program.
• The computer industry used the term "central processing unit" as early as 1955.
• Principal components of a CPU include the arithmetic logic unit (ALU) that performs arithmetic and logic operations, processor registers that supply operands to the ALU and store the results of ALU operations, and a control unit that orchestrates the fetching (from memory) and execution of instructions by directing the coordinated operations of the ALU, registers and other components.
• The fundamental operation of most CPUs, regardless of the physical form they take, is to execute a sequence of stored instructions that is called a program. The instructions to be executed are kept in some kind of computer memory. Nearly all CPUs follow the fetch, decode and execute steps in their operation, which are collectively known as the instruction cycle.

The correct answer is New Technology.

Key Points-

• Windows NT is a family of operating systems manufactured by Microsoft, NT stands for 'New Technology' the first version of which was released on July 27, 1993. It is a processor-independent, multiprocessing and multi-user operating system.

The correct answer is option 3, i.e. Basic Input Output System (BIOS).

Basic Input Output System is a program that is used as an interface between the operating system and the motherboard.

• It is the program used by the microprocessor and manages data flow between the computer’s operating system and attached devices such as hard disk, keyboard, adaptor, mouse, and printer, etc.

The correct answer is checking spelling and grammar.

Key Points

• Its have no use of the F7 key in Windows.
• In Microsoft programs such as Microsoft Word, Outlook for checking spellings and grammar, the F7 is commonly used.
• Other uses- 
• Shift + F7 = Choose the Thesaurus command.
• Ctrl + F7 = Choose the move command.
• Alt + F7 = Find the next misspelling or grammatical error.​

Additional Information

• Renaming files and folders**- F2 key.**
• Opening help- Windows Key + F1 key.
• Searching content in various apps**- Windows Key + Q key.**

The correct answer is Optical character reader.

Key Points

• Optical character recognition(OCR) is the electronic or mechanical conversion of images of typed, handwritten, or printed text into machine-encoded text, whether from a scanned document, a photo of a document, a scene photo, or from subtitle text superimposed on an image.

Important Points