Question Discussion & Solution

The correct answer is Secondary.

• USB Pendrive is a Secondary type of storage device.

Key Points

• The full form of USB is Universal Serial Bus.
• USB is a plug and play interface that allows a computer to communicate with external and other devices.
• The first commercial release of the Universal Serial Bus (version 1.0) was in January 1996.
• USB connectors come in different shapes and sizes. They are of various types which include the standard USB, Mini USB, and Micro USB, have two or more variations of connectors.

Additional Information

• A primary storage device is a storage medium that holds a memory for short periods of time while a computer is running.
• Random-access memory (RAM) and cache are both examples of a primary storage device.
• Tertiary storage devices comprise high-capacity data archives designed to include vast numbers of removable media, such as tapes or optical discs.

The correct answer is Fax.

Key Points

•  Fax machine
  • It is a device that is used to send documents electronically over a telephone network.
  • The transmission can be between two fax machines, or between a fax machine and computer.
  • It digitizes the material with an internal optical scanner and transmitting the information as electronic signals.
• Bandwidth is the maximum amount of data transmitted over an internet connection in a given amount of time. It is expressed as a bitrate and measured in bits per second (bps).

The correct answer is Versatility, Diligence.

Key Points

• Versatility is the characteristic of a computer to perform completely different types of work at the same time, whereas diligence makes it to work for hours without boredom or tiredness. 
• Versatility means the capacity of the computer of performing more than one task at the same time.
• Diligence is the capacity of the computer of performing repetitive tasks without getting tired.
• A computer is free from tiredness, lack of concentration, fatigue, etc therefore it can work for hours without creating any errors.

Additional Information

Characteristics of Computer System are:

• Speed - A computer works with much higher speed and accuracy compared to humans while performing mathematical calculations. 
• Accuracy - Computers perform calculations with 100% accuracy. 
• Diligence - A computer can perform millions of tasks or calculations with the same consistency and accuracy. 
• Versatility
• Reliability
• Memory

The correct answer is option 3 i.e ​Ctrl + Z.

• Ctrl + Z is the shortcut key to undo an action in MS Word.
• Ctrl+W is the shortcut key to close the current window.
• Ctrl+B is the shortcut key to Bold highlighted text.
• Ctrl + U is the shortcut key to underline a text.

The correct answer is Spreadsheet.

Important Points

• MS Excel, a worksheet, also known as a Spreadsheet, is a table into which you enter data and data label.
• Worksheet used in Excel documents is a collection of cells organized in rows and columns. It is the working surface you interact with to enter data.
• Each worksheet contains 1048576 rows and 16384 columns and serves as a giant table that allows you to organize information.
• Typically, a workbook contains several worksheets with related content and only one of the worksheets is active at a time.

Key Points

• The main characteristics of worksheets:
  • Cells: Each worksheet has a significant number of cells that can be assigned values and various formatting options.
  • Rows and Columns: Cells in a worksheet are organized into rows and columns. The API of a worksheet allows you to insert, manipulate and delete rows and columns.
  • Names (Named Ranges): The Worksheet class exposes a Names property of type NameCollection that allows you to create, update and manage names.
  • Collection of Hyperlinks: Each worksheet can contain numerous hyperlinks to web pages, particular cells in the workbook, or email addresses.
  • Find and Replace: You can easily find and replace text and numbers in the content of a worksheet.
  • Protection: You can restrict the user from modifying the content and structure of the worksheet.

Additional Information