Question

True or false if false correct the statement

1) Filtering is a quick way to find the set of data in a range

2) In mixed referencing, either column part or row part is fixed

Answer 1

Answer:

true filtering is a quick way to find the set of data in a range

false in minced reference Singh both column part and row part is fixed

Answer 2

Answer:

Concept:

Finding whether the given statements are true or false.

Explanation:

Filtering

• Create filter rules that only display the items you are interested in to display a subset of the elements in a table. You are only filtering the items that are now listed in the table because filtering does not cause the table to be refreshed.
• Data that has been filtered shows only the rows that match the criteria you provide and conceals the rows you do not wish to be shown.

Filtering is a quick way to find the set of data in a range - True

Mixed referencing

• A form of Absolute reference known as Mixed Reference makes either the column or the row constant. When a column or row is made constant, the column name or row number do not change when the formula is copied to another cell (s).

In mixed referencing, either column part or row part is fixed - True

#SPJ2