[TABLE="width: 1142"]
<tbody>[TR]
[TD="colspan: 11"]There are 8 cities in the country of Eight, A, B, C, D, E, F, G and H. Mr. Z decides to visit each city in his car starting from A. His planned itinerary is
A-->B-->C-->D-->E-->F-->G-->H.
The distance between the cities is given in Table I[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 1142"]
<tbody>[TR]
[TD="colspan: 11"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 19"]Table I[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 19"]Distance[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 11"][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 11"]A[/TD]
[TD]0[/TD]
[TD]200[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD="colspan: 11"]B[/TD]
[TD]200[/TD]
[TD]0[/TD]
[TD]350[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD="colspan: 11"]C[/TD]
[TD][/TD]
[TD]350[/TD]
[TD]0[/TD]
[TD]500[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]550[/TD]
[/TR]
[TR]
[TD="colspan: 11"]D[/TD]
[TD][/TD]
[TD][/TD]
[TD]500[/TD]
[TD]0[/TD]
[TD]250[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1050[/TD]
[/TR]
[TR]
[TD="colspan: 11"]E[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]250[/TD]
[TD]0[/TD]
[TD]850[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1300[/TD]
[/TR]
[TR]
[TD="colspan: 11"]F[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]850[/TD]
[TD]0[/TD]
[TD]1250[/TD]
[TD][/TD]
[TD][/TD]
[TD]2150[/TD]
[/TR]
[TR]
[TD="colspan: 11"]G[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1250[/TD]
[TD]0[/TD]
[TD]150[/TD]
[TD][/TD]
[TD]3400[/TD]
[/TR]
[TR]
[TD="colspan: 11"]H[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]150[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]3550[/TD]
[/TR]
[TR]
[TD="colspan: 11"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 21"]Write a formula which takes the number of kms that Mr. Z has travelled from A as the input and displays the name of the city which is nearest to that point.
Mr. Z will enter the number of kms he has travelled from A in cell D30 and the name of the city nearest to the point will be displayed in E30[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 1142"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Number of Kms that Mr. Z has travelled[/TD]
[TD]Nearest City[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
<tbody>[TR]
[TD="colspan: 11"]There are 8 cities in the country of Eight, A, B, C, D, E, F, G and H. Mr. Z decides to visit each city in his car starting from A. His planned itinerary is
A-->B-->C-->D-->E-->F-->G-->H.
The distance between the cities is given in Table I[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 1142"]
<tbody>[TR]
[TD="colspan: 11"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 19"]Table I[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 19"]Distance[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 11"][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 11"]A[/TD]
[TD]0[/TD]
[TD]200[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD="colspan: 11"]B[/TD]
[TD]200[/TD]
[TD]0[/TD]
[TD]350[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD="colspan: 11"]C[/TD]
[TD][/TD]
[TD]350[/TD]
[TD]0[/TD]
[TD]500[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]550[/TD]
[/TR]
[TR]
[TD="colspan: 11"]D[/TD]
[TD][/TD]
[TD][/TD]
[TD]500[/TD]
[TD]0[/TD]
[TD]250[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1050[/TD]
[/TR]
[TR]
[TD="colspan: 11"]E[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]250[/TD]
[TD]0[/TD]
[TD]850[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1300[/TD]
[/TR]
[TR]
[TD="colspan: 11"]F[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]850[/TD]
[TD]0[/TD]
[TD]1250[/TD]
[TD][/TD]
[TD][/TD]
[TD]2150[/TD]
[/TR]
[TR]
[TD="colspan: 11"]G[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1250[/TD]
[TD]0[/TD]
[TD]150[/TD]
[TD][/TD]
[TD]3400[/TD]
[/TR]
[TR]
[TD="colspan: 11"]H[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]150[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]3550[/TD]
[/TR]
[TR]
[TD="colspan: 11"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 21"]Write a formula which takes the number of kms that Mr. Z has travelled from A as the input and displays the name of the city which is nearest to that point.
Mr. Z will enter the number of kms he has travelled from A in cell D30 and the name of the city nearest to the point will be displayed in E30[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 1142"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Number of Kms that Mr. Z has travelled[/TD]
[TD]Nearest City[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]