Question

15. Why might you choose to filter a list or table instead of simply sorting it?
a. Filtering displays only those records that match the criterial you specify; other records are temporarily hidden.
b. You can then copy out the matched data and paste into another spreadsheet.
c. You can also manipulate the filtered data without affecting the rest of database.
d. You have a large amount of data you need to separate into various categories.

Answer 1

Answer:

a. Filtering displays only those records that match the criterial you specify; other records are temporarily hidden.

Explanation:

The first one is definitely true as we have a lot of data, and it is hard to decide from that level of data. Hence, it can be hard to analyze the data as the data is huge. However, if the data is filtered then we can end up with less data, and thus we can analyze through visualization, machine learning the data, and also make better use of the Data Science, statistics.

Others are false.