Page 286 - TP_IT_V1.0_C10_flipbpookl
P. 286

Assertion and Reasoning Questions:
                  Direction: Questions 3-4, consist of two statements – Assertion (A) and Reasoning (R). Answer these questions by selecting
                  the appropriate option given below:
                     a.  Both A and R are true and R is the correct explanation of A.
                     b.  Both A and R are true but R is not the correct explanation of A.
                     c.  A is true but R is false.
                     d.  A is false but R is true.
                 3.  Assertion (A): One-input What-If analysis allows you to examine how changes in a single input variable impact the outcome
                    of a formula.
                    Reasoning (R): Two-input What-If analysis extends this concept to explore the effects of changes in two input variables on
                    the outcome.
                 4.  Assertion (A): Linking the sheets is done to access data present in different sheets of the same spreadsheet or in different
                    spreadsheets.
                    Reasoning (R): Hyperlink is a feature that allows you to jump to a different location from within a spreadsheet.
                  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
                 5.  Statement 1: Storing a spreadsheet in a network location allows multiple users to edit it simultaneously.
                    Statement 2: Sharing a spreadsheet with others is not necessary for collaborative work.
                Ans.  3. a   4. c   5. c




                                                               Unsolved

                                                SECTION A (Objective Type Questions)


              A.  Choose the correct option.
                 1.  To              the comment, hover the mouse pointer over the cell that has the comment.
                    a. Edit                                            b. View
                    c. Hide                                            d. None
                 2.  You can save time by saving the repeated commands as      .
                    a. Scenario                                        b. Goal Seek
                    c. Macros                                          d. Subtotal
                 3.                tab in the Manage Changes dialog box is used to specify the filter criteria.
                    a. Tools                                           b. Data
                    c. Filter                                          d. Criteria
                 4.  In spreadsheet, to apply Goal Seek your cell pointer must be in   .
                    a. The Changing cell whose value you need to find   b. The Result Cell where formula is entered
                    c. The cell where your targeted value is entered   d. The active cell with no value
                 5.  Which of the following tools deals with multiple unknown values?
                    a. Goal Seek                                       b. Scenario
                    c. Solver                                          d. Subtotal
                 6.  Which of the following options is not present in the Hyperlink dialog box?
                    a. Internet                                        b. Mail & News
                    c. Document                                        d. Video


                284   Trackpad Information Technology (Ver. 1.0)-X
   281   282   283   284   285   286   287   288   289   290   291