and percentage of marks obtained by them. If a student has secured a minimum of %, he is declared pass, else fail. Student Percentage of marks Solution Procedure . Open new excel sheet.
. Input the table as given in the question. . Enter the data “Result” in Cell A3.
. Type the following in Cell B3 B3=IF(B1>= ,”Pass”,”Fail”) . Copy the formula from B3 to C3, D3 and E3 Output Student % of marks Result Pass Pass Pass Fail Fail Accountancy Illustration (Depreciation – SLN method) Calculate depreciation under Straight Line Method using Spreadsheet based on the details given below. A B C D E F Asset Cost of purchase ` Installation charge ` Transportation charge ` Salvage value Life in years .
Machinery 200000 20000 25000 . Furniture 50000 Solution Procedure and answer (i) Open a new spreadsheet in MS-EXCEL (ii) Enter labels and values in the cells as given above (iii) Write total cost in G1 and annual depreciation in H1 (iv) Calculate total cost in the cell G2 by the formula =Sum(B2:D2) and copy formula to cell G3 (v) Calculate annual depreciation in the cell H2 by the formula =SLN(G2,E2,F2) and copy formula to cell H3 Output A B C D E F G H Asset Cost of purchase Installation charge ` Transportation charge ` Salvage value ` Life in years Total cost ` Annual depreciation Machinery 200000 20000 25000 225000 , Furniture 50000 56000 , Illustration (PMT) Consider the following information: Loan amount ` , , Number of payment periods months Annual rate of interest % Calculate periodic payment using PMT function. Solution Procedure i) Open a new spreadsheet in MS-Excel ii) Enter values in the cells as given below Accountancy A B Rate of interest (p.a.) % Number of instalments (nper) Loan