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

