Question

which feature of excel can be used to display only selected data out of the worksheet​

Answer 1

Data filter feature of ms excel is used to display selected data only

Explanation:

Filtering

Filtering is a process where we  can see only data as per defined criteria.

Suppose a table has data of sales figure of 10 products for 5 years

We can select a filter for one particular product & see its data only

We can apply multiple filters.

if we have to see two product or three products we can selects those.

we can apply filter like

Greater than

Smaller than

Equal to

not equal to

custom filter

data sort :

Data can be Sorted

Alphabetically  (A - Z  or Z -A)

Ascending / Descending order

Based on Cell color  

as per custom rule defined by user

Complete data is visible to user but in the sequence as sorted by user.

chart​ is to create chart of data  in different form

column . line , pie ,  bar , area , scatter , other

pivot table

pivot table is a table of statistics that summarizes the data of a more  extensive table.

Data filter feature of ms excel is used to display selected data only

Learn More:

Difference between sorting and filtering in excel - Brainly.in

https://brainly.in/question/8773232

Which of these charts does not exist in MS Excel. *1 point(a). Scatter ...

https://brainly.in/question/33686516

Answer 2

$\huge \cal \mid \mid \colorbox{aqua}{ANSWER} \mid \mid$

Data Filter is the feature of excel which can be used to display only selected data out of the worksheet.