Project - In a workbook for Eller Software Services, you calculate deviation statistics for sales by product and city. You verify phone numbers using a Text function, develop a worksheet with projected return on investment, and determine representative assignments.
Skills Covered in this Project
- Calculate the mean absolute deviation (MAD).
- Use the STDEV.S function.
- Nest MATCH and INDEX functions.
- Build SUMIFS formulas.
- Use functions from the Database category.
- Use EXACT to match data.
- Calculate the net present value of an expenditure.
- Create a nested IF and AND formula.
- Use Find and Replace with the Watch Window.
- Calculate the number of days between two dates.
Attachment:- Assignment Files.rar