Page 280 - TP_IT_V1.0_C10_flipbpookl
P. 280
Answer the following questions:
1. After selecting the Merge Documents option which dialogue box opens up.
2. Why do we compare documents?
uiz Bee 3. List the benefits of commenting data in spreadsheet.
REVISIT
▶ Data analysis helps organisations in various tasks such as informed decision-making, problem-solving,
understanding customer behaviour, improving efficiency, performance evaluation, and risk management.
▶ Data consolidation refers to the process of combining data from multiple sheets of the spreadsheet into a
single sheet by using different built-in functions.
▶ Groups and Subtotals is a feature that allows users to organise and summarise data within spreadsheets.
▶ The Subtotal tool in Calc creates the group automatically and applies common functions like sum, average on
the grouped data.
▶ A What-if scenario is a collection of values applicable for calculations in a spreadsheet.
▶ One-input What-If analysis allows you to examine how changes in a single input variable impact the outcome
of a formula or calculation.
▶ Two-input What-If analysis extends this concept to explore the effects of changes in two input variables on the
outcome of a formula or calculation.
▶ Goal Seek is a tool used to find the input value required to achieve a desired outcome in a formula.
▶ Solver helps you find out the best possible combinations of the multiple variable values for the maximum or
minimum desired result.
▶ The process of saving the sequence of commands or keystrokes by a specific name for the later use is called
macros.
▶ Linking the sheets is done to access data present in the different sheets of the same spreadsheet or in
different spreadsheets.
▶ Hyperlink is a feature that allows you to jump to a different location from within a spreadsheet.
▶ Sharing a spreadsheet refers to the way of allowing multiple users to access and work together on the same
document simultaneously.
▶ Comments in spreadsheets serve the purpose of providing additional information, context, or explanations
about specific data or formulas within the spreadsheet.
278 Trackpad Information Technology (Ver. 1.0)-X

