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

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

(i) A ________ 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 ________ Cell Referencing.

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

(iv) __________ 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 _________ reference.

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

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

(viii) A ________ 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 _______ data.

(x) The function _________ 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.

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

(iii) <> is an arithmetic operator.

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

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

(vi) Circular Reference and Mixed Reference is same.

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

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

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

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