Write steps to calculate the Simple Interest using what if Table for the following interest rates (Column input) and terms (Row input) (Excel-2007)
Write steps to calculate the Simple Interest using what if Table for the following interest rates (Column input) and terms (Row input)
Interest rates : 9%, 9.25%, 9.50%, 9.75%, 10%
Term (in days) : 360, 420, 480, 540
To prepare two way table ,
Enter the formula= B3*B1*B2/365 in cell B4.
=B4 in cell D2.
ENTER VALUES 9%,9.25%,9.5%,9.75%,10% in cells D3:D7
ENTER VALUES 360,420,480,540 in cells E2:H2
Select the range of cells D2:H7
Click on DATA TAB, In DATA TAB click on ‘WHAT IF analysis’ From DATA TOOLS group.
From the menu select DATA TABLE, Data table dialog box appears,
Enter $B$2 and row input cell.
Enter $B$1 as column input cell
And click on OK. Now the table is prepared.
0 comments:
Post a Comment