Search Previous Year Questions

The correct answer is Forward the email to IT or report it.

Key Points

• If you suspect you have received a phishing email, it is crucial to report it to your IT department or the appropriate authority within your organization. This helps in preventing potential security breaches and allows IT to take necessary actions to protect the system.
• Forwarding the email to IT or reporting it ensures that the suspicious email is examined by professionals who can identify and mitigate any threats.

Additional Information

• Option 1: Click on the link to verify - This is a dangerous action as it may lead to malicious websites that can steal your personal information or infect your system with malware.
• Option 2: Delete the email immediately - While deleting the email prevents you from falling victim, it does not alert the IT department to a potential threat, which could affect others in the organization.
• Option 4: Reply with personal information to check authenticity - This is highly risky as it directly provides phishers with the information they seek, potentially leading to identity theft or unauthorized access to sensitive accounts.

The correct answer is Ctrl + Tab.

Key Points

• Ctrl+Tab is a keyboard shortcut most often used to switch between open tabs in a browser.
• Ctrl + Tab keyboard shortcut will help the user to move through each of the open tabs going to the right in a Chrome browser.
• To use Ctrl + Tab keyboard shortcut, press and hold either Ctrl key, and while continuing to hold, press the Tab key.
• If you had more than one open tabs in your browser you could press Ctrl+Tab to switch between each of those tabs going left to right without using your mouse.
• Ctrl+Shift+Tab keyboard shortcut will help to switch between the tabs in the opposite direction (right to left).

Additional Information

• Ctrl+O: Open an existing document
• Ctrl+S: Save a document
• Ctrl+W: Close a document
• Ctrl+Z: Undo an action
• Ctrl+Y: Redo an action
• Alt+Ctrl+S: Split a window or remove the split view
• Ctrl+Alt+V: Print Layout View
• Ctrl+Alt+O: Outline View
• Ctrl+Alt+N: Draft View
• Ctrl+F2: Print Preview View
• F1: Open the Help pane
• F12: Open the Save As dialogue box

The correct answer is In MS Excel 2010, we can save the file by using F2

Key Points

• MS Excel allows you to save, open and create the file from the file tab or using shortcuts.
• The F12 or Ctrl + S shortcut is used to save the file.
• The F2 shortcut is used to edit the contents of a cell. Click the cell you want to edit and press the F2 shortcut. Hence option 1 is correct.
• If you are saving the file for the first time, saving the file in a different location or under a different name, use the Save As option from the File tab.

Additional Information

• Comments are used for conversations between different users which you can see when you hover over the cell that has comments.
• You can insert a comment into a cell. To do that, right-click the selected cell, and click the new comment option.
• To open an existing file, go to the File tab > Open option or use the Ctrl + O shortcut.
• To insert a table, go to the Insert tab > Tables group >  Table.

The correct answer is program that accepts a program written in a high level language and produces an object program.

Key Points

• A compiler is a specialized software tool that translates programs written in high-level programming languages (like C, C++, Java, etc.) into machine language or an intermediate code.
• This machine language is a set of instructions that a computer's central processing unit (CPU) can directly execute.
• The resulting output is often called an object program or binary, which can be run on a computer without the need for the source code.
• This process involves several stages, including lexical analysis, syntax analysis, semantic analysis, optimization, and code generation.

The correct answer is 1024 PB.

Key Points

• EB stands for Exabyte, which is a unit of digital information storage.
• 1 Exabyte (EB) is equal to 1024 Petabytes (PB).
• Petabyte (PB) is a unit of digital information storage equal to 1024 Terabytes (TB).
• Exabyte is often used to measure data storage capacity for large-scale data centers and cloud storage services.

Additional Information

• Exabyte (EB)
• An Exabyte (EB) is a unit of digital information storage equal to 10^18 bytes (1,000,000,000,000,000,000 bytes) or 1024 Petabytes (PB).
• EB is used to describe large data sets and is often utilized in the context of big data, data warehouses, and cloud storage.
• For example, it is estimated that all the words ever spoken by humans would take up about 5 Exabytes of storage.
• Petabyte (PB)
• A Petabyte (PB) is a unit of digital information storage equal to 10^15 bytes (1,000,000,000,000,000 bytes) or 1024 Terabytes (TB).
• PB is commonly used to measure the amount of data in large databases and data warehouses.
• For example, the Large Hadron Collider (LHC) generates about 15 Petabytes of data annually.
• Terabyte (TB)
• A Terabyte (TB) is a unit of digital information storage equal to 10^12 bytes (1,000,000,000,000 bytes) or 1024 Gigabytes (GB).
• TB is commonly used to measure the storage capacity of hard drives and other storage devices.
• For example, a modern laptop may have a storage capacity of 1 to 2 Terabytes.
• Gigabyte (GB)
• A Gigabyte (GB) is a unit of digital information storage equal to 10^9 bytes (1,000,000,000 bytes) or 1024 Megabytes (MB).
• GB is commonly used to measure the size of files, such as videos, photos, and software applications.
• For example, a high-definition movie may take up about 4 to 5 Gigabytes of storage.

The correct answer is Complementary Metal-Oxide Semiconductor.

Key Points

