USING MICROSOFT WORD
HOW TO USE MAIL MERGE IN MICROSOFT WORD
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
filter
|
|
|
query
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -What is Filter in Excel? The filter in excel helps display relevant data by eliminating the irrelevant entries temporarily from the view. The data is filtered as per the given criteria. The purpose of filtering is to focus on the crucial areas of a dataset.
Detailed explanation-2: -Filter criteria can be applied in a single number or as a set. Filter criteria support sequencing, which implies that multiple filter criteria can be applied to a single request. The traversal of a set of filter criteria is based on the priority assigned to each iFC, from highest to lowest.
Detailed explanation-3: -Select a cell in the database. On the Excel Ribbon’s Data tab, click the Advanced button. In the Advanced Filter dialog box, choose ‘Copy to another location’. For the List range, select the column(s) from which you want to extract the unique values.