Page 32 - Trackpad_V5_Book 6
P. 32

2.  Fill in the blanks using the words from the help box.

                                      cell reference, LEN, function, Label, equal to



               a.  We cannot do mathematical calculations on __________.
               b.  A formula must always begin with an/a __________ sign.
               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 the use of the CONCATENATE() function? Explain with an example.

                ______________________________________________________________________________________
                ______________________________________________________________________________________

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

                ______________________________________________________________________________________
               d.  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()   _____________________________________________________________________________

                                                                                           21 st   #Technology Literacy
            5.  Competency-based/Application-based questions:                            Century   #Experiential Learning
                                                                                           Skills
               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?
               ______________________________________________________________________________________





             30   Pro (Ver. 5.0)-VI
   27   28   29   30   31   32   33   34   35   36   37