Total amount of discount and Sales of the month (iii) Closing stock of each product . Draw a Pie chart to show the highest selling product. Chapter Workshop: . Create a worksheet in OpenOffice Calc.
. Enter the following details of loan sanctioned during the month of January of “Tamil Finance Corporation”. AC No Emp. No Name Amount of Loan Loan Sanction date Duration of Loan Rate of Interest Interest (Rs) Total Amount Due date Senthil 250000 days .
% Kumar 175000 days . % Ibrahim 550000 days . % Valli 375000 days % Charles 450000 days . % .
Create the formula to calculate (i) Interest, Total amount and due date. (ii) Grass total of amount of loan, interest and total amount. . Insert new rows between Kumar and Ibrahim and include the following details AC No Name Amount of Loan Loan Sanction date Duration of Loan Rate of Interest Interest (Rs) Total Amount Due date Pari 250000 days .
% % Arul 375000 days . % % Raman 350000 days . % % Givind 450000 days % % Zeenath 800000 days % % Chapter Wo Points to Remember: Spreadsheet is a very useful office automation tool for organization, analysis and storage of data in a tabular form. Daniel Bricklin and Bob Frankston developed the first spreadsheet software called “VisiCalc” in for Apple II.
OpenOffice Calc is popular open source spreadsheet application software presently maintained by Apache Foundation. A worksheet is a grid of cells with a programmable calculator attached to each cell. OpenOffice Calc version . .
contains a total of columns and , , rows. Intersection of every row and column makes a box which is called as “Cell”. Cell pointer is a rectangle element which can be moved around the worksheet. The cell in which the cell pointer is currently located is known as “Active cell”.