Page 283 - TP_IT_V1.0_C10_flipbpookl
P. 283

SECTION B (Subjective Type Questions)

                 A.  Short answer type questions.

                    1.  What is Data Consolidation? Why do we need Data consolidation?
                  Ans.  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 like sum(), max(), min(), average(), etc.

                    2.  What is the advantage of using cell reference?
                  Ans.  The main advantage of using cell reference is that it can be used in formulas and functions. This helps you update the result
                       of a function or a formula automatically if the value in a particular cell used in a formula changes.
                    3.  What is macros?
                  Ans.  The process of saving the sequence of commands or keystrokes by a specific name for the later use is called macros.
                    4.  How do you view the changes made using Record option?
                  Ans.  Click on Edit → Track Changes → Show option.
                    5.  What is the purpose of sharing a spreadsheet?
                  Ans.  Sharing a spreadsheet refers to the way of allowing multiple users to access and work together on the same document
                       simultaneously.
                    6.  What is What-if scenario?
                  Ans.  A What-if scenario  is  a collection  of  values  applicable  for calculations  in  a spreadsheet.  In  LibreOffice Calc, multiple
                       scenarios can create on a single sheet. Each scenario is assigned a name and a formatting style.
                    7.  Mention any four options present in the Create Scenario dialog box.
                  Ans.  Name of Scenario, Display border, Copy back, and Prevent changes.
                    8.  What is the use of Goal Seek feature?
                  Ans.  Goal Seek is a tool used to find the input value required to achieve a desired outcome in a formula. It allows you to set a
                       target value for a cell and then adjust the value of another cell until the target value is achieved.
                    9.  What are relative hyperlinks?
                  Ans.  Relative Hyperlink refers to reaching the linked document with respect to the current location. It will include the partial cell
                       address in hyperlink. If the start and target locations change relative to each other, then relative hyperlink will not work.
                   10.  List the names of the options present in the External Data dialog box while linking a worksheet with external data.
                  Ans.   ●  URL of External Data Source
                       ●  Available Tables/Ranges
                       ●  Update every


                 B.  Long answer type questions.
                    1.  Explain any three options present in the Create Scenario dialog box?
                  Ans.  Name of the Scenario: Has the default name as Sheet1_Scenario_1. Change it to a relevant name that clearly identifies a
                       scenario in the drop-down list and in the Navigator window.
                       Comment: It is optional and is the extra information required. When you select the scenarios then this information is
                       displayed in the Navigator.
                       Settings: It has several options where the settings can be changed as per the situations.
                    2.  What is the purpose of adding comments? Give steps to add comments.
                  Ans.  Comments increase the readability of the cells by giving the information about the changes made in a shared document.
                       To add comments in a spreadsheet, perform the following steps:
                       Step 1: Click on Insert → Comments from the Menu bar.
                              A comment box will be inserted on the top-right corner of the cell. It will have the name of the author or reviewer
                             and date and time of the comment being made. This type of comments is known as notes or suggestions in the
                             spreadsheet.
                       Step 2: Type the comment.
                       Step 3: Once done click anywhere on the document to activate it.

                                                                      Electronic Spreadsheet (Advanced) using LibreOffice Calc  281
   278   279   280   281   282   283   284   285   286   287   288