please provide the formulas used

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 T2.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 T2.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 Company ABC Truck Parts Tasty Juice, Inc. FastChips Memory Internet Celebration Bouncy Balls, Ltd XYZ Steel Ticker abct juce fchp webc bbbb xsti Purchase $ 25.00 $ $ 7.50 $ $ 67.00 $ $ 12.50 $ $ 18.00 $ $ 38.00 $ Last 27.50 7.50 39.50 75.00 19.50 47.00 Date 8/21/2016 8/21/2016 8/21/2016 8/21/2016 8/21/2016 8/21/2016 Gain/Loss (%) 10.0% 0.0% 41.0% 500.0% 8.3% 23.7%