Page 200 - IT 402 v2.0 class 10
P. 200
ii. nter the formula for less marks than target in calculating the difference of obtained marks and target
marks using difference probability
iii. olumn F will hold the marks above or below target.
iv. Calculate the percentage of alternate marks obtained that get displayed in column and column F will hold
the marks above or below the obtained marks.
ns. i. ight click the mouse on the column header of column . Select the elete olumn option. he contents
of column get deleted. ight click the column header of column . Select Insert olumn option. new
column gets inserted.
ii.
iii. o be filled according to user s choice.
iv. 5 F 5
Unsolved Exercise
Section A
(Objective Type Questions)
A. Multiple choice questions:
. hich of the following functions are available in consolidate window
i. Max ii. Min
iii. ount iv. ll of the above
. hich of the following are the different tools of hat-if nalysis
i. Scenario ii. Goal Seek
iii. Solver iv. ll of these
3. Scenarios are tool to test ............................. uestions. S Sample aper
i. Auto ii. Goal Seek
iii. hat-if iv. rop own
. yperlink in alc can be used
i. to ump from one sheet to another sheet.
ii. to ump from one sheet to website
iii. to ump from one section to another section of same sheet
iv. ll of the above
5. Hyperlink icon is present on ............................. .
i. Format oolbar ii. Standard oolbar
iii. Menu ar iv. None of these
6. ............................. is specifically designed to minimise or maximise the result according to a set of rules that you
define in a spreadsheet. S Sample aper
i. Goal Seek ii. Scenario
iii. Solver iv. Subtotal
7. ............................. is a tool to test “what-if” uestions. S Sample aper
i. Scenario ii. Solver
iii. Macro iv. verage
198 Touchpad Information Technology-X

