DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Sorting
|
|
|
Filtering
|
|
|
Spelling
|
|
|
Subtotals
|
Detailed explanation-1: -The “AutoFilter” or “Sort and Filter” function in Excel allows you to create views of data matching your specified criteria. The subset will show only the rows you wish to see. You can perform several functions on the filtered subset of the data without needing to copy and paste the data into a new worksheet.
Detailed explanation-2: -On the Home tab, in the Sort & Filter group, click Advanced and then click Advanced Filter/Sort on the shortcut menu. Add the fields on which you want to filter to the grid.
Detailed explanation-3: -Filter a range of data Select any cell within the range. Select Data > Filter. Select Text Filters or Number Filters, and then select a comparison, like Between. Enter the filter criteria and select OK.
Detailed explanation-4: -AutoFilter is a function that allows you to view and subset your data easily and quickly without making any permanent changes to your data. You can filter your data by selecting your worksheet or the portion of your worksheet of interest.