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

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/07

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!