Homework answers / question archive / Project 9: Security Analysis SecureWorks, Inc

Project 9: Security Analysis SecureWorks, Inc

MS Excel

Share With

Project 9: Security Analysis SecureWorks, Inc., a small computer security contractor that provides computer security analysts. des* and software implementation for the U.S. government and commercial clients. SecureWorks corn fo; both private and U.S. government computer security contract work by submitting detailed bitis the work the company will perform if awarded the contracts. Because all of the work 'wolves compote, security, a highly sensitive area, almost all of SecureWorks tasks require access to classified matey, or company confidential documents. Consequently, all of the security engineers (simply known as -eng.. veers" within the company) have U.S. government clearances of either secret or top secret Some toe even higher clearances for the 2 percent of SecureWorks work that involves so-called black-box recur-, work. Most of the employees also hold clearances because they must handle classified documents. Leslie Marnalis is SecureWorks' human resources (HR) manager. She maintains all employe, records and Is responsible for semiannual review reports. payroll processing, personnel record'. recruiting data, employee training, and pension option information. At the heart of an HR system a, personnel records. Personnel record maintenance includes activities such as maintaining employee records, tracking cost center data, recording and maintaining pension information. and absence are;; sick leave record keeping. Although most of this information resides in sophisticated database sys-tems, Leslie maintains a basic employee worksheet for quick calculations and ad hoc report gen-eration. Because SecureWorks is a small company, Leslie can take advantage of Excel's excellent list management capabilities to satisfy many of her personnel information management needs. Leslie has asked you to assist with a number of functions (she has provided you with a copy of her trusted personnel data file, AYK9_Data.xlsx): 1. Copy the data worksheet to a new worksheet called Sort. Sort the employee 1,1 .„ , order by department, then by last name, then by first name. 2. Copy the data worksheet to a new worksheet called Autofilter. Using the Autofilter feat,: c-, a custom filter that will display employees whose birth date is greater than or equal to 1 1 and less than or equal to 12/31/1975. 3. Copy the data worksheet to a new worksheet called Subtotal. Using the subtotal feature. create a sum of the salary for each department. 4. Copy the data worksheet to a new worksheet called Formatting. Using the salary column. change the font color to red if the cell value Is greater than or equal to 55000. You must use the cond. tional formatting feature to complete this step. 
Data tile: AYK9_Data.xlsx.