View the step-by-step solution to:

Question

This question was created from Employee_Data (4) https://www.coursehero.com/file/16950796/Employee-Data-4/

16950796-397818.jpeg

How did this person filter the data from birthdate between the years 1960-1969? My professor said you must use custom sort, not just a basic one.

16950796-397818.jpeg

ID
First Name Last Name
Department
Title
Salary
Hire Date
Birth Date Gender Clearance
2956
Michael
Goldstein
Engineering
Engineer
$ 51,000.00
4/11/97
3/7/63
M
TS
2122
Yuan
Chang
Engineering
Engineer
$ 46,540.00
9/5/95
3/4/64
M
1119 Sharad
Manispour
Engineering
Manager
$ 54,500.00
10/13/90
2/4/69
2344 Nemesha
Mehta
Engineering
Engineer
$ 65,000.00
10/1/95
2/12/65
3015 Patti
Stonesifer
Engineering
Engineer
$ 64,300.00
7/6/98
3/10/66
2678 Koshi
Yamamoto
Engineering
Engineer
$ 49,600.00
11/16/95
1/24/63
2042 Hillary
Cushner
Management
Staff
$ 32,000.00
8/26/94
5/6/61
1355 Barbara
Grabowski
Management
Manager
$ 75, 700.00
10/13/92
4/10/65
1009 Kevin
Grundies
Marketing
CSR
$ 38,900.00
12/24/89
3/4/61
1016 Oscar
Gomez
Marketing
CSR
$ 43,500.00
2/16/90
4/29/67

Top Answer

In Excel under sort and filter one must... View the full answer

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question