Page 1 :
] WEAERCISE bp», , Tick (7) the correct answer: ©, , , , , , , , L, Which of the following chart ;, (a) Fei chart oti rt plots data in the form of Line?, (i) CO (ii) Doughnut chart <5 Line chart, | (b) Component of a chart depicts the colours, patterns ann net 2) Re; ae * Patterns and symbols assigned to a det, (i) Gridlines <> (ii) Plot Area Ci) Legend a a data series, i awh , : C7 (iv) None of these, (€) Feature is used to viewing only selective data that satisfies agiven condition:, (i) Sorting © (ii) Goal seek Ori Fitter) Givy vata a, (d) Name the special window that displays data when you insert a at vis a on, (i) Spreadsheet (> (ii) Datasheet Ci) Database > () Sheet a, {e) Which feature allows us to arrange the given data according to a p: ri aire —, ; ascending or in a descending order? Si? 2 Particular Feld etter in an, (i) Database > (i) Filter «iI Sort} Gv) data Validation, | B. Fillin the blanks :, { (a) are the bars, slices or other elements that Tepresent the data values,, (b) A is a pictorial representation of data., () Means arranging data either in ascending or descending order., (d) 4 is the title given to the marker in a chart., | © Write ‘T’ for true and ‘F’ for false statements : P, q, , (2) When the data changes, the chart is updated automatically., (6) Category axis is the horizontal axis of the chart., (©) Ina column chart, categories are organised along the horizontal axis and values, { along the vertical axis., , (4) Value Axis is also known as x-axis., ___ (©) Filtering means sorting data., , is)), , , , ®, ®