Question

which features of excel used to display selective data​

Answer 1

$\huge\pink{\mathfrak{answer}} -$

• Pivot Tables
• PivotTables summarise large amounts of Excel data from a database that is formatted where the first row contains headings and the other rows contain categories or values. The way the data is summarised is flexible but usually the Pivot Table will contain values summed over some or all of the categories.

• If you’re new to creating PivotTables, Excel 2013 can analyze your data and recommend a PivotTable for you. Once you’re comfortable with PivotTables you can start from scratch and create your own.

• To create a Pivot Table, make sure your data has column headings or table headers and that there are no blank rows. Click any cell in the range of cells or table.

• In the Recommended PivotTables dialogue box that launched, click any Pivot Table layout to get a preview then select the one that works best for you and click OK.

• Excel will provide a selection of recommended PivotTables for your data. Excel then places the PivotTable on a new worksheet and shows the field list so that you can rearrange the data to best suit your needs. Again, make sure your data has column headings or table headers and no blank rows.

• 2) Conditional Formatting
• Conditional formatting, as its name suggests, changes the format of a cell dependent on the content of the cell, or a range of cells, or another cell or cells in the workbook. Conditional formatting helps users to quickly focus on important aspects of a spreadsheet or to highlight errors and to identify important patterns in data.

• Conditional formats can apply basic font and cell formatting such as number format, font colour and other font attributes, cell borders and cell fill colour. In addition, there is a range of graphical conditional formats that helps with visualising data by using icon sets, colour scales, or data bars.

Answer 2

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