Page 33 - TP-Play_V-2.0_Book-6
P. 33

C.  Short answer type questions:
               1.  What is cell reference?
                  .....................................................................................................................................................................................................

               2.  What is the use of the CONCATENATE( ) function?
                  .....................................................................................................................................................................................................

               3.  What are date and time functions? Write the names of any two date and time functions.
                  .....................................................................................................................................................................................................

            D.  Long answer type questions:
               1.  What is the use of the LEN function? Explain with example.

               2.  What are the rules to enter a function?
               3.  What is the difference between formula and function? Give the examples.


                                                                                         21 st   #Critical Thinking
                                                                                       Century
            E.  Competency-based/Application-based question:                            Skills  #Experiential Learning
                 Divya has made a spreadsheet for the marks obtained by the students of her class in different subjects.
               Which feature should she use to keep the spreadsheet updated if she has to change marks in one of
               the subjects of any student?
               ..........................................................................................................................................................................................................



                                                                                       21 st   #Technology literacy
                                                                                     Century
                                                                                      Skills  #Productivity & Accountability
                                                   In the lab

               Create a similar invoice in Excel 2016.














                   Fill-up details of five items, their quantities and unit prices.
                   Using PRODUCT function, calculate the amount for each item.
                   Using SUM function, calculate the total amount.
                   Using formula, calculate the GST according to the given rate.
                   Calculate Invoice amount payable.




             Teacher's Corner

            1.  Explain different types of functions provided by Excel 2016 to the students.
            2.  Do a walk-through of all the topics covered in this chapter.



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