Page 201 - IT 402 v2.0 class 10
P. 201
. ohit scored 5 out of in nglish out of in Maths. e wants to calculate the score in I he needs
to achieve 5 percent in aggregate. Suggest him the suitable option out of the following to do so.
S Sample aper
i. Macro ii. Solver
iii. oal Seek iv. Sub otal
. rish and ritika have done a survey of age wise literacy rates of their locality as a school pro ect which
they have created in a Spreadsheet. hey both want to work simultaneously to complete it on time. hich
option they should use to access the same Spreadsheet to speed up their work. S Sample aper
i. onsolidate orksheet ii. Shared orksheet
iii. ink orksheet iv. ock orksheet
. hen you open a new spreadsheet by default it has a sheet named ............................. which is managed using
tabs at the bottom of the spreadsheet. S Sample aper
i. Sheet ii. ntitled
iii. orksheet iv. New Sheet
. In a spreadsheet using to create a hyperlink to a web F or elnet click on the ............................. icon available
in yperlink dialog box. S Sample aper
i. browser ii. hyperlink
iii. Internet iv. mail news
. refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you want
formula to calculate. S Sample aper
i. Cell reference ii. Block
iii. Sheet eference iv. utofill
13. ............................. function takes data from a series of worksheets or workbooks and summaries it into a single
worksheet that you can update easily. S Sample aper
i ata ombination ii. ata Merging
iii. ata onsolidation iv. ata oncatenation
B. Fill in the Blanks:
. he data consolidation function takes data from a series of worksheets or workbook and summaries it into a
............................. .
2. ............................. option reverses the usual order of formula.
3. ............................. is a more descriptive form of oal Seek.
. y default every workbook contains sheets named ............................. .
5. ............................. in spreadsheet are easily recognisable as it is highlighted in light blue colour.
Section B
(Subjective Type Questions)
A. Answer the following questions:
. xplain the options available under what-if scenarios dialog box
. hich setting options do you need to check before creating a scenario xplain each of them in short.
. istinguish between the Formula ell and ariable cell.
4. Write steps to create scenarios.
5. rite steps to provide results using multiple operations
. rite the complete procedure to perform oalSeek in OO alc.
Advanced Features of Spreadsheet 199

