Copy and paste each filtered report into a new worksheet. Each filtered report should be named by the person requesting the information. You will have to save the filter and place it into a new worksheet. Leave the initial worksheet the same. Make sure th
Question Description
Scenario Prompt:
Your manager was happy with how you organized the workbooks. However, there was a complaint that the information still wasnt clear for the Sales department. Below is a list of filtered reports they need. Copy and paste each filtered report into a new worksheet. Each filtered report should be named by the person requesting the information. You will have to save the filter and place it into a new worksheet. Leave the initial worksheet the same. Make sure that the initial worksheet is completely unfiltered while conducting your final save. Save file as an Excel 2013 workbook.
Filter Report Requests:
- Sara needs the Asian Market Hedge Fund Information.
- Stewart needs the Emerging Market information for Asia, Africa, and the Middle East.
- Keira needs the Event Driving Investments for North America.
- Lana wants the December reports for Convertible Arbitrage and Distressed Securities.
- Peter needs the low risk hedge funds for the month of September that are under $2 Billion.
- Overlton needs the names of the account managers who have accounts over $5 Billion in Asia and Europe.
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."