Be sure to enter formulas in column F. All cells should be formatted and aligned as shown

(a) The stocks were purchased for the following amounts: Apple 105.99, Facebook 74.47, and

Alphabet / Google 579.18. Add a new column that lists the purchase price for each. Add a column that shows our total original investment in each stock and a column that indicates the amount of money we have gained (or lost) on each stock since we purchased it. Finally, add another column that indicates the percentage gain or loss from the purchase price. Your formulas should work whatever the values in the cells. Format the numbers in this column as percentages with two decimal places.

b) Add validation to the cells for the current prices per share so that a user must enter a positive number or be given an error message. Test the validation by trying to enter a negative current share price for Google.

(c) Spend some time formatting the worksheet so it looks nice. Include different colors or shades for different cells. Include different fonts of different sizes and styles.

(d) Conditionally format the cells that contain the amount of money gained or lost on each stock with different colors. Now conditionally format the cells that contain percentage gains or losses with appropriate icons. Test the conditional formats by entering various current prices.

Stock Portfolio- Excel File Home Insert Page L Formu Data Review View 9 Tell me Sign in 9 Share A1 D 1 2 Stock Portfolio 3 Stock Symbol Total Shares Price 5 6 Apple AAPL 500 $ 94.76 $ 47,380 7 Facebook 500 $ 117.79 $ FB 58,895 8 Alphabet/Google GOOG 100 $ 707.21 $ 70,721 10 Total 176,996 11 Sheetl Ready +100% Be sure to enter formulas in column F. All cells should be formatted and aligned as shown. (a) The stocks were purchased for the following amounts: Apple 105.99, Facebook 74.47, and Alphabet/ Google 579.18. Add a new column that lists the purchase price for each. Add a column that shows our total original investment in each stock and a column that indicates the amount of money we have gained (or lost) on each stock since we purchased it. Finally, add another column that indicates the percentage gain or loss from the purchase price. Your formulas should work whatever the values in the cells. Format the numbers in this column as percentages with two decimal places (b) Add validation to the cells for the current prices per share so that a user must enter a positive number or be given an error message. Test the validation by trying to enter a negative current share price for Google. (c) Spend some time formatting the worksheet so it looks nice. Include different colors or shades for different cells. Include different fonts of different sizes and styles (d) Conditionally format the cells that contain the amount of money gained or lost on each stock with different colors. Now conditionally format the cells that contain percentage gains or losses with appropriate icons. Test the conditional formats by entering various current prices