Page 33 - Chinmaya_C6_flipbook
P. 33

c.  __________ is used in a formula to denote a specific cell.
                    d.  A __________ is a predefined formula in Excel.

                    e.  The __________ function is used to get the length of the string.

                 3.  Think and answer.
                    a.  What are formulas in Excel?

                     ______________________________________________________________________________________
                    b.  What is operator precedence?

                     ______________________________________________________________________________________

                    c.  What is the use of the CONCATENATE() function? Explain with an example.
                     ______________________________________________________________________________________

                     ______________________________________________________________________________________
                    d.  What is cell range? How can you select a cell range by using the mouse?

                     ______________________________________________________________________________________

                     ______________________________________________________________________________________
                    e.  Explain the meaning of #NAME?, #REF! and #NUM! errors in Excel. Also, write a tip to resolve them.

                     ______________________________________________________________________________________
                     ______________________________________________________________________________________

                     ______________________________________________________________________________________

                 4.  Define the following functions:

                    a.  MAX()   ______________________________________________________________________________
                    b.  TODAY() ______________________________________________________________________________

                    c.  LEN()   ______________________________________________________________________________

                 5.  Differentiate between the following:
                    Relative Cell Referencing                                   Absolute Cell Referencing
                    __________________________________                      __________________________________

                    __________________________________                      __________________________________

                 6.  Application based questions:                                                   Experiential Learning
                    a.   Alisha was using Excel and encountered an error that displayed ‘#Div/0!’. She doesn’t know
                      about this error. Tell her the meaning of this error and also give a tip to resolve this.

                     _____________________________________________________________________________________
                    b.   Siya has made a spreadsheet of the marks obtained in different subjects by the students in her class.
                      She has made some changes to the marks of some students. Now she wants that the total number
                      of marks of those students be automatically updated. Which function should she use to do so?
                     _____________________________________________________________________________________




                                                                                 Formulas and Functions in Excel 2016  31
   28   29   30   31   32   33   34   35   36   37   38