PLEASE HELP ME WITH 3A. USE THE SUBTOTAL COMMAND TO SHOW THE MAX SALARY IN EACH DEPARTMENT. AND SHOW WORK THANK YOU!

Gender M F M F F M F M F M Employee No. First Name 69 Karl 83 Elaine 104 Adam 135 Cynthia 141Janice 157 | Michael 167 Angela 241 Stephen 253 | Maryann 254 Eduardo 281 Eugene 346 Rebecca 392 Charles 433|Leonard 481 William 556 Mary Ellen 561 James 593 David 640 Robert 694 Jackson 700 Kimberly 715 Victoria 800 Stuart 804 George 810 Linda 822 Amanda 833|Deborah 833 Elisabeth 850 Sarah 882 Richard 912 Joyce 961 Sherry Last Name Reese Savage Rosenburg Edwards Kaplan Bryant Dickinson Smith Morse Gonzales Poole Simpson Williamson Byrd Cobbler King Parcel Grogan Bjorkman Edwards Leamer Moran Templeton Tailan Robertson Fletcher Bosley Martin Michaelson Zuckerberg Adams Cymott IF IM M M F Department information Services Engineering Accounting Accounting Engineering Administration Engineering Administration Engineering Administration Engineering Human Resources Administration Human Resources Human Resources Accounting Engineering Information Services Engineering Engineering Human Resources Engineering Engineering Human Resources Engineering Human Resources Administration Information Services Information Services Engineering Accounting Accounting Salary Location Date Hired $25,800 Atlanta 9/13/1988 $38,900 Atlanta 5/27/1999 $29,000 Detroit 3/1/2001 $21,500 San Francisc 8/15/1985 $34,000 Boston 6/22/1991 $30.440 Santa Rosa 2/1/1991 $23,900 Detroit 11/13/1996 $100,000 Seattle 10/11/2000 $29,600 Chicago 11/2/1997 $86,200 Chicago 7/13/1999 $75,000 Chicago 9/15/2000 $50,200 Boston 2/4/1996 $87,800 San Francisco 7/9/1998 $21,100 Boston 8/13/1997 $27,500 Boston 5/28/2001 $38,000 Detroit 3/10/1997 $29,200 Atlanta 12/18/1997 $47,500 Seattle 4/3/1998 $25,000 Chicago 2/24/1998 $32,200 Atlanta 2/14/1997 $34,900 Chicago 6/28/1999 $40,700 Seattle 12/20/1990 $62,000 Seattle 12/29/2000 $29,700 Chicago 5/20/1999 $37,000 Detroit 11/11/1998 $26.500 Boston 1/3/1999 $20,800 Detroit 8/23/2001 $27,200 Atlanta 7/17/1996 $57,500 Santa Rosa 3/23/2002 $37,500 San Francisco 12/28/2000 $34,400 Boston 10/21/1987 $24,100 Boston 3/19/1994 Years of Service 25 15 13 29 23 23 17 13 16 15 13 18 16 17 13 17 16 16 16 17 15 17 13 15 15 15 12 18 12 13 26 20 M M M M F IF M M IF F F F F M F F Yes L . Formula Bar 1. Copy the content of DataSource sheet into this sheet 2. Sort the range A2:133 by Dept in A to Z order. 9 13 Now, either: 3a. Use the Subtotal command to show the Max Salary in each Dept, hiding all other details. Or, 3b. Add a new row after the rows for each department. Then in column F of each of the new rows, use an appropriate subtotal function (number) to show the Max Salary in the Dept. 4. Display this sheet in Show Formulas view. 16 15 13 18 16 17 13 17 16 16 16 17 15 17 13 16 10 10 0 20 100% Gender M F M F F M F M F M Employee No. First Name 69 Karl 83 Elaine 104 Adam 135 Cynthia 141Janice 157 | Michael 167 Angela 241 Stephen 253 | Maryann 254 Eduardo 281 Eugene 346 Rebecca 392 Charles 433|Leonard 481 William 556 Mary Ellen 561 James 593 David 640 Robert 694 Jackson 700 Kimberly 715 Victoria 800 Stuart 804 George 810 Linda 822 Amanda 833|Deborah 833 Elisabeth 850 Sarah 882 Richard 912 Joyce 961 Sherry Last Name Reese Savage Rosenburg Edwards Kaplan Bryant Dickinson Smith Morse Gonzales Poole Simpson Williamson Byrd Cobbler King Parcel Grogan Bjorkman Edwards Leamer Moran Templeton Tailan Robertson Fletcher Bosley Martin Michaelson Zuckerberg Adams Cymott IF IM M M F Department information Services Engineering Accounting Accounting Engineering Administration Engineering Administration Engineering Administration Engineering Human Resources Administration Human Resources Human Resources Accounting Engineering Information Services Engineering Engineering Human Resources Engineering Engineering Human Resources Engineering Human Resources Administration Information Services Information Services Engineering Accounting Accounting Salary Location Date Hired $25,800 Atlanta 9/13/1988 $38,900 Atlanta 5/27/1999 $29,000 Detroit 3/1/2001 $21,500 San Francisc 8/15/1985 $34,000 Boston 6/22/1991 $30.440 Santa Rosa 2/1/1991 $23,900 Detroit 11/13/1996 $100,000 Seattle 10/11/2000 $29,600 Chicago 11/2/1997 $86,200 Chicago 7/13/1999 $75,000 Chicago 9/15/2000 $50,200 Boston 2/4/1996 $87,800 San Francisco 7/9/1998 $21,100 Boston 8/13/1997 $27,500 Boston 5/28/2001 $38,000 Detroit 3/10/1997 $29,200 Atlanta 12/18/1997 $47,500 Seattle 4/3/1998 $25,000 Chicago 2/24/1998 $32,200 Atlanta 2/14/1997 $34,900 Chicago 6/28/1999 $40,700 Seattle 12/20/1990 $62,000 Seattle 12/29/2000 $29,700 Chicago 5/20/1999 $37,000 Detroit 11/11/1998 $26.500 Boston 1/3/1999 $20,800 Detroit 8/23/2001 $27,200 Atlanta 7/17/1996 $57,500 Santa Rosa 3/23/2002 $37,500 San Francisco 12/28/2000 $34,400 Boston 10/21/1987 $24,100 Boston 3/19/1994 Years of Service 25 15 13 29 23 23 17 13 16 15 13 18 16 17 13 17 16 16 16 17 15 17 13 15 15 15 12 18 12 13 26 20 M M M M F IF M M IF F F F F M F F Yes L . Formula Bar 1. Copy the content of DataSource sheet into this sheet 2. Sort the range A2:133 by Dept in A to Z order. 9 13 Now, either: 3a. Use the Subtotal command to show the Max Salary in each Dept, hiding all other details. Or, 3b. Add a new row after the rows for each department. Then in column F of each of the new rows, use an appropriate subtotal function (number) to show the Max Salary in the Dept. 4. Display this sheet in Show Formulas view. 16 15 13 18 16 17 13 17 16 16 16 17 15 17 13 16 10 10 0 20 100%