tab is used to create header “Footer” tab is used to create footer Workshop . Create a worksheet with following data Emp. No Name of Emp. Basic DA HRA CCA MA GPF IT HF Manivannan M 25500 % of Basic % of Basic and DA % of Basic % of Gross Kannan K 20200 Gowrishankar N V 24300 Lenin K 23400 Suryanarayanan T 24100 Ramesh K 18500 Govindasami A 13200 Kannan S 20250 Penchil Rao K 28300 Logeswaran M 30200 Arumugam E 12000 Vasu G N 25000 Based on the above data, ( ) Calculate the Gross Salary, Total Deductions and Net Salary ( ) Insert “IT Cess” column and calcualte % of cess to all employees ( ) Delete the records of “Govindasami” and “Arumugam”.
( ) Insert four new rows and enter the following employee details. ( ) Calculate the Total amount of GPF, IT and Cess Emp. No Name of Emp. Basic DA HRA CCA MA GPF IT HF Murali G 24750 Munirathnam A 23550 Ramakrishnan V G 25500 Srinivasan R 27500 Workshop: .
Create a new worksheet in OpenOffice Calc. . Enter the following stock and sales details of “Chennai whole sale Marketing Pvt. Ltd.” during the month of Jan- .
Code Product Name Weight (gm) Opening stock Cost price Sales in units Rate of Discount Amount of Discount Selling price Amount of Sale Closing Stock Marie Gold % Milk Bikis % Dark Fantasy % Nutri Choice % Lays potato chips % Oreo % . Calculate the following using formula or function (i) Amount of Discount, Selling price and Amount of sales for each product (ii)