1998- spreadsheet(Q17B)

posted Nov 1, 2014, 8:40 AM by Maurice Nyamoti
A spreadsheet has the following entries. Provide a formula for cell c5 that can be copied onto cell d5 and the range c6...d10 to give a uniform increase of 10% of the previous years value for each item.

  A B C D E F
 1PROJECTED BUDGET
     
 2PERCENT 10.00%
     
 3
     
 4Item
 1996 1997 1998  
 5Food
 56,000 =B5+B5*10% =C5+C5*10%  
 6Clothes
 24,000    
 7Fees
 50,000    
 8Transport
 20,000    
 9Entertainment
 15,000    
 10      

Comments