1. Stock Watcher Mark Martin has created a basic stock watcher worksheet that he uses to report on gains or losses from when he purchased the stock and the last recorded date and price. Mark has given you a snapshot of his spreadsheet (see Figure 12.20) that you can use to recreate this spreadsheet for yourself. Here are some basic steps to follow: 1. Create a new workbook. 2 Enter all the information provided in Figure 12.20. 3. Apply the Currency format to the respective columns. 4. The date should be entered as a function. Hint: Use the NOW function. 5. Enter a formula for the Gain/Loss (%) column. Hint: You should subtract the Last column from the Purchase column, and then divide by the Purchase column. 6. Format for percent in the Gain/Loss (%) column Stock Watcher FIGURE 12.20 Stock Watcher Data Company ABC Truck Parts Tasty Juice, Inc. FastChips Memory Internet Celebration Bouncy Balls, Ltd XYZ Steel Ticker abct juce fchp webc bbbb xsti Purchase Last $ 25.00 $ 2750 $ 7.50 $ 7.50 s 67.00 $ 39.50 S 12.50 $ 75,00 $ 18.00 $ 19.50 S 38.00 S 4700 Date Gain/Loss (%) 8/21/2016 10 0 8/21/2016 0.0% 8/21/2016 41.0% 8/21/2018 500.0% 8/21/2016 83% 8/21/2016 237%