Question

A Tick(the correct answer

1. In M.S. Excel arranging of data in a specific order is done by:
a. Filtering
b. Sorting
c. Customising
d. Auto filter

2. The option in M.S.-Excel through which only the selective data can be viewed whichspecify a givencondition:
a. Auto filter
b. Sorting
c. Custom filter
d. Filtering

3. The option in M.S. Excel, which allows to view only the data that satisfy more than
condition for a column.
a. Auto filter
b. Custom filter
c. Customising
d. Sorting

4. Which of the following statement is not true for filtering the data in M.S. Excel?
a. You can view only selective records using the filtering feature.
b. You can specify more than one criteria for a column when using filters.
c. The rows that do not meet the filter condition are hidden.
d. The rows that do not meet the filter condition are deleted.

5. Which of the following statement is not true about sorting data in MS. Excel?
a. You can sort data in rows on the basis of text, numbers or dates.
b. You can sort data in ascending or descending order.
c. You cannot sort data by more than one column.
d. You can exclude
ACTIVITY​

Answer 1

Answer:

1. sorting.

2.filtering data.

3.costomising

4.you can view only selective record using the filtering features.

5.you can exclude.

Answer 2

Answer:

1: (B) SORTING

2:(A) AUTO FILTER.

3:(A)AUTO FILTER.

4:()I'M NOT SURE ABOUT IT.

5:(C) YOU CANNOT SORT DATA BY MORE THAN ONE COLUMN.