Page 39 - iPlus_Ver_2.0_class_8
P. 39

4.  Assertion (A): Sorting in Excel can only be done in ascending order.

                        Reason (R): Excel does not support sorting data in descending order.

                         (a)  Both Assertion (A) and Reason (R) are true and Reason (R) is a correct explanation of Assertion (A)

                         (b)  Both Assertion (A) and Reason (R) are true and Reason (R) is not a correct explanation of
                           Assertion(A)

                         (c) Assertion (A) is true and Reason (R) is false

                         (d) Assertion (A) is false and Reason (R) is true

                                                                                  #Problem Solving & Logical Reasoning
                          Crack The Code                                          #Digital Literacy


                     Solve the crossword using the clues.

                       Across:
                        3.  Symbols that specify calculations to           1             2
                          be performed                                                           4

                        5.  Function used to convert            3          E             O       S
                          text string into uppercase

                        8.  Numbers or text that do not change
                        9.  Function used to convert    5                  R
                          text string into lowercase
                      10.  Function used to multiply values in cells

                       Down:
                        1.  Cell address that is to be used in                                    6
                          a calculation
                        2.  Function used to display               7
                          current date                                  8  C                     N

                        4.  Function used to add            9      O       E
                          values in cells
                        6.  Predefined formula in Excel
                        7.  Chart type in which data is displayed                     10          O
                          in the form of vertical bars



                                                                                  #Problem Solving & Logical Reasoning
                    Let’s Explore                                                 #Digital Literacy


                           Find out the various ways in which people organise data to make their everyday work
                           easier. You can start this by asking a shopkeeper.







                                                                                                                  37
                                                                              Spreadsheet—Functions and Charts
   34   35   36   37   38   39   40   41   42   43   44