which feature of ms excel is used to display selected data only?
data sort
pivot table
data filter
chart
Answers
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