Page 197 - IT 402 v2.0 class 10
P. 197
. hat do you mean by hat-If nalysis
ns. hat-if analysis is a very useful feature in spreadsheets that helps to change cells values to see how those changes
will affect the worksheet s final outcome. One can use several different sets of values to explore all the different
results in one or more formulas. It helps to take decisions based on the data. hat-if analysis is useful in many
situations. For example one can predict the future values based on the given historical values
. hat is the use of “ ink to source data” option
ns. ink to source data is an option in a spreadsheet. hen it is selected the values that are modified in the source
range are automatically and accordingly updated in the target range.
. hat is the use of subtotal command
ns. he Subtotal command is used to automatically create groups and apply inbuilt functions like Sum ount
verage etc. to summarise data. For example suppose there is a worksheet containing the list of students of a
school and the students belongs to four different houses. Now if we want know how many students are there in
each house we can use the Subtotal command to easily know the number of students in each house.
5. ow many ways to refer cells in other sheets
Ans. There are two ways to refer to cells in other sheets.
y entering the formula directly using the keyboard.
By using the mouse.
. hat are the benefits of sharing document in alc
ns. Some of the benefits of sharing documents in alc are:
The document can be used by multiple users at the same time.
he editing or record entering process will be faster as different users can access and edit different areas of the
same document at the same time.
. hat is the default function in function box
ns. he default function in the function box is S M
. xplain Scenario
ns. Scenario is a tool to test what-if uestions. It is a set of probable values that can be substituted automatically
in the cells of a worksheet. One of the features of scenario is that you can create and save different groups of
values on a worksheet and then switch to any of these new scenarios to view different results. For example using
scenario one can create a comparison chart of marks obtained by students in certain sub ects and by changing
the marks in one or more sub ects one can obtain the new average marks. One can set targets and use this tool
to determine how much more a student needs to score in which particular sub ect in order to meet those targets.
. xplain Multiple Operation with the help of suitable example.
ns. Multiple Operations is a planning tool for what-if uestions but it is different from Scenario. multiple operation
combines a series of formulas with a variable and a series of values.
he result of each formula with each value is shown in the table. separate set of cells give the alternative results
for the formulas used. For example let s say ompany produces toys that you sell for s. each cell .
ach toy costs s. to make cell in addition to which you have fixed costs of per year cell . ow
much profit will you make in a year if you sell a particular number of toys
In the sheet from the previous example delete the contents of column .
nter the following formula in 5: 5 . ou are now calculating the annual profit per item sold. Select the
range :F thus three columns.
Choose Data Multiple Operations.
ith the cursor in the Formulas field of the Multiple Operations dialog select cells 5 through 5.
Advanced Features of Spreadsheet 195

