What formulas would I use to get the correct answer? Only the ones that aren't done yet for example, 3 and 7-12. Formulas consist of HLOOKUP, VLOOKUP, INDEX, MATCH, XLOOKUP, etc. Please please, will thumbs up and give good rating. formulas only, not hard coding.

B D E 1 2 Use the data below to answer the following questions: (row and column numbers should refer to the numbers typed in B36:365 and C35:135) 3 4 Correct Answer Parameters Delta Junction Your answer 27 5 1 Which row corresponds to the City: Delta Junction? City 27 6 7 2 What value is in row 6 of the Type column? Row: 6 8 Column Header: Type City City 9 10 3 What value is in column 'id' in the last row of the data? Column Header id 801,977 11 12 4 How many households live in the location associated with id 10110557 id: 1011055 372 372 13 5 What is the id of the location with 623 households? Households 623 801603 801603 14 15 16 6 What is the column header of column 72 Column Number: 7 Mean Income Mean Income 17 18 7 What is the Households in id: 8017197 Column Header Households 801719 19 id: 99 20 21 8 What value is in the cell 3 columns to the right and 3 rows up from cell E43? ? Columns to move right: Rows to move up 3 3 53 22 23 9 How many households live in the location type Town? Type: Town 2,836 10 How many locations have a mean income of less than 23000 and are classified as Town? 24 25 26 27 29 28 29 30 Income Threshold: Type: 23000 Town 11 How many cells in the dataset contain words? 94 31 12 What is the maximum mean income for locations with an area_code greater than 5607 Area_Code Threshold: 560 141,572 32 33 Extra Credit How many households live in an odd-numbered Area_code? 8,930 34 nincome for locations with an area_cade greater than 5607 Area Code Threshold SE 141,572 an add-numbered Area_Code? www8wwwwww88wwm B D E 1 2 Use the data below to answer the following questions: (row and column numbers should refer to the numbers typed in B36:365 and C35:135) 3 4 Correct Answer Parameters Delta Junction Your answer 27 5 1 Which row corresponds to the City: Delta Junction? City 27 6 7 2 What value is in row 6 of the Type column? Row: 6 8 Column Header: Type City City 9 10 3 What value is in column 'id' in the last row of the data? Column Header id 801,977 11 12 4 How many households live in the location associated with id 10110557 id: 1011055 372 372 13 5 What is the id of the location with 623 households? Households 623 801603 801603 14 15 16 6 What is the column header of column 72 Column Number: 7 Mean Income Mean Income 17 18 7 What is the Households in id: 8017197 Column Header Households 801719 19 id: 99 20 21 8 What value is in the cell 3 columns to the right and 3 rows up from cell E43? ? Columns to move right: Rows to move up 3 3 53 22 23 9 How many households live in the location type Town? Type: Town 2,836 10 How many locations have a mean income of less than 23000 and are classified as Town? 24 25 26 27 29 28 29 30 Income Threshold: Type: 23000 Town 11 How many cells in the dataset contain words? 94 31 12 What is the maximum mean income for locations with an area_code greater than 5607 Area_Code Threshold: 560 141,572 32 33 Extra Credit How many households live in an odd-numbered Area_code? 8,930 34 nincome for locations with an area_cade greater than 5607 Area Code Threshold SE 141,572 an add-numbered Area_Code? www8wwwwww88wwm