Page 494 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

3 Transform Data:

• Let’s add a new column that calculates a bonus based on the Principal Amount. Click on “Add Column” >
“Custom Column.”

• Name the new column: “Interest”
• Enter the formula: = [Principal Amount] * [No of Years] *0.12 (Assuming a 12% Interest)

479
CITS : IT & ITES - Computer Software Application - Exercise 76