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
   275   276   277   278   279   280   281   282   283   284   285