posted May 6, 2010, 5:24 AM by Abdulkader Alriyashi
[
updated May 6, 2010, 9:01 AM
]
- You will be given an assignment to work on ( check the attached file)
- To get a full credit, you must do the following,
- Type in the given data to an excel sheet
- Maintain the same design as the given data ( Font size, column width, etc )
- Find the proper formulas or functions for the empty columns. Use the following guidelines,
- Initial cost
= Shares * Initial price per share
- Current
value = Shares * Current price per share
- Gain / Loss
= current value – initial cost
- Percent
gain/loss = (Gain or Loss ) / Initial cost
- Total =
Sum( , , .....)
- Average =
average (, , ,... )
- Highest =
Max(, , ,... )
- Lowest =
min(, , ,... )
|
 Updating... Ċ Abdulkader Alriyashi, May 6, 2010, 6:19 AM
|