Worksheet Solutions: Advance Features of Excel | Computer Applications for Class 9 PDF Download

Q.1. Fill in the blanks with the given words.

(i) A Formula in Excel always begins with a ‘=’ (equal to) symbol.

(ii) The kind of cell reference that remain same when copied to another cell is called Absolute Cell Referencing.

(iii) The kind of cell reference that changes relative to its position same when copied to another cell is called Relative Cell Referencing.

(iv) Mixed cell referencing is a combination of Relative and Absolute cell referencing.

(v) A formula in a cell that directly or indirectly refers to its own cell is called a Circular reference.

(vi) A Pie chart displays the contribution of each value to the total.

(vii) A XY chart is based on one data series consisting of a name, a list of x values and a list of y values.

(viii) A Area chart shows values as points on the y axis with categories on the x-axis.

(ix) A range of cells containing data that makes a chart is termed as Source data.

(x) The function MIN() is used to find the least among a group of values.

Q.2. State whether the following statements are True (T) or False (F).

(i) The LARGEST() function allows you to find the largest value in a range. True

(ii) You cannot modify a chart after it is created. False

(iii) <> is an arithmetic operator. False

(iv) A Chart is a pictorial representation of data. True

(v) Excel allows you print selected sheets in a workbook. True

(vi) Circular Reference and Mixed Reference is same. False

(vii) In a hierarchy of operation in a mathematical expression, the calculation in parenthesis is always evaluated first. True

(viii) Arguments in a function are separated by. (comma). True

(ix) A Line Chart displays the contribution of each value to a total. False

(x) Data Series is the actual charted values of the source data. True