Page 52 - Plus_V2.2_C6_Flipbook
P. 52

5.   Function used to convert text                     1              2
                           string into uppercase                                                      4
                                                                   3           E              O       S
                        7.   Numbers or text that do not
                           change
                        8.   Function used to convert text
                           string into lowercase           5                   R                       6

                        9.   Function used to multiply
                           values in cells
                                                                           7 C                         N
                                                               8       O





                                                                                            9          O
                      Let's exPLore


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




                      teCh PraCtiCe                                                                    Subject Enrichment

                      Create a similar invoice in Excel.















                             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.


                  50    Premium Edition-VI
   47   48   49   50   51   52   53   54   55   56   57