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

