IT &computer MCQ section 2 MCQ Questions & Answers Detailed Explanation

Answer: (d)

A modem (modulator-demodulator) is a device that modulates an analogue carrier signal to encode digital information, and also demodulates such a carrier signal to decode the transmitted information.

The goal is to produce a signal that can be transmitted easily and decoded to reproduce the original digital data.

Answer: (c)

A local area network (LAN) is a computer network that interconnects computers in a limited area such as a home, school, computer laboratory, or office building using network media.

The defining characteristics of LANs, in contrast to wide area networks (WANs), include their usually higher data-transfer rates, smaller geographic area, and lack of a need for leased telecommunication lines.

Answer: (a)

A spreadsheet is an interactive computer application program for the organization and analysis of information in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets.

The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array is a model–view–controller element that can contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells. It is more useful in Statistics.

Answer: (a)

The process is known as index definition. The order in which columns are listed in the index definition is important.

Answer: (b)

The three-finger salute refers to the original PC-compatible system command to reboot or restart a computer by pressing three keys simultaneously: Control, Alt and Delete.

The three-key combination of Control-Alt-Delete is specifically designed to be impossible to execute with one hand in order to avoid the potential for accidental reboots. It was developed by David Bradley.

Answer: (a)

In a computer, storage is the place where data is held in an electromagnetic or optical form for access by a computer processor. It is a technology consisting of computer components and recording media used to retain digital data. It is a core function and fundamental component of computers.