Page 196 - IT 402 v2.0 class 10
P. 196
. he cell reference in a spreadsheet for cell range to F 5 is ............................. . S Sample aper
i. .F 5 ii. F 5
iii. :F 5 iv. -F 5
ns. . iv . iv . i . iii 5. iii . ii . iv . iv . iv . ii
11. ii 12. iii
B. Fill in the blanks.
. ou can use ............................. to modify existing scenarios.
2. Click on ............................. ............................. to open navigator window.
3. A ............................. feature provides a target-based result and informs the user about the changes in value in the
applied formula
4. A ............................. tool is used to create a formula array in OO alc.
5. A ............................. 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.
ns. . Navigator . iew Navigator . oalSeek
4. Multiple Operations 5. cell reference
C. State whether these statements are true or false.
. ou cannot combine more than one worksheet cell data into different sheets and use the formula.
. S O is a function listed under the Mathematical category when you use the Function i ard.
. he function option in consolidate dialog box allows to select the function in the destination cells.
. eference option allows you to select the reference from another sheet having data.
5. onsolidate means to combine a number of things into a single unit.
6. The format of OpenO ce alc is .oss .
Ans. . False . rue . rue . rue 5. rue . False
Section B
(Subjective Type Questions)
A. Answer the following questions:
. hat do you mean by ata onsolidation ist the steps to consolidate data.
ns. ata consolidation option enables a user to collect and integrate data from multiple worksheets or workbooks
into a single worksheet. Steps to consolidate data:
Open the worksheets that contain the data to be consolidated.
lick the ata menu. Select onsolidate from the sub-menu.
lick the Source ata ange dialog box. Select the source range from the worksheet to be consolidated and
then click the dd button.
Select additional ranges from different worksheets and click the dd button again for each selection.
Select the desired function Sum roduct etc. from the Function box according to the type of operation to be
performed on the data.
Select the target cell range in which all the data are re uired to be consolidated.
lick the O button. he data gets consolidated.
194 Touchpad Information Technology-X

