Stock Portfolio Spreadsheet Data & Formulas

Good morning and afternoon! Today you will be creating a spreadsheet which will be used to display information for a stock portfolio. The data is available in a table format as well as a sample of what the spreadsheet will look like on page EX89.

If you look closely you will see that the some of the text entered in row 3 appears different than the other rows. The text in row three is much longer than the data or numbers entered in the rows below. To get the text to appear on a new line in the same cell, press ALT + ENTER. This will automatically increase the height of the row to fit the multiple lines of text.

After you have entered all the data from the table, enter your name as the author and Silver Dollars Stock Club Portfolio Summary as the title in the document properties. Save your work as Silver Dollars Stock Club Portfolio Summary.

Formulas
The next step in developing the stock portfolio summary is to enter the formulas to calculate the following information:
Initial Cost
Current Value
Gain/Loss
Percent Gain/Loss

Using the column titles available in row 3 of your spreadsheet, describe how would you determine the Initial Cost, Current Value, Gain/Loss, and Percent Gain/Loss for a stock? After you have described how to determine the information provide the formulas that you would enter in cells F4, H4, I4, and J4. Please post your response as a new post on your blog.