{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

q2 - Carmen Ortega-Molina S Frederich Bednarczyk S Patti...

Info icon This preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
2 PROBLEM: Find which employees were hired in 1996 through 1999, and have security clearance of TS (Top Secret) or S (Secret). You must use the most efficient Excel tool or command to do this, which will also display only the affected rows. Name the worksheet Problem #2 . b) Describe your finding in the Word document saying which tool you used, followed by a table having the layout shown below containing the result from the worksheet. First Name Last Name Hire Date Clearance
Image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Carmen Ortega-Molina 9/16/99 S Frederich Bednarczyk 5/14/99 S Patti Stonesifer 7/6/98 S Michael Goldstein 4/11/97 TS Samuel Gates 1/28/97 S Phyllis Leonard 12/13/96 TS John Zumkowski 4/18/96 TS ANSWER: The table to my left shows employees hired between 1996 and 1999 with special clearance of S or TS . We used the sort and filter function in Microsoft word to help us sort through the list once and filter out unwanted data as shown in the picture below....
View Full Document

{[ snackBarMessage ]}