Page 380 - Trackpad IT-402_Class-IX
P. 380

Save Trees                                 Swachh Bharat

         3.  Using tables in OpenOffice 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 worksheet:















             After creating the worksheet, 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 worksheet:














          380   Trackpad Information Technology-IX
   375   376   377   378   379   380   381   382   383   384   385