In Excel 2010, new features such as sparklines and slicers, and improvements to PivotTables and other existing features can help you to discover patterns or trends in your data that can lead to more-informed decisions. You can use sparklines—tiny charts that fit in a cell—to visually summarize trends alongside data.
Table of Contents
Which feature introduced in MS Excel 2010 is used to Analyse data trends?
In Excel 2010, new features such as sparklines and slicers, and improvements to PivotTables and other existing features can help you to discover patterns or trends in your data that can lead to more-informed decisions. You can use sparklines—tiny charts that fit in a cell—to visually summarize trends alongside data.
What are the different parts of an Excel 2010 chart?
The typical chart (or graph) in Excel 2010 comprises several distinct parts, including the chart area, data series, axes, legend, plot area, gridlines, data markers, and more.
Which of the features are available in Excel charts?
Types of charts
- Excel has a variety of chart types, each with its own advantages.
- Column charts use vertical bars to represent data.
- Line charts are ideal for showing trends.
- Pie charts make it easy to compare proportions.
- Bar charts work just like column charts, but they use horizontal instead of vertical bars.
Where are Excel 2010 charts recommended?
Click Insert > Recommended Charts. On the Recommended Charts tab, scroll through the list of charts that Excel recommends for your data, and click any chart to see how your data will look.
What are the 5 features of MS Excel?
Features of MS Excel
- Home. Comprises options like font size, font styles, font colour, background colour, alignment, formatting options and styles, insertion and deletion of cells and editing options.
- Insert.
- Page Layout.
- Formulas.
- Data.
- Review.
- View.
What are Excel features?
Features of Microsoft Excel
- Add Header and Footer. MS Excel allows us to keep the header and footer in our spreadsheet document.
- Find and Replace Command.
- Password Protection.
- Data Filtering.
- Data Sorting.
- Built-in formulae.
- Create different charts (Pivot Table Report)
- Automatically edits the result.
What are the chart features explain?
A chart is a graphical representation for data visualization, in which “the data is represented by symbols, such as bars in a bar chart, lines in a line chart, or slices in a pie chart”. A chart can represent tabular numeric data, functions or some kinds of quality structure and provides different info.
What are the different elements of a chart?
Explanation:
- Chart area: This is the area where the chart is inserted.
- Data series: This comprises of the various series which are present in a chart i.e., the row and column of numbers present.
- Axes: There are two axes present in a chart.
- Plot area: The main area of the chart is the plot area.
How do I create a chart in Excel 2010?
Creating Chart
- Select the data for which you want to create the chart.
- Choose Insert Tab » Select the chart or click on the Chart group to see various chart types.
- Select the chart of your choice and click OK to generate the chart.
How do you use chart features in Excel?
Recommended Charts Feature in Excel
- First, select or highlight the data you’d like to organize.
- In the “Insert” tab on the ribbon, select “Reccomended Charts.”
- In the “Reccomended Charts” tab of the “Insert Chart” menu, look through the chart previews and select the chart you prefer.
- Your chart will open in Excel.
What are the 10 features of MS Excel?
The Top 10 Excel Features
- Conditional Formatting. Utility: 100 | Difficulty: 3 | Learn in 180 mins.
- PivotTables. Utility: 95 | Difficulty: 3 | Learn in 240 mins.
- Paste Special. Utility: 88 | Difficulty: 3 | Learn in 10 mins.
- Add Multiple Rows.
- Absolute References.
- Print Optimisation.
- Extend formula across/down.
- Flash Fill.
What are the new features in Excel 2010?
There are a ton of new and cool features in Excel 2010. My favorite new features are, These are small charts that can be shown inside a cell and are linked to data in other cells.You can insert a line chart, win-loss chart or column chart type of spark line in excel 2010.
What are spark charts in Excel 2010?
These are small charts that can be shown inside a cell and are linked to data in other cells.You can insert a line chart, win-loss chart or column chart type of spark line in excel 2010. They add rich information analysis capability to mundane tables or dashboards.
What do you like most about Excel 2010?
The day to day stuff can be done in excel 2010. My current work deals with a lot of data and it’s analysis. I use VBA and charts/graphs on a regular basis. To me, the Sparklines, Slicers, improved Filters, improved Conditional Formatting & Pivots functionality is a very welcome move.
What can you do with Excel 2010?
The day to day stuff can be done in excel 2010. My current work deals with a lot of data and it’s analysis. I use VBA and charts/graphs on a regular basis.