Page 199 - IT 402 v2.0 class 10
P. 199
Type the desired name of the worksheet.
The sheet is renamed.
. rite the syntax to create a cell reference to other worksheet for individual cell and for ranges of cell
ns. Syntax to create reference to an Individual ell: Sheet name. ell address Syntax to create reference to a ange of
ells: Sheet name.First cell: ast cell
15. ............................. key is an accessibility function which is designed for people who have vision impairment or cognitive
disabilities. S Sample aper
Ans. Toggle key.
. efine the following: S Sample aper
a Subtotals
b Consolidating ata
ns. a Subtotal adds data arranged in an array that is a group of cells with labels for columns and or rows. It is
available in ata ab using the Subtotals dialog you can select arrays and then choose a statistical function
such as ount Min Max etc. to be applied on arrays. For e ciency one must choose up to three groups of
arrays to which to apply a function.
b onsolidate provides a graphical interface for copying data from one range of cells to another, then running
one of a do en functions on the data. During consolidation the contents of cells from several sheets can be
combined in one place.
I nte r - D is cip l inar y
B. Application based questions:
. onsider a worksheet in which a student wants to predict target marks he she can obtain after an exam. Suppose
in a sub ect say omputer the worksheet containing pass percentage cell maximum marks in the exam
say 5 in cell 5 target marks he she wants to achieve say 5 in cell actual marks he she obtained 5 in
cell B7).
i. he calculation formula of percentage in cell .
ii. In column enter a variety of alternative marks if obtained one below other for example 5 5 and .
iii. alculate the percentage of alternate marks obtained that get displayed in column .
ns: i. he calculation formula for percentage in cell . 5
ii. ust enter the values given in the mentioned cells.
iii. 5
2. alculating with several formulas simultaneously:
i. In the above sheet delete the contents of column . Insert a column after column for calculating less marks
obtained than target .
Advanced Features of Spreadsheet 197

