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
Q2.Computer AwarenessAsked in: CDS · CDS-I 2025, GKEasy

Which one of the following is the characteristic of Artificial Intelligence ?

  1. A.Replicates human decision making
  2. B.Stores relevant information
  3. C.Stores similar kind of data for a specific purpose
  4. D.Allows user to interact with media
Show answer
Correct answer: A. Replicates human decision making

Artificial Intelligence is the ability of a machine to perform tasks that normally need human intelligence, such as reasoning, learning and taking decisions.