Page 282 - TP_IT_V1.0_C10_flipbpookl
P. 282

13.  Which of the following is not an example of cell referencing?
                    a. A1:B6                                           b. G6
                    c. C10:C20                                         d. 7Q
                14.  Which of the following is not present in the Insert Sheet dialog box?
                    a. Before current sheet                            b. After current sheet
                    c. New Sheet                                       d. Create
                15.  Which of the following options is used to share a worksheet?
                    a. Share Document                                  b. Share Worksheet
                    c. Share                                           d. None of these
                Ans.  1. c   2. d   3. b   4. b   5. b   6. d   7. c   8. d   9. c   10. b   11. a   12. b   13. d   14. d   15. a

              B.  Fill in the blanks.

                 1.                and               are some of the important data analysis tools available in LibreOffice spreadsheet.
                 2.  Groupwise calculation of sum, average, max, min, count etc. can be done by using the    option of LibreOffice
                    Calc.
                 3.                are what-if analysis tools of LibreOffice Calc that helps you set multiple values for the same cell.
                 4.                tool helps you do backward calculation of the input to obtain the desired output.

                 5.                is a feature that allows you to jump to a different location from within a spreadsheet.
                 6.  Comments option is present under the          menu.
                 7.                refers to the process of combining data from multiple sheets of the spreadsheet into a single sheet.
                 8.  A               saves you from the tedious repetitive tasks.

                 9.  The Run Macro option under the           menu is used to run a macro.
                10.  The values written within the circular brackets of the function are called    .

                Ans.  1. Data consolidation and Goal Seek   2. Subtotal   3. Scenarios     4. Goal Seek     5. hyperlink
                     6. Insert                7. Data consolidation      8. Macro          9. Tools
                     10. Arguments

              C.   State whether these statements are true or false.

                 1.  Renaming a sheet can also be done using Tools Menu.
                 2.  Relative hyperlink contains a full URL.

                 3.  Filter feature is used to extract data using some conditions on columns.
                 4.  A What-if scenario is a collection of values applicable for calculations in a spreadsheet.
                 5.  Link to source data is checked updates the target sheet if any changes made in the source data.
                 6.  A Macro helps you save time as the long and time consuming tasks are saved as macros and can be
                    executed with a click of a button.

                 7.  What-if analysis tool uses only one array of cells.
                 8.  Compare Document option is used to merge two worksheets.
                 9.  Data found in the edited version but not in the original is marked as inserted.

                10.  The Range option allows to show the changes made in the specified range of cells.
                Ans.  1. False  2. False  3. True  4. True  5. True  6. True  7. False  8. False  9. True  10. True






                280   Trackpad Information Technology (Ver. 1.0)-X
   277   278   279   280   281   282   283   284   285   286   287