Looking for an Excel expert. I am unable to post the attached excel file but am able to email it.

Create a new workbook, and save it as Pacific Sales.xlsx in the Chapter 7 folder.

2. Import the data contained in the Pacific Region table of the Pacific.accdb Access database located in the Chapter 7 folder into a worksheet named Pacific Region.

3. Sort the data first by state/province, then by city, and then by company name in ascending order.

4. Calculate the total sales since January 2015 for each company in a column labeled TotalSales. Format the result and all of the sales data from January 2015 through March 2016 as currency.

5. Hide the original columns containing financial information to simplify the worksheets appearance. 6. Assuming a report date of 4/1/2016 in cell AC1, calculate the number of days since each company has placed an order with TheZone in a column named DaysSinceLastOrder. Format the values as a Number with zero decimal places.