For the final question, we will use a multi-cell array formula to populate the final table. Row and column counters have been provided for us (the numbers 1 to 5 to the left and above the table). We can use these to help us fill in only the green cells by writing a condition that returns the value from the first table only when the row counter (G21:G25) is less than or equal to the column counter (I19:M19).\ Select all of the cells 121:M25, write a single array formula that refers to the top table and employs this counter-condition that will successfully accomplish the task, and press Ctrl+Shift+Enter. The values in the grey cells should be 0 . When you are done, submit the value from the third checksum at cell

H16

.\ HINT: Don't be alarmed if the main diagonal of the table gives values of zero. This is what we expect since the distance from a town to itself is zero.

11. For the final question, we will use a multi-cell array formula to populate the final table. Row and column counters have been provided for us (the numbers 1 to 5 to the left and above the table). We can use these to help us fill in only the green cells by writing a condition that returns the value from the first table only when the row counter (G21:G25) is less than or equal to the column counter (I19:M19). Select all of the cells 121:M25, write a single array formula that refers to the top table and employs this counter-condition that will successfully accomplish the task, and press Ctrl+Shift+Enter. The values in the grey cells should be 0 . When you are done, submit the value from the third checksum at cell H16. HINT: Don't be alarmed if the main diagonal of the table gives values of zero. This is what we expect since the distance from a town to itself is zero