Write step by step formul to do the following work by Microsoft excel.

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. Form at for percent in the Gain/Loss (%) column Stock Watcher URE T2.20 ck Watcher Data Date GainLoss (%) 100% 00% 41 0% 5000% 83% 23.7% Company Tcker Purchase Last aba$2500 $ 27.50 821/2016 e750750 821/2016 FastChips Memory:82 00 39508212016 intenet Celebration webc 12.50S 75 008212016 S 1950821/2016 338 00 4700 8/212010 ABC Teuck Tasty Juice, Inc Parts Bouncy Bals, Ld0b18 00 XrZ Steel 2. Total Mischief Mischief, Inc., is a regional pet toy supplier that tracks its business sales in a spreadsheet. The 35 36 37 38 39 ghal 3rd h2.pdf CS-1610 She Ready MacBook Air