Page 51 - TP_Pluse_V2.2_Class_6
P. 51

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


                     teCh PraCtiCe                                                   21 st
                                                                                   Century   #Productivity & Accountability
                                                                                    Skills
                     Create a similar invoice in Excel.








                     teCh PraCtiCe





                            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.





                                                        For The Teacher


                       Do a walk-through of all the Excel topics in detail listed in the chapter on the computer screen.
                       Explain to the children the use of Excel at homes, shops, business, industries etc.

































                                                                               Formulas and Functions in Excel 2016  49
   46   47   48   49   50   51   52   53   54   55   56