Long Answer Type Questions: Advance Features of Excel | Computer Applications for Class 9 PDF Download

Q.1. Explain mixed cell referencing with an example.

Mixed cell referencing is a combination of Relative and Absolute cell referencing. As with absolute cell references, the dollar sign ($) is used in mixed cell references to indicate that a column letter or row number is to remain fixed when copied from one cell to another. Example $E4, F$6, etc. Note that for the cell reference $E4 the column letter is fixed while the row number is allowed to change when copied to other cells. For the cell reference F$6, the row number is fixed while the column letter changes.

Q.2. Define the following charts in Excel.
(a) Line Chart
(b) Pie Chart 
(c) Scatter Chart 
(d) Bar Chart

(a) A line chart shows trends and variations in data over time using a line. It displays a series of points that are connected over time.
(b) A pie chart displays the contribution of each value to the total. It is very useful to display information when you want to represent different parts of the whole, or the percentages of a total.
(c) Scatter charts are typically used for showing and comparing numeric values, like scientific, statistical, and engineering data. It combines x and y values into single data points and shows them in irregular intervals, or clusters.
(d) A bar chart is similar to a column chart except it uses horizontal bars instead of vertical bars it is also used to show variations in value over time. This charts also allows us to compare values.

Q.3. Explain the use of the following with respect to charts.
(a) Source Data 
(b) Axis 
(c) Data Series 
(d) X-Axis

(a) Source data are the values upon which a chart is created.
(b) An axis on a chart or graph in Excel is a horizontal or vertical line containing units of measure. The axes border the plot area of column charts (bar graphs), line graphs, and other charts.
(c) Data Series is a collection of related values that are plotted on a chart.  
(d) It is a horizontal line that shows variation another component of the chart.  Its length and segments represent different intervals of the values.