amount (pv) -300000 FV Type iii) Compute PMT in the cell B6 by the formula =PMT(B1/ ,B2,B3,B4,B5) Answer ` , . Illustration (RATE) Mr. Vivek took a loan of ` , , from State Bank of India, Chennai and number of installments is months. Calculate the rate assuming payments ` , per month using appropriate function.
Solution Procedure (i) Open a new spreadsheet in MS-Excel ii). Enter values in the cells as given below A B Number of instalments (nper) Periodic payment (pmt) Loan amount (pv) -200000 FV Type iii) Compute RATE in the cell B6 by the formula =RATE(B1,B2,B3,B4,B5)* Answer % Illustration (Column chart and Line chart) The total sales volume (Product wise) of TECH Ltd for the year - is given below: Product Sales ` Toothpaste 22000 Toothbrush 11000 Hair Oil Shampoo 13000 Toilet Soap Accountancy a) Present the data in a column chart b) Change the chart type to line chart. Procedure (a) Column chart (i) Enter the data given in the table in a new spreadsheet. (ii) Select the data range from A1 to B7.
(iii) Go to Insert menu and select Column Chart (3D) (iv) Right click column chart and select ‘Add Data Labels’ (v) Choose layout tab under Chart tools. (vi) Select Axis title and name them. 10000 15000 20000 25000 Toothpaste Toothbrush Hair Oil Shampoo Toilet Soap Bath Soap 22000 11000 13000