Question

1. Sort and Filter is found under tab.
2. filter is the quickest way to filter a database.
3. Auto filter is the quickest way to filter a database. State true or false.
4.Sorting can be done in ascending order only. State true or false.
5. Mention any 1 logical function.​

Answer 1

Answer:

4. Data is typically sorted based on actual values, counts or percentages, in either ascending or descending order, but can also be sorted based on the variable value labels.

Answer 2

Answer:

1. Click the Sort & Filter command in the Editing group on the Home tab.

2. Selecting values from a list and searching are the quickest ways to filter. When you click the arrow in a column that has filtering enabled, all values in that column appear in a list.

3. The answer is true.

4. Excel can arrange data in ascending order only.You cannot sort more than one columns at a time in a. selected range of cells.

5. Logical functions are used in spreadsheets to test whether a situation is true or false. Depending on the result of that test, you can then elect to do one thing or another. These decisions can be used to display information, perform different calculations, or to perform further tests.

Explanation:

please mark me as brainliest ☺️