.oshana Haddad is a financial analyst for Peak Partners, a full-service recruiting agency with headquarters in New York City and offices in five other U.S. cities. Roshana asks for our help in producing a revenue report. She wants to analyze revenue for the past year nd project future sales for all the offices. To create the report, you need to import data om various sources and use the Excel Power tools. io to the Revenue History worksheet, where Roshana wants to view how sales have hanged since the business was founded in the year 2000. She has a text file that Iready contains this data. Import the data from the Support EX19_EOM10- Mac Annual.csv text file. Remove the first four rows of data (Hint: set start import t row as 5), delimit the data by commas, and load the data to cell B3 of the existing worksheet. Format the imported data as a table with headers, and apply the Dark Green, Table Style Medium 3 table style to the new table to coordinate with the Peak artners logo. Autofit columns B:D to fit the contents. (Hint: If an alert comes up, press Yes" to convert the range to a table.) oshana asks you to create a chart that compares the revenue for each business year. Create a scatter chart of the Business Year and Annual Revenue data (range C3:D25). love and resize the chart so that its upper-left corner is in cell E3 and its lower-right orner is in cell K16. Add a Linear Forecast trendline to the chart, and then forecast the rendline forward 2 periods (if necessary). io to the Sheet4 worksheet, where Roshana has already imported monthly sales data to orecast it for the next year. Use 2022 Forecast as the name of the worksheet. Copy he formulas from the range C26:E26 to fill the range C27:E37. Create a line chart ased on the range A1 E37..Moxe.and.resize the line chart. so that the upper-left corner.... within cell C2 and the lower-right corner is within cell E25. Remove the chart title om the line chart, and set the number format of the vertical axis to Currency with 0 ecimal places and $ as the symbol, if necessary. io to the Positions Data worksheet. Roshana wants to display Information about Peak artners' clients, contracts, and positions. She has a text file that already contains this ata. Import the data from the Support EX19_EOM10-1_Mac Positions.csv text a delimiter and Import the date to call A1 Carmat the Imported