DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Sorting
|
|
Filtering
|
|
Conditional Formatting
|
|
Hiding unwanted data
|
Detailed explanation-1: -Data sorting is any process that involves arranging the data into some meaningful order to make it easier to understand, analyze or visualize.
Detailed explanation-2: -Sorting is the process of arranging data into meaningful order so that you can analyze it more effectively.
Detailed explanation-3: -Ans:-Sorting means arranging. Sorting data refers to the process of arranging data, either in ascending order or in descending order. Sorting can be done on numbers or text or both.
Detailed explanation-4: -Answer: Sorting is used to rearrange data in a specific order.
Detailed explanation-5: -Answer: When the raw data is arranged in ascending or descending order, then the data is called arrayed data. Example: The marks obtained by 5 students in a Science test as given below in raw data: 70, 100, 45, 80, 55. Raw data into Arrayed data: 45, 55, 70, 80, 10.