Question

C. Answer the following questions: 1. What is a chart?What are the advantages of charts? Q. What is the use of gridlines and data markers in a chart? What is the difference between bar charts and column charts? © What is the use of the sorting feature in MS Excel? 3. Is it possible to change the chart type? If yes, how?​

Answer 1

Ans 1. A chart is a graphical representation of data

Ans 2.the advantages of charts are:

1. Show each data category in a frequency distribution.

2. Display relative numbers or proportions of multiple categories.

3. Summarize a large data set in visual form.

4. Clarify trends better than do tables.

5. Estimate key values at a glance.

6. Permit a visual check of the accuracy and reasonableness of calculations.

Ans. Markers identify data points. You can put markers on all data points in a series or on only selected data points. Grid lines are horizontal or vertical lines that extends from the axis ticks.