DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
filter
|
|
|
standard
|
|
|
chart
|
|
|
None of the above
|
Detailed explanation-1: -Filter. A command to display only the rows of a table that meet specified criteria. Total Row. A row in an Excel table that provides summary functions.
Detailed explanation-2: -Filtered data displays only the rows that meet criteria that you specify and hides rows that you do not want displayed.
Detailed explanation-3: -Filtering is a useful way to see only the data that you want displayed in Access databases. You can use filters to display specific records in a form, report, query, or datasheet, or to print only certain records from a report, table, or query.
Detailed explanation-4: -The Excel FILTER feature “filters” a set of data based on the criteria supplied. In simple language, the FILTER function allows you to easily extract matching records from a larger set of source data based on the criteria you provide. The results of the FILTER are dynamic.