Page 91 - PlusGPT_V2.1_C7_Flipbook
P. 91

d.  What are the rules to enter a function?

                         _______________________________________________________________________________________
                         _______________________________________________________________________________________

                    e.  What is the difference between formula and function? Give two examples.
                         _______________________________________________________________________________________

                         _______________________________________________________________________________________



                                                                                         fun Zone



                   Let's soLve
                     Application based question.                                                    Critical Thinking

                       Aman is organising an event and needs to set exact dates and times for activities. Which functions
                     should he use to find the current date and the current month?



                   Let's exPLore                                                                       Communication
                     Talk to the various departments in your school and find out how to use Excel. Discuss with
                     your class.



                        teCh PraCtiCe                                                              Life Skills & Values


                     Create a similar invoice in Excel 2016.
                     1.   Fill-up details of five items, their quantities
                          and unit prices.

                     2.  Using  PRODUCT function, calculate the
                          amount for each item.
                     3.  Using SUM function, calculate the total amount.

                     4.  Using formula, calculate the GST according to the given rate.
                     5.  Calculate Invoice amount payable.



                                                      For The Teacher


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











                                                                                           Formulas and Functions  89
   86   87   88   89   90   91   92   93   94   95   96