Read the scenario and use the provided information to complete the assignment. Scenario During the current tax year, William and Mary had various stock transactions that qualified as capital gains. The information for these transactions is given in the table below. Common Stock Date Acquired Cost Date Sold Sales Price Gain Loss Short-term/long-term Apple 4/1/2021 $30,000 5/17/2022 $22,000 Windows 9/18/2021 3,000 9/18/2022 10,000 Lenovo 2/20/2011 8,200 4/22/2022 6,000 Create an Excel spreadsheet and copy the information from the provided table above.