(i) Sorting means to arrange data in a particular order which could be ascending or descending order.
For example, sorting a list of names of students alphabetically or marks in descending order from the highest to the lowest.
(ii) Filtering is a quick and efficient method where you display only that data that meets a given criteria. Ms excel uses two types of filtering methods, that is, Auto filter and Advanced filter.
maurice.mutuku answered the question on April 10, 2018 at 08:07
-
What is 'automatic recalculation' as used in a spreadsheet?
(Solved)
Explain the meaning of 'automatic recalculation' as used in a spreadsheet.
Date posted:
April 9, 2018
.
Answers (1)
-
What are the advantages of electronic spreadsheet over the traditional ledger book?
(Solved)
Give the advantages of electronic spreadsheet over the traditional ledger book.
Date posted:
April 9, 2018
.
Answers (1)
-
What is 'Print Layout/ Page layout view?'
(Solved)
Explain the meaning of 'Print Layout/ Page Layout view'.
Date posted:
April 9, 2018
.
Answers (1)
-
What is 'Normal view'?
(Solved)
Explain the meaning of 'Normal view' in Microsoft word document.
Date posted:
April 9, 2018
.
Answers (1)
-
State any four differences between a form and a report in computer studies?
(Solved)
State any four differences between a form and a report in computer studies?
Date posted:
April 3, 2018
.
Answers (1)
-
State the differences between Impact and Non-Impact Printers
(Solved)
State the differences between Impact and Non-Impact Printers
Date posted:
April 3, 2018
.
Answers (1)
-
State and explain the two forms of data
(Solved)
State and explain the two forms of data
Date posted:
March 30, 2018
.
Answers (1)
-
Name the various types of pointing devices in a computer.
(Solved)
Name the various types of pointing devices in a computer.
Date posted:
March 23, 2018
.
Answers (1)
-
What are the computer keying devices?
(Solved)
What are the computer keying devices?
Date posted:
March 23, 2018
.
Answers (1)
-
Define peripheral devices and give examples of five explaining the functions
(Solved)
Definition of peripheral devices and and its examples
Date posted:
March 21, 2018
.
Answers (1)
-
Difference between objects linking and embedding
(Solved)
Difference between objects linking and embedding
Date posted:
March 16, 2018
.
Answers (1)
-
Differentiate between computer onboard devices and peripheral devices. Give an example of each.
(Solved)
Differentiate between computer onboard devices and peripheral devices. Give an example of each.
Date posted:
March 15, 2018
.
Answers (1)
-
Differentiate between a transcription error and a transposition error in data processing
(Solved)
Differentiate between a transcription error and a transposition error in data processing.
Date posted:
March 13, 2018
.
Answers (1)
-
Word does not bring up the word ‘thief’ as a mistake when checking the spelling in a document. What could be the reason for this?...
(Solved)
Word does not bring up the word ‘thief’ as a mistake when checking the spelling in a document. What could be the reason for this?
Date posted:
March 12, 2018
.
Answers (1)
-
On clicking the bullet button,you get a bullet type different from what you want to use how do you get word to use the bullet...
(Solved)
On clicking the bullet button,you get a bullet type different from what you want to use how do you get word to use the bullet type you want
Date posted:
March 11, 2018
.
Answers (1)
-
Suppose you are doing grammar check and Word offers a suggestion that you do not understand. What is the best thing to do?
(Solved)
Suppose you are doing grammar check and Word offers a suggestion that you do not understand. What is the best thing to do?
Date posted:
March 8, 2018
.
Answers (1)
-
What is a router?
(Solved)
What is a router?
Date posted:
March 2, 2018
.
Answers (1)
-
What are “quantifiers”? How will you classify them?
(Solved)
What are “quantifiers”? How will you classify them?
Date posted:
March 1, 2018
.
Answers (1)
-
What do you understand by “safety of expressions”?
(Solved)
What do you understand by “safety of expressions”?
Date posted:
March 1, 2018
.
Answers (1)
-
Explain the meaning of “what if analysis” in spreadsheets
(Solved)
Explain the meaning of “what if analysis” in spreadsheets
Date posted:
February 28, 2018
.
Answers (1)