Skip to content
GK24
Computer AwarenessEasyAsked in: Madhya Pradesh · 6 April 2016, Shift 1

What is the main function of the electronic spread sheet?

  1. A.Filtering
  2. B.Merging
  3. C.sorting
  4. D.All of Above

Correct answer

D. All of Above

Explanation

The correct answer is D, All of Above. An electronic spreadsheet such as Microsoft Excel or LibreOffice Calc can filter, merge and sort data, so all three belong to its work and no single one of them is the answer. A spreadsheet keeps data in a grid of rows and columns; the box where a row and a column meet is a cell, and a cell may hold a number, text or a formula. Its real strength is that a formula recalculates by itself the moment a figure it uses is changed, which is why spreadsheets are used for accounts, marksheets, salary statements and simple databases. Besides sorting and filtering it offers functions such as SUM, AVERAGE and COUNT, pivot tables, and charts drawn straight from the data. A is wrong because filtering, which hides rows that do not meet a condition, is only one of these jobs. B is wrong because merging cells is likewise only one. C is wrong because sorting, arranging rows by the order of a column, is one more. Exam tip: a spreadsheet file is a workbook and each page inside it is a worksheet.

View all
Q1.Computer AwarenessHard

MeghRaj is the name of which initiative of the Government of India?

  1. A.The national cloud computing initiative
  2. B.A weather forecasting satellite
  3. C.A rural broadband scheme
  4. D.A digital payments platform
Show answer

Correct answer: A. The national cloud computing initiative

Explanation

The correct answer is A, the national cloud computing initiative. MeghRaj is the name given to the Government of India Cloud, usually shortened to GI Cloud, under which government departments obtain their computing and storage from a common set of government managed data centres rather than each building its own. The aim is to cut duplicated hardware, shorten the time taken to launch an e-governance application and let departments pay only for what they use, and the name itself joins the Hindi word for cloud to the idea of governance. Option B is wrong because India's weather satellites belong to the INSAT series and the observation work is done by the India Meteorological Department, not by a cloud programme. Option C is wrong because rural connectivity is the business of the BharatNet optical fibre programme. Option D is wrong because digital payments run on the Unified Payments Interface and related systems built by the National Payments Corporation of India. Learn MeghRaj together with the three service models, since a question often pairs them.

Q2.Computer AwarenessEasy

Which of the following statements about artificial intelligence, machine learning and deep learning is correct?

  1. A.Deep learning is a subset of machine learning, which is a subset of artificial intelligence
  2. B.Artificial intelligence is a subset of machine learning
  3. C.Machine learning is a subset of deep learning
  4. D.The three terms mean exactly the same thing
Show answer

Correct answer: A. Deep learning is a subset of machine learning, which is a subset of artificial intelligence

Explanation

The correct answer is A. The three terms sit one inside the other like circles. Artificial intelligence is the whole field of making machines behave intelligently, and it includes approaches that use no learning at all, such as rule based expert systems and search algorithms. Machine learning is the part of it in which the program is shown examples and works out the pattern itself instead of being given the rules. Deep learning is a part of machine learning that uses artificial neural networks with many hidden layers, and it is what made image recognition, speech recognition and machine translation work well. Option B is wrong because it inverts the outermost relation; artificial intelligence is the widest of the three, not the narrowest. Option C is wrong because it inverts the inner relation: deep learning is inside machine learning, not the other way round. Option D is wrong because the three are nested and not identical, and examiners test exactly this nesting. The three families of machine learning are supervised, unsupervised and reinforcement learning.

Q3.Computer AwarenessMedium

The basic unit of information in a quantum computer is called a ______.

  1. A.Bit
  2. B.Byte
  3. C.Qubit
  4. D.Nibble
Show answer

Correct answer: C. Qubit

Explanation

The correct answer is C, a qubit. A classical computer stores information in bits, each of which must be either zero or one at a given moment. A quantum computer uses a quantum bit, shortened to qubit, which can be in a superposition of zero and one at the same time, and qubits can also be entangled so that the state of one is tied to the state of another. These two properties allow a quantum machine to explore many possibilities together, which is why certain problems in factorisation, search and molecular simulation could be solved far faster than on any classical machine. Option A is wrong because the bit is the unit of classical computing, the very thing the qubit replaces. Option B is wrong because a byte is simply a group of eight bits, the usual unit for measuring storage. Option D is wrong because a nibble is a group of four bits, that is half a byte. Remember the trio of terms that come with the qubit: superposition, entanglement and decoherence, the last being the loss of the quantum state through disturbance.

Q4.Computer AwarenessHard

In a blockchain, what makes it practically impossible to alter a record once it has been added?

  1. A.Each block stores the cryptographic hash of the previous block
  2. B.The data is stored on a single secure server
  3. C.The records are protected by a password
  4. D.Each block is encrypted with the user's fingerprint
Show answer

Correct answer: A. Each block stores the cryptographic hash of the previous block

Explanation

The correct answer is A. Entries on a blockchain are grouped into blocks, and every block carries the cryptographic hash, a short fixed length fingerprint, of the block immediately before it. Changing even one character inside an old block changes that block's hash, which no longer matches the value recorded in the next block, and so the mismatch cascades through every later block; since identical copies of the chain are held by many computers on the network, the tampered copy is rejected at once. This is why a blockchain is called tamper evident and append only. Option B is wrong because it states the opposite of the design: a blockchain is deliberately distributed across many nodes and has no single server to attack. Option C is wrong because a password controls who may write, not whether a written record can be silently changed. Option D is wrong because fingerprints are a means of authenticating a person and are not used to seal blocks. The idea was published in the 2008 Bitcoin paper under the name Satoshi Nakamoto.

Q5.Computer AwarenessEasy

What is the full form of RFID, a technology widely used in the Internet of Things?

  1. A.Radio Frequency Identification
  2. B.Remote Field Input Device
  3. C.Rapid File Indexing Directory
  4. D.Real Frequency Internet Data
Show answer

Correct answer: A. Radio Frequency Identification

Explanation

The correct answer is A, Radio Frequency Identification. An RFID system has a tag carrying a tiny chip and an antenna, and a reader that sends out radio waves; the tag answers with its stored identity, so an object can be recognised without being seen or touched and without a line of sight, unlike a barcode that must be shown to a scanner. Passive tags carry no battery and draw their power from the reader's signal, which is why they can be made as thin as a label. RFID is used in toll collection, library books, baggage handling, warehouse stock and animal identification, and it was work on exactly such tags that led Kevin Ashton to the phrase Internet of Things. Option B, option C and option D are all invented expansions that do not correspond to any real technology; they are offered only because they use the same letters. Note the related short range technology NFC, near field communication, which is the basis of tap to pay cards.