Importing and analyzing sales data- security enablers is a

Question

Importing and Analyzing Sales Data-

Part 1: Security Enablers is a national company that provides security systems for small businesses. They have asked you to use the company template and import sales for the last five years. Open the template Consider 7-2 Security Enablers Template. Save the template as a workbook named Consider 7-2 Security Enablers. Import the data from the Sales table in the Consider 7-2 Security Enablers Access database starting in cell A4. Convert the table to a range and format it appropriately. Import the data from the text file, Consider 7-2 Security Enablers Text, starting in cell A16. Replace all instances of NorthCentral with Central. If necessary, replicate the formula in cell F4 to the range F5:F23, and format the data appropriately. Update the totals in the range C24:F24.

Part 2: How did you update the totals? Did you consider using the Quick Analysis toolbar? Why or why not?

Attachment:- Assignment.rar

Answer 1

In order to answer the above statement regarding Importing and Analyzing the Sales Data, I need the complete solution all along with the proper concepts and formulas. This all I got from the above illustrated website. Thanks a lot. I also suggest my friends to take their assistance in any kind of academic work.