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