3. Filtering SecureIT DataSecureIT, Inc., is a small computer security contractor that provides computer securityanalysis, design, and software implementation for commercial clients. Almost all of SecureIT work requires access to classified material or confidential company documents. Consequently, all of the security personnel have clearances of either Secret or Top Secret. Some have even higher clearances for work that involves so-called black box securitywork. While most of the personnel information for SecureIT resides in database systems, abasic employee worksheet is maintained for quick calculations and ad hoc report generation. Because SecureIT is a small company, it can take advantage of Excel’s excellent list management facilities to satisfy many of its personnel information management needs. You have been provided with a sample worksheet, T3_Employee_Data.xls, to assist SecureIT with producing several worksheet summaries. Here is what is needed:One worksheet that totals the salaries by department and the grand total of all department salaries. This worksheet should be sorted by department name first. ID First Name Last Name2956 Michael4123 Steve3117 Frederich2122 YuanDepartmentEngineeringGoldsteinBallmerBednarczyk EngineeringEngineeringEngineeringEngineering2451 Francine2896 SamuelChangDetweilerGatesLeonardManispourMehta2768 Phyllis1119 Sharad2344 NemeshaRothrockStonesifer3210 Carmen2002 Edgar3015 Patti2678 Koshi2733 John3314 SvetlanaYamamoto EngineeringZumkowskiEngineeringKartashevRovik4006 Alice2042 HillaryCushner1851 MelindaEnglish1355 Barbara Grabowski1173 RobertaKurzweil1441 James1042 Maria1032 Hillary1009 Kevin1614 Artie2105 Luca1016 OscarEngineeringEngineeringEngineeringEngineeringOrtega-Molina EngineeringEngineeringEngineeringVan HornAndrettiFlintsteelGrundiesLambrosPacioliGomezManagementManagementManagementManagementManagementTitleEngineerEngineerEngineerEngineerEngineerEngineerEngineerMarketingMarketingMarketingMarketingMarketingMarketingManagerEngineerEngineerEngineerEngineerEngineerHuman ResourcesHuman Resources ManagerStaffStaffStaffManagerManagerManagerManagerCSRStaffCSRCSRStaffCSRSalaryHire Date51,00042,90056,7004/11/975/1/025/14/999/5/9510/10/951/28/9746,54056,70066,30059,800 12/13/9654,500 10/13/9065,00010/1/9546,00053,30064,30049,60033,00038,00042,30043,5009/16/992/8/947/6/98TSMMFBirth Date Gender Clearance3/7/63 M4/14/70 M5/27/703/4/644/29/704/10/74 M7/2/70 F2/4/69 M2/12/65 F3/28/523/21/703/10/661/24/63F11/16/954/18/96 12/12/7211/5/0143,00012/1/0132,0008/26/9462,04010/1/9375,700 10/13/9263,00066,50042,50034,50038,90041,0005/3/821/26/555/6/612/14/564/10/656/16/92 12/22/5812/18/923/21/903/21/9012/24/895/16/938/26/952/16/902/3/588/20/708/22/583/4/617/13/705/6/504/29/67FFMFMSASKSSKeses sisse PNSKROSSZZUNSNFFMFFMMMMMFFNTSTSSSSTSTSTS

Question

Accepted Answer

We first select all the elements of the spreadsheet to convert to table a follows:

While most of the personnel information for SecureIT resides in database systems, a basic employee worksheet is maintained for quick calculations and ad hoc report generation