Page 289 - TP_IT_V1.0_C10_flipbpookl
P. 289

8.  Assertion (A): Two-input What-If analysis allows you to examine the effects of changes in two input variables on the
                       outcome of a formula or calculation.
                       Reasoning (R): You set up a grid of cells containing different combinations of values for the two input variables and
                       observe how changes in both variables simultaneously affect the result of the formula.
                    Statement Based Questions:
                    Two statements are given. Statement 1 and Statement 2. Examine the statements and answer the question according to the
                    instructions given below.
                       a.  Statement 1 is TRUE, Statement 2 is TRUE
                       b.  Statement 1 is FALSE, Statement 2 is False
                       c.  Statement 1 is TRUE, Statement 2 is False
                       d.  Statement 1 is FALSE, Statement 2 is TRUE
                    9.  Statement 1: Comments in spreadsheets are solely for decoration and have no practical purpose.
                       Statement 2: Comments can be used to explain specific formulas or data points for better understanding.


                                                 Previous Years' Questions


                    1.  While consolidating data, a cell range can be named using option.                           [2024]
                       a. Name range                                     b. Consolidate name
                       c. Define range                                   d. Define name
                    2.  Kawal and his friends are working on a Spreadsheet for entering data and updating records. They wish to keep a track of
                       changes. Which of the following options will help in knowing who made the changes and what changes were done in the
                       spreadsheet?                                                                                 [2024]
                       a. View changes                                   b. Record changes
                       c. Store changes                                  d. Track changes
                    3.               is a more elaborate form of Goal Seek.                                         [2024]
                       a. Database                                       b. Hyperlink
                       c. Report                                         d. Solver
                    4.  Macro functions can be written to behave as regular functions by writing a/an   .           [2024]
                       a. Void                                           b. Return
                       c. Add-In                                         d. Dim
                    5.               option of Calc helps in viewing the changes made to a worksheet using original and edited
                       worksheet.                                                                                   [2024]
                       a. Edit→Revise document                           b. Edit→Consolidate
                       c. Edit→Compare document                          d. Edit→Collaborate document
                    6.  In Calc, shared workbooks allow:                                                            [2024]
                       a. Merging cells                                  b. Conditional formatting
                       c. Inserting pictures/graphs                      d. Adding text
                    7.  What is the purpose of consolidating data in spreadsheets ? Discuss briefly.                [2024]
                    8.  What are the two parts of a cell reference while referencing data on other sheets ? Explain with an example.   [2024]
                    9.  Explain four types of hyperlinks that can be applied in spreadsheets.                       [2024]
                   10.  A statistical formula can be applied to a selected array of cells using   .                 [2023]
                       a. Consolidate                                    b. Goal seek
                       c. Subtotal                                       d. Autosum
                   11.  Which of the following term refers to a cell or range of cells that can be used in a formula?   [2023]
                       a. Cell Reference                                 b. Cell Formula
                       c. Formula Reference                              d. Linked Cells


                                                                      Electronic Spreadsheet (Advanced) using LibreOffice Calc  287
   284   285   286   287   288   289   290   291   292   293   294