Excel File Edit View Insert Format Tools Data Window Help

I need help on 5 & 6 Excel File Edit View Insert Format Tools Data Window Help Q Sun Sep 17 6:59 PM AutoSave .. Copy of hw3_start v Automate Tell me Q Home Insert Draw Page Layout Formulas Data Review View Comments Share P8 : X V fx BCD m F G cell P8 H K M N 0 p Q R T 1 earned 0 possible 5 general 0 Aaliyah Miller Press F9 to grade Feedback ON 2 31 32 33 34 35 36 37 38 39 40 41 42 5. In the Cities table below, what would be the result of this function? =Match(Cavendish,B5:B12,0) A. B7 B. 3 C. 4 D. Location 6. In the Cities table below, what would be the result of this function? =Index(B5:E12, 2, 3) A. 243,574 B. 332,851 C. Suburban D. Urban 44 45 46 B D 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 Cities 3 Location Population Type School Rating Amary 272,716 Suburban 5 Balten 332,851 Urban 6 Cavendish 243,574 Suburban 9 Dover 404,705 Urban 10 Elmore 239,636 Suburban 7 Flowerstone 138,376 Rural 6 Grady 306,727 Urban Harrisville 215,065 Suburban 9 5 6 8 9 10 11 12 Summary Onboarding Ready Accessibility: Investigate Stocks sort Stocks filter NCAA ForbesBestBusiness Employees Stocks Question 116%

The Correct Answer and Explanation is:

Let’s tackle these Excel function problems one at a time using the provided data.

Question 5 =MATCH("Cavendish", B5:B12, 0)

• The MATCH function looks for the value “Cavendish” in the range B5:B12.
• The third argument 0 specifies an exact match.
• The Cities listed in column B from row 5 to 12 are:
  1. B5: Amary
  2. B6: Balten
  3. B7: Cavendish ← 3rd item in the list
  4. B8: Dover
  5. B9: Elmore
  6. B10: Flowerstone
  7. B11: Grady
  8. B12: Harrisville

Therefore, “Cavendish” is the 3rd item in that range.

👉 Correct answer: B. 3

Question 6 =INDEX(B5:E12, 2, 3)

• The INDEX function returns the value at a specified row and column from a given range.
• The range is B5:E12, which includes:
  • Columns: Location, Population, Type, School Rating
  • Row 2 refers to the second row within the range, which is row 6 in the sheet. That row is Balten’s data.
  • Column 3 means the third column in that range, which is Type.

From the Balten row, the Type is Urban.

👉 Correct answer: D. Urban

These Excel functions are incredibly useful for referencing and retrieving data in structured tables. MATCH is your go-to for locating the position of a value, while INDEX retrieves a specific item at the intersection of a row and column. Used together, they can become even more powerful — think dynamic lookups and conditional data retrieval.