Page 50 - Plus V4 with Adobe class 6
P. 50

Q    Answer the following questions:
            A
                1.  Explain any two components of the chart.



                2.  What is cell reference?



                3.  What is the use of the SUM( ) function?



                4.  What are the Text functions? Write the names of any two Mathematical functions.





                5.  What is the use of the IF function? Explain with example.





                6.  What are the rules to enter a function?






               Scratch Your Brain.                                                       Century   #Critical Thinking
                                                                                           21 st
                                                                                          Skills  #Communication

                1. Solve the crossword using the clues.
                     Across:
                   3.   Symbols that specify                            1              2
                      calculations to be performed
                                                                                               4
                   5.   Function used to convert            3           E              O       S
                      text string into upper case

                   7.   Numbers or text that do not
                      change
                                                     5 U                R              Y       6
                   8.   Function used to convert
                      text string into lower case
                   9.   Function used to multiply                   7 C                        N
                      values in cells
                                                         8      O          R
                   Down:
                   1.   Cell address that is to be
                      used in a  calculation
                                                                                    9          O              T
                   2.   Function used to display
                      current date

                   4.   Function used to add values in cells

                   6.   Predefined formula in Excel



            48  Plus (Ver. 4.0)-VI
   45   46   47   48   49   50   51   52   53   54   55