Question

3.
Name the following.
a) The field(s) which uniquely identify a record.
bi
question which gives filtered data​

Answer 1

Answer:

primary key

Data filtering is the process of choosing a smaller part of your data set and using that subset for viewing or analysis. Filtering is generally (but not always) temporary – the complete data set is kept, but only part of it is used for the calculation.

Which tab contains the filter option?

On the Data tab, in the Sort & Filter group, click Filter. in the column header to display a list in which you can make filter choices. Note Depending on the type of data in the column, Microsoft Excel displays either Number Filters or Text Filters in the list.

Explanation: