Page 34 - Touchpad_Plus_V3.2_Class 7
P. 34

Across
                      3.  Symbols that specify calculations to be performed
                      5.  Function used to convert text string into upper case
                      8.  Numbers or text that do not change
                      9.  Function used to convert text string into lower case

                     10.  Function used to multiply values in cells
                                                          1              2
                                                                                 4
                                               3          E              O       S





                                       5                  R                      6



                                                  7
                                                      8   C                      N
                                           9      O




                                                                     10          O






                                                                                                   21 st   #Technology Literacy
                    Lab Session                                                                  Century
                                                                                                  Skills

                       Create a similar invoice in LibreOffice Calc and perform the following task:












                     •  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 Note
                    1.  Discuss different types of charts and their uses with the students.
                    2.  Do a detailed walk-through with the students on all the topics discussed in the chapter.


               32       Plus (Ver. 3.2)-VII
   29   30   31   32   33   34   35   36   37   38   39