Which combines (make and model) have less than 500 engine hours and less than 400 separator hours?

Which combines (make and model) were sold in Nebraska (NE)? What is the average price of combines that have an excellent condition rating?

I need the excel functions for both of these problems

AutoSave OFF OFF HEU JD Combine Sales Data Home Insert Draw Page Layout Formulas Data Review View Tell me Close Your Protection has Expired! watchtvnow.org Click here to renew now X Calibrl (Body) v 11 ~ Al A 2 Wrap Text General More v Dhe Paste BIU Av = = = Y Merge & Center Conditional Format Cell Formatting es Table Styles Y Sort & Filter Sensitivity Format v Find & Select Analyze Data N2 fy E F G I K M N O R S V W X Y Z Less than 500 engine Average Average sale hours and Enneine price with 400 Fours less than soo seperator 2001 hours hours 340.25 5160,933.81 Conc . Dete Hours Make in JD JD ID In JD E E F E 5 7 JD in E G Model 9650 STS 9750 STS 9650 STS 9650 STS 9650 STS 9650 STS 9650 STS 9653 9650 9652 9653 9650 STS 9550 9650 STS 9650 9750 STS G G G Year 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2001 2001 2000 2000 2000 2000 2001 2000 Auctior Price location $167,916 07/09/01 IA $185,546 02/23/01 MN $ 193,361 02/27/01 IA $165,281 03/03/01 PA $171,240 03/02/01 PA $179,685 03/03/01 PA $169,549 03/11/01 ND $153,950 04/26/01 ND $137,977 05/19/01 IA $ 158,812 05/27/01 NO $ 158,812 05/27/01 NO $154,400 06/27/01 ND $131,729 08/09/01 MN $ 179,298 08/09/01 MN $141,744 09/24/01 NE $207,502 08/24/01 NE $150,012 09/14/01 MN $139,512 12/01/01 IA $161,868 12/01/01 NO $176,205 12/10/01 NE $124,077 12/20/01 NE $139,547 12:20/01 NE $143,284 01/21/02 NE $124,039 02/07/02 $145,561 03/01/02 MO $ 155,754 03/01/02 NE Separator Engine werage Sale JD 9650'S Hrs Price 2002 Sold 213 544 5145,292.83 351 412 326 360 131 456 415 439 441 470 193 552 221 331 429 449 582 590 623 620 640 675 256 285 213 231 391 402 237 301 65 69 131 151 198 220 270 375 890 902 898 1000 411 471 240 245 176 492 727 745 G G JD 10 JD 11 D 12 JD 13 JD 14 in 15 JD 16 JD 17 JD 12 JD 19 JD 20 D 21 JD 22 JD 23 ID 24 JD 25 JD 26 ID 27 JD 22 29 30 31 32 33 34 35 36 37 9650 E E E 9550 9650 9750 STS 9650 STS 9750 STS 9653 G E G | 9650 9750 STS 2001 Sheet1 + Ready # E- + 100%