Page 386 - TP_IT_V1.0_C9_flipbpookl
P. 386

Save Trees                                 Swachh Bharat

               3.  Using tables in LibreOffice Document, Create:

                   Shopping list: Item name, Quantity purchased, Price per item
                   List of friends: Name, Address, Phone number

                   Books in my library: Book Name, Author name, Price, Publisher name

              Electronic Spreadsheet:                                                    Century   #Computational Thinking
                                                                                            21 st
                                                                                           Skills  #Experiential Learning
               1.  Create the following sheet:















                   After creating the sheet, perform the following actions:
                   Calculate the total billing amount.
                  Calculate the amount paid for the T-shirts.

                   Calculate the minimum quantity purchased.
                   Calculate the price of the most expensive item.

                   Give a discount of 15% if the billing amount is more than Rs. 15,000; otherwise, a discount of 5% is to be
                    given.

               2.  Create a given sheet:














                384   Trackpad Information Technology (Ver. 1.0)-IX
   381   382   383   384   385   386   387   388   389   390   391