CLASS IX

  1.   What is the intersection of a column and a row on a worksheet called? a.   Column b.   Value c.   Address d.   Cell 2.   What type of chart is useful for comparing values over categories ? a.            Pie b.           Line c.             Dot d.           Column 3.           Which function in Excel tells how many numeric entries are there? a.   NUM b.SUM c.Count d.none   4.           What type of chart is useful for showing trends or changes over time? a.            Pie b.           Line c. ...

OPEN THE LINK AND SUBMIT THE ASSIGNED PRACTICAL WORK.   https://forms.gle/fxJzWYoug7SsjT8bA

Write down the name and purpose of various components of a chart. Answer: Various components or parts of chart are as follows: X-axis Refers to a horizontal axis, which is also known as category axis. Y-axis Refers to a vertical axis also known as value axis. X-axis title Conveys the full details of the X-axis values. Y-axis title Conveys the full details of the Y-axis values. Data series Refers to a set of data that you want to display in a chart. Chart area Refers to the total space that is enclosed by a chart. Plot area Refers to the main region of the chart in which your data is plotted. Chart title Denotes the type of data plotted in a chart. Legend In a chart showing different data series, a unique color or pattern is assigned to each data series. This unique color of pattern is known as a legend. Gridlines These are the horizontal and vertical lines within the plot area in a chart. Explain the concept of cell referencing along with its various types. Answer: Excel supports thr...