Page 194 - IT 402 v2.0 class 10
P. 194
If another user is trying to save the shared document while other user is resolving conflicts a message that
the shared spreadsheet file is locked due to a merge in progress. hoose to ancel saving or etry saving
later.
hen a shared spreadsheet is successfully saved the document shows the latest version of all changes that
got saved by all users.
Recap Zone
ata consolidation refers to collecting and integrating data from multiple worksheets or workbooks
into a single/master worksheet.
he Subtotal command is used to automatically create groups and apply inbuilt functions like S M
O N etc. to summarise data.
hat-if nalysis is the most powerful feature in spreadsheet that helps to run reverse calculations
sensitivity analysis and scenarios comparison.
Scenario is a tool to test what-if uestions. Scenario is a set of values that spreadsheet saves and can
substitute automatically in cells on a worksheet.
ike scenarios Multiple Operations is also a planning tool for what-if uestions. nlike Scenario
Multiple Operations tool does not present the alternative versions in the same cells or with a drop-
down list.
oal Seek option reverses the usual order of a formula.
Solver is a more descriptive form of oal Seek. Solver can deal with e uations having multiple
unknown variables.
y default every workbook contains a sheet named Sheet which is managed using tabs at the
bottom of the spreadsheet.
hile doing calculations or summarising data in spreadsheet we often find ourselves in a situation
to fetch data from other worksheets or even from different workbooks. his can be done by creating
Cell Reference.
yperlink is a reference to a specific location document or webpage that the user can switch by
clicking on that link.
192 Touchpad Information Technology-X

