Question

AutoSave 6 9 File Home insert NOX A B 8 . Bxcel. Chap Assigment 22 (1) P age Layout Formulas Data P Draw Excel Review arch Help View Uyarma. Rossi001 C D E F G · Problem 1 Problem 2 Problem 3 Answers Here 2757 ! Chicago Boston Chicago - NONEN Dallas 1815 1 Boston 2 Chicago 3 Dallas 1815 1205 2052 Denver LA 1991 1050 901 0 1174 1332 Miami Phoeni 3036 2112 1390 1729 1425 1332 1027 1174 836 2257 2757 0 2359 3036 0 1373 1909 1027 396 3389 1482 & Seattle 2612 2359 2404 1909 33891482 Instructions: Problem 2 Instructions: Problem 1 Use the INDEX function to compute the distance between Los Angeles and Phoenix and the distance between Denver and Miami. problemst 23 NBA dista Use the INDEX function to compute the total distance from Dallas to the other Instructions: Problem Aresident of Dallas, is embarking on a road trip that takes her to Chicago, Denver, Los Angeles, Phoenix, and Seattle. How many miles will she travel on this trip? Type here to sea

I need help with problem 3. On how many miles will she travel on this trip?

Answer 1

Answer: She will travel 5309 miles on this trip.

M Problem 3 Answers Here Dallas Chicago 1205 1050 Denver 1174 Phoenix Seattle 398 1482 5309 miles Formulas: INDEX(distances,9,1) =INDEX(distance,9,7)

		Boston	Chicago	Dallas	Denver	LA	Miami	Phoenix	Seattle
1	Boston	0	983	1815	1991	3036	1569	2664	2612
2	Chicago	983	0	1205	1050	2112	1390	1729	2052
3	Dallas	1815	1205	0	801	1425	1332	1027	2404
4	Denver	1919	1050	801	0	1174	1332	836	1373
5	LA	3036	2112	1425	1174	0	2757	398	1909
6	Miami	1539	1390	1332	1332	2757	0	2359	3389
7	Phoenix	2664	1729	1027	836	398	2359	0	1482
8	Seattle	2612	2052	2404	1373	1909	3389	1482	0
To get the index number
Step 1: Select entire range a10:j18, right click name it "distances"
Step 2: formula =index(distances, row number, column number) example chicago=index(distances,3,1)
Step one: select C10:j18, right-click, SELECT RANGE and name the range "distance"
Step 2: go to column n4, type formula "=index(distance,row number,column number)",

Formulas:

M 1 Problem 3 Answers Here 2 3 Dallas 4 Chicago 5 Denver 6 LA 7 Phoenix 8 Seattle =INDEX(distances,4,1) =INDEX(distances,3,1) =INDEX(distances,5,1) =INDEX(distances,6,1) =INDEX(distances,8,1) =INDEX(distances,9,1) =INDEX(distance,3,3) =INDEX(distance,5,2) =INDEX(distance,6,4) =INDEX(distance,8,5) =INDEX(distance,9,7) =SUM(N4:N8) 9 miles 10 11 Formulas: "=INDEX(distances,9,1) =INDEX(distance, 9,7)