Question: Use criteria range to answer the question, and please include excel function: What is the maximum salary for employee over the age of 30 hired

Use criteria range to answer the question, and please include excel function: What is the maximum salary for employee over the age of 30 hired after 1/1/2000?
A B D E F G H Emp ID 1011 1012 1041 Start Date 2/3/00 1/26/06 4/16/02 Birth Date 11/21/64 12/2/84 1054 1055 1075 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 4/16/09 4/8/99 8/7/06 1/21/00 Art 9/21/65 8/9/87 8/20/67 8/28/79 10/23/71 11/3/63 9/28/70 1152 1153 1167 1168 1169 Last Name First Name Department Division Gorton Hazel Accounting Copier Preston Liza Engineering Printer Tercan Robert Rand D Printer Smith Howard Art Copier Albert Maxine Marketing Copier Kane Sheryl Printer Henders Mark Accounting Printer Plant Allen Accounting Printer Berwick Sam Marketing Copier Asonte Toni Engineering Fax Dorfberg Jeremy Engineering Copier Cooper Linda Admin. Fax Simpson Sandrac Engineering Copier Gokarna Phillip Accounting Printer Sindole Randy Marketing Fax Smith Ellen Engineering Fax Cane Nate Marketing Printer Vuanuo Tuome Engineering Printer Selznick Anna Accounting Copier Cash Mary Engineering Printer Szcznyck Tadeuz Engineering Copier Kaneko Midori R and D Fax Lampstone Pete Marketing Fax Bell Tom Accounting Printer Quan Karen Engineering Printer Kellerman Tommie Engineering Printer Salary $27,597.85 $43,394.15 $28,043.68 $25,176.06 $26,040.56 $23,239.44 $26,646.20 $28,043.68 $31,913.88 $63,035.88 $58,002.05 $26,113.86 $34,854.20 $30,451.68 $27,081.04 $32,410.85 $43,486.95 $55,410.85 $31,539.24 $49,872.15 $59,362.20 $28,043.68 $64,689.00 $28,549.50 $75,589.60 $45,146.68 1/13/09 4/18/01 4/10/99 10/13/98 1/3/05 12/21/05 12/13/93 8/6/08 1290 1299 1300 1301 1310 7/8/70 7/12/78 10/1/66 9/16/85 9/24/65 6/25/61 11/2/65 1311 1329 1330 1331 10/4/86 9/26/02 2/22/09 2/14/99 5/11/99 11/13/54 5/6/64 9/23/68 17 18 19 20 21 22 23 24 25 26 27 28 29 1333 1334 1426 1516 1517 1529 4/16/95 4/8/98 9/8/85 3/6/04 5/21/64 10/7/65 10/18/65 9/23/58 6/26/63 7/7/63 9/10/71 2/26/89 1/28/07Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
