Page 203 - IT 402 v2.0 class 10
P. 203
5. istinguish between the following with respect to spreadsheets:
a elative and bsolute yperlink. b Internet and ocument yperlink.
ns. a Relative and Absolute Hyperlinks: n absolute link will stop working only if the target is moved. relative
link will stop working only if the start and target locations change relative to each other. For instance if you
have two spreadsheets in the same folder linked to each other and you move the entire folder to a new
location a relative hyperlink will not break.
b Internet and Document Hyperlinks: he hyperlink points to a web address normally starting with http: or
https: is known as internet hyperlink whereas the hyperlink points to a place in either the current worksheet
or another existing worksheet document hyperlink.
6. ............................. function takes data from a series of worksheets or workbooks and summaries it into a single
worksheet that you can update easily.
a Summation b ata onsolidation
c ata Format d ata hart
ns. b
. If you are continually working with the same range then you may give a name to the range using .............................
option under ata Menu.
a efine data b efine range
c efine reference d efine address
ns. b
. In alc using the Subtotals dialog you can select arrays and then choose a statistical function to apply to them.
For e ciency you can choose up to ............................. groups of array to which to apply a function.
a two b three
c four d five
ns. c
. Solve option under ools menu amounts to a more elaborate form of ............................. . he difference is that the
Solver deals with e uations with multiple ............................. .
a nknown variables oals Seek b ariables uation
c oal seek nknown variables d Subtotal oal seek
ns. c
. sually you run a formula to calculate a result based upon existing values. y contrast using you can discover
what values will produce the result that you want.
a Subtotal b Scenario
c Sort ists d oal Seek
ns. d
. ama and two of her friends are doing survey of gender wise employment rates of their locality as a school pro ect
using Spreadsheet. hey all want to work simultaneously to complete it on time. hat option they should use to
access the same Spreadsheet to speed up their work.
a onsolidate orksheet b Shared orksheet
c ink orksheet d ock orksheet
ns. b
. In alc you can use a cell reference in one or several formulas to refer to :
a ata from one or more contiguous cells on the worksheet
b ata contained in any software
c ata contained in any format in databases
d Images in picture gallery
ns. a
Advanced Features of Spreadsheet 201