• CMOS stands for Complementary Metal-Oxide Semiconductor, a technology used in electronic circuits.
• It is widely used in modern digital integrated circuits, including microprocessors, microcontrollers, and other digital logic circuits.
• CMOS technology is characterized by its low power consumption, making it ideal for battery-operated devices.
• In computer systems, CMOS refers to a small amount of memory on the motherboard that stores BIOS settings, such as system time and hardware configurations.
• The CMOS battery powers this memory, ensuring the stored settings are retained even when the computer is turned off.

Additional Information

• Metal-Oxide-Semiconductor Field-Effect Transistor (MOSFET):
• CMOS technology relies on MOSFETs, which are transistors that use an electric field to control the flow of current.
• These transistors are used in pairs (p-type and n-type) in CMOS circuits to minimize power consumption.
• Applications of CMOS:
• Commonly found in digital cameras, smartphones, and other portable electronic devices.
• Essential for the production of energy-efficient processors and memory chips.
• CMOS vs. TTL:
• TTL (Transistor-Transistor Logic) was a widely-used technology before CMOS.
• CMOS is preferred over TTL for modern applications due to its lower power consumption and higher integration density.
• CMOS Battery:
• The CMOS battery, typically a CR2032 lithium cell, provides power to the CMOS memory chip to store BIOS settings.
• If the CMOS battery dies, the system may lose its time and hardware configuration settings, requiring manual reconfiguration.

Correct answer is Ctrl+Alt+Del.

Key Points

• A warm boot is a method of restarting a computer that is already on without completely turning it off.
• A warm boot is faster than turning a computer off, waiting, and then turning it back on again (cold boot).
• On a computer running Microsoft Windows, a warm boot can be accomplished by pressing the Ctrl+Alt+Del keys simultaneously.

Additional Information

• Ctrl+F2+Del shortcut key is used to clear the browser history of chrome.
• Ctrl+Upward Arrow+Del shortcut key moves to the beginning of the line or paragraph and deletes particular text from the cursor point.
• Ctrl+F2 Display the print preview. and Ctrl+F2+Del is used to delete the text of documents**.**

The correct answer is 'Bookmark'

Key Points

• Bookmark:
• Web browsers offer the option to bookmark web pages, allowing users to save and organize links to websites for easy access in the future.
• This feature helps users to quickly find their favorite or frequently visited websites without having to remember the URLs.
• Bookmarks can be organized into folders, and browsers typically offer various ways to manage and access these bookmarks efficiently.

Additional Information

• History:
• The History feature in web browsers automatically keeps track of all web pages visited over a period of time, allowing users to revisit previously viewed pages easily.
• Unlike bookmarks, the history is generated automatically and does not require user action to save specific pages.
• Setting:
• The Setting option in web browsers allows users to customize their browsing experience, including privacy settings, appearance, and other preferences.
• It does not directly involve saving or organizing websites for later use.
• Save as:
• The Save as feature enables users to save a web page on their computer as a file, typically in HTML format, for offline access.
• While it allows for saving content, it is not specifically designed for organizing and quickly accessing multiple web pages.

The correct answer is it returns the average of the values in the list of arguments.

Key Points

• AVERAGEA() function in MS Excel calculates the average of the values in the list of arguments. Hence option 2 is correct.
• Its syntax is AVERAGEA(value 1, [value 2],.....). Here value 1 is required and the subsequent values are optional. 1 to 255 cells, or variables for which you want to calculate the average.
• Arguments can be numbers, names, arrays or references that contain numbers, the text representation of numbers or logical values such as True or False etc.
• Arguments that contain TRUE evaluate as 1 and arguments that contain FALSE are evaluated as 0.

Additional Information

• The AVERAGE() function returns the average of the arguments. Its syntax is AVERAGE(number 1, [number 2],......). For example, AVERAGE(B1:25) returns the average of the numbers in between the cells B1 and B25.
• AVERAGEIF() function returns the average of all the cells in the range that meet the given criteria. Its syntax is AVERAGEIF(range, criteria, [average_range]). Here, the range is the number of cells and it is required. Criteria means conditions, it can be an expression, number or array, logical etc.
• AVERAGEIFS() function returns the average of all cells that meet multiple criteria. Its syntax is AVERAGEIFS(average_range, criteria_range1, [criteria_range 2, criteria2],....).

The correct answer is current date

Important Points

• In MS Excel, ctrl + : is used to insert current time in the workbook.
• Ctrl + ; is used to insert the current date in the workbook.
• Formula = TEXT (CELL, “dddd”) is used to get the day name from the given date.

Key Points

• A static value in a worksheet is one that doesn’t change when the worksheet is recalculated or opened. When you press a key combination such as Ctrl+; to insert the current date in a cell, Excel “takes a snapshot” of the current date and then inserts the date in the cell. Because that cell’s value doesn’t change, it’s considered static.
• On a worksheet, select the cell into which you want to insert the current date or time.
• Do one of the following:

1. To insert the current date, press Ctrl+; (semi-colon).
2. To insert the current time, press Ctrl+Shift+;(semi-colon).
3. To insert the current date and time, press Ctrl+; (semi-colon), then press Space and then press Ctrl+Shift+; (semi-colon).

• To change the date or time format, right-click on a cell, and select Format Cells. Then, on the Format Cells dialog box, in the Number tab, under Category, click Date or Time and in the Type list, select a type, and click OK.