Define the three types of data filters and give an example of when each may be used
What will be an ideal response?
• Filter by form: you may want to filter the records that have a "Santa Fe" value in the "City" field. The Filter by Form type could be used, which allows you to filter data in a form or datasheet.
• Filter by selection: this method works well if you see a value you want to use as a filter.
• Advanced filter: Because the Filter by Form or Filter by Selection filters may not give enough options, as they are fairly basic, you might want to apply a filter that is an advanced filter in which you write the filter criterion yourself. For example, you may want to find products that contain dates occurring during the past seven days. After you apply an advanced filter, you can further limit the results to those that have a price of over $100 . Using the advanced filters does require writing expressions.
You might also like to view...
The diamond that represents the condition appears at the top of the loop in the flowchart of a posttest loop.
Answer the following statement true (T) or false (F)
AutoCorrect options are located in which Excel Options category?
A) Advanced B) Formulas C) General D) Proofing
When a Table Style is used to format a table, the formatting is applied to the ________
A) cell containing the insertion point B) entire table C) column containing the insertion point D) row containing the insertion point
In the Mac OS GUI, you can drag scrollers to display more window content.
Answer the following statement true (T) or false (F)