Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ignore the stuff i input because its wrong for sure. begin{tabular}{|ccc|} hline Position & City & Distance hline 3 & Chicago & 715

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
ignore the stuff i input because its wrong for sure.
\begin{tabular}{|ccc|} \hline Position & City & Distance \\ \hline 3 & Chicago & 715 \\ \hline 10 & Salt Loke City & 1960 \\ 1 & Aflanla & 0 \\ \hline 5 & Denver & 1437 \\ \hline 9 & New York & 884 \\ 8 & New Orleans & 499 \\ \hline 11 & Nashington DC & 657 \\ \hline 3 & Chicogo & \\ \hline & & \\ \hline & Sum Dletance \\ \hline \end{tabular} ProjectDates CityDistanceData Complete each of the tasks using the table of Major Cities and Distances to Other Major Cities data. 1.1) Complete range (120:126) by calculating the distance between each city and the next city in the list. a. Place your calculation in cell (120). b. Use the INDEX function. c. Note that you will not calculate a distance in cell since there is not a city below it on the list. d. Reference the city distance lookup table (range lin your formula. e. The position of each city is included next to the name of that city in range and should be referenced in your formula. f. Reuse your formula to complete the distance calculations in range Calculate the total of the distances between the cities in cell (129). 1.3) In range calculate the row position for the list of cities found in range a. Place your calculation in cell for the first city in cell b. Use the MATCH function. c. Reference the row labels of the lookup table (range ) in your formula. d. Reuse your formula to complete range (1.4) In range calculate the column position for the list of cities found in range a. Place your calculation in cell for the city in cell b. Use the MATCH function. c. Reference the row labels of the lookup table (range in your formula. d. Reuse your formula to complete range (1.5) In range calculate the distance between the cities (paired in rows) in ranges and d. Reuse your formula to complete range 1.5) In range (F20:F29), calculate the distance between the cities (paired in rows) in ranges and a. Place your calculation in cell (F20) for the distance between the first city (cell D20) and the second city (cell b. Use the INDEX function. c. Reference your row and column position calculations from the last two tasks as well as the table of distances (range d. Reuse your formula to complete range of the table. Match and Error Handling

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Administrator Limited Edition

Authors: Martif Way

1st Edition

B0CGG89N8Z

More Books

Students also viewed these Databases questions