Get fast, custom help from our academic experts, any time of day.
Place your order now for a similar assignment and have exceptional work written by our team of experts.
Secure Original On Schedule
. Filtering SecureIT Data
SecureIT, Inc., is a small computer security contractor that provides computer security analy-
sis, design, and software implementation for commercial clients. Almost all of SecureIT’s work
requires access to classified material or confidential company documents.Copyright 2022 © McGraw Hill LLC. All rights reserved. No reproduction or distribution without the prior written consent of McGraw Hill LLC.
T3-16 * Plug-In T3
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 security work.
Although 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. Because
SecureIT is a small company, it can take advantage of Excel’s excellent list management capabili-
ties to satisfy many of its personnel information management needs. You have been provided with
a sample worksheet, T3 Employee Data File.xlsx, to assist SecureIT with producing several
work-sheet summaries. Here is what is needed:
a. One worksheet that is sorted by last name and hire date.
b. One worksheet that uses a custom sort by department in this order: Marketing, Human
Resources, Management, and Engineering.
c. One worksheet that uses a filter to display only those employees in the Engineering depart-
ment with a clearance of Top Secret (TS).
d. One worksheet that uses a custom filter to display only those employees born between 1960
and 1969 (inclusive).
e. 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.
3. Answer Questions a, b, c, d, and e.
4. Save all questions’ solutions (5 worksheets) to one workbook in the following file name format.
your FirstName_LastName_TP2.xlsx
5. Upload your file (0 points for a non-excel ) via attachment by clicking on the text box below and selecting the paper clip symbol.
Grade
100 points
Grading Criteria
Submissions will be graded according to the following criteria:
follow the instructions above;
follow the syllabus netiquette policy.
Get fast, custom help from our academic experts, any time of day.
Secure Original On Schedule