What is the main function of the electronic spread sheet?
- A.Filtering
- B.Merging
- C.sorting
- D.All of Above
Correct answer
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.
Practice Questions
View allWhich language uses the symbolic representation of machine codes needed to program a particular processor or processor family?
- A.Machine Language
- B.Assembly Language
- C.High-Level Language
- D.All of the above
Show answer
Assembly language replaces the binary machine codes of a processor with short symbols called mnemonics, such as MOV, ADD and JMP.
Read the full explanation →Which one of the following is the characteristic of Artificial Intelligence ?
- A.Replicates human decision making
- B.Stores relevant information
- C.Stores similar kind of data for a specific purpose
- D.Allows user to interact with media
Show answer
Artificial Intelligence is the ability of a machine to perform tasks that normally need human intelligence, such as reasoning, learning and taking decisions.
Read the full explanation →What is an interactive combination of text, graphics, video, audio and images termed as ?
- A.JPEG
- B.Multimedia
- C.AVA
- D.PNG
Show answer
Multimedia means using several forms of media, such as text, graphics, audio, video, images and animation, together, often in a way the user can interact with.
Read the full explanation →Which among the following is a malicious software?
- A.Hacking
- B.Password Cracking
- C.Trojan Horse
- D.Firewall
Show answer
A Trojan is a program that looks useful or harmless but secretly carries harmful code, so it is a piece of malicious software, or malware.
Read the full explanation →Which one of the following is not an application software?
- A.Spreadsheet
- B.AutoCAD
- C.MS PowerPoint
- D.Linker
Show answer
A linker is system software, a programming tool that joins compiled pieces of code into one program that can run; it does not do a task for the end user.
Read the full explanation →