Question

Computer (Information Technology)



Q-1 Fill in the blanks

(1) ________axis is also called as vertical axis or value axis.

(2) Colors palter for the data series is called as __________.

(3) _________ is a combination of two charts.

(4) _________ is also called as mini chart.

(5) Sparklines is available in ________ tab.





Q-2 True / False

(1) A chart updated automatically with the change in data.

(2) We cannot modify the chart by changing colors and patterns.

(3) X-axis is horizontal axis.

(4) The chart area contains the actual chart itself and includes data series, category and value axis as well.

Q-3 Answer in detail

(1) What is difference between chart area and plot area?

(2) What is combo chart? and how to make a combo chart in excel.

(3) Explain Sparklines in brief.

Answer 1

Answer:

A sparkline is a tiny chart in a worksheet cell that provides a visual representation of data. Use sparklines to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values.

Combination Chart

1. On the Insert tab, in the Charts group, click the Combo symbol.
2. Click Create Custom Combo Chart.
3. The Insert Chart dialog box appears. For the Rainy Days series, choose Clustered Column as the chart type. For the Profit series, choose Line as the chart type. ...
4. Click OK. Result: