★0 XP
Question 1 of 10
The INDEX function returns a value at a specific column and row within a range. Get "Berlin" with =INDEX(A1:B4, 3, 2) because it is in the third row and the second column.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Australia | Sydney | ||
| 2 | France | Paris | ||
| 3 | Germany | Berlin | ||
| 4 | Thailand | Bangkok | ||
| 5 |
D6fx