Anandita's Quiz (7A)

which is the process of arranging data in a particular order called?

• sorting

• goal seek

• filtering

in which tab is the advanced filter option available?

• data tab

• home tab

• view tab

in which group is the sort option available?

• sort & filter group

• data tools group

• view group

in which option is goal seek available?

• consolidate option

• what-if analysis open

• filter option

(a)   means arranging the data in ascending or descending order

filter is available in (a)   group

Goal seek option is present in (a)   tab

You cannot remove a filter

• true

• false

Sort & filter group is present in data tab

• true

• false