Page 202 - IT 402 v2.0 class 10
P. 202
. rite the complete procedure to use solver in OO alc.
. hat is difference between relative and absolute hyperlink
. Mention any two operations that can be performed using Macros in a spreadsheet. S Sample aper
. hat do you mean by yperlinks in Spreadsheets ive the two different types of yperlinks that can be used in
Spreadsheets. S Sample aper
. nshita is preparing spreadsheet notes for her erm xam. elp her to write short note on the following:
S Sample aper
i. Scenarios ii. Goal Seek
iii. Solver iv. Subtotal
B. Application based questions:
. nter following data into worksheet and compute strike rate of batsman: Cr itical T h ink ing
uns Scored 80
alls Faced 77
Strike Rate 103.90
he formula for strike rate is: cell cell
Now find out the strike rate for following data and give them proper names and comments.
i. hen score is 55 and balls faced are .
ii. hen score is and balls faced are .
iii. hen score is 5 and balls faced are .
. Sunita is making a pro ect in spreadsheets. She wants to rename a spreadsheet as it will help her identify the
worksheet data easily. hich option should she use to solved her problem
Previous Years’ Questions
1. colored border with ............................. appears around a cell where changes are made in a shared worksheet.
a a dot in the upper left-hand corner b a dot in the lower left-hand corner
c a cross in the upper left-hand corner d a cross in the upper right-hand corner
ns. a
2. ............................. feature adds data arranged in a group of cells in alc with labels for columns and or rows.
a verage b Subtotal
c oal Seek d Solver
ns. b
3. A ............................. refers to a cell or range of cells on a worksheet whose data values can be used in a formula.
a sheet b cell
c cell reference d cell data
ns. c
4. ............................. feature of alc is used to test what-if uestions.
a Solver b oal Seek
c Scenario d Styles
ns. c
200 Touchpad Information Technology-X

