# Solutions of exercises Charts in MS Excel 2016

#### Bytutorialaicsip

Aug 28, 2020

In this article, you will get the questions for the topic charts in MS excel.

Topics Covered

## Objective type questions – Charts in MS Excel

1. Line
2. Data
3. Pie
4. Chart
5. Sparkline

### True of False

1. False – Correction: A line chart shows change over time intervals.
2. True
3. True
4. False – Correction: Win/Loss is a kind of sparkline.
5. True

### MCQs

1. iii. Doughnut chart
3. ii. Legend
4. iv. Line Chart
5. ii. Bar

Watch this video to understand the concept how to insert Chart in MS excel:

## Descriptive Questions

### Short answer questions :(2/3 marks)

Use this link and find the answers (not provided): Creating charts in Excel

2. How you can draw a chart ? or How you can insert a chart?
3. How to change the chart type?

1. Select the chart.
2. Click on Design –> Change Chart Type option from Type group.
3. Change chart type dialog box appears.
4. Select the desired chart from the list of charts.

4. How to switch row and column data into chart?

1. Select the chart.
2. Click on Design –> Switch Row/Column from the data group.

5. What are sparklines?

6. What are the types sparklines?

Answer: There are three types of sparklines:

1. Line
2. Column
3. win/loss

7. How to display data label on chart area?

1. Select the chart.
2. Click on + icon coming at the top right side of the chart.
3. Now find the option data label. (All chart types do not support data label.)
4. Click on the check for the data label.

8. What is a combo chart?

Answer: A combo chart is a combination of more than one chart on similar data. In other words, A combo chart is a series of multiple chart on similar data and chart area.

Watch this video to understand advanced charts available in MS excel 2016 and higher version.

## Long Answer Questions: (5 Marks)

1. What are the various types of charts?
2. What are the advantages of a chart?
3. What are the elements of the charts? or What are the components of a chart? Explain each of them in short.
4. How to create a combo chart?

1. Select Data that you want to plot on the chart.
2. Click on the Insert tab.
3. Now find the option Recommended Charts. The Insert Chart dialog box will appear.
4. Click on the All Charts tab.
5. Find the Combo chart from the list and select it.
6. Now select the column and chat type as per your requirements.
7. Click on OK to display the chart on the worksheet.

Watch this video to understand how to create combo chart?

5. How to insert sparklines in the worksheet?

1. Select the data except top row.
2. Click on Insert tab.
3. Find the Sparklines group and select the desired sparkline like Line, column or win/loss.
4. The Create Sparklines dialog box appears.
5. Select the location range, where you want to display the sparklines.
6. Click on OK button to display the chart on the worksheet.