Excel Crash Course [PDF]

  • 0 0 0
  • Suka dengan makalah ini dan mengunduhnya? Anda bisa menerbitkan file PDF Anda sendiri secara online secara gratis dalam beberapa menit saja! Sign Up
File loading please wait...
Citation preview

Excel Functions & Formulas Exercise 1. Use a formula to input the current date: Cost Weighting Cost of goods sold 8 Research and developmen 5 Sales and marketing 5 General and administrativ 2 Depreciation 4 Interest 5 Taxes 2 2. Use a formula to calculate the total expenses: 3. Use a formula to calculate the average of all costs: 4. Use a formula to calculate the weighted average:



749,080.00 118,930.00 286,430.00 65,608.00 125,795.00 5,000.00 35,078.00



Excel Functions & Formulas Exercise Cost Cost of goods sold Research and development Sales and marketing General and administrative Depreciation Interest Taxes



Remarks:ex