Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please do not answer if you are not willing to post the excel functions for me to see it is important I know how to

Please do not answer if you are not willing to post the excel functions for me to see it is important I know how to do the functions required so seeing them is a must.
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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 I in 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 (1.2) 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 4 (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

Fundamentals Of Database Systems

Authors: Ramez Elmasri, Sham Navathe

4th Edition

0321122267, 978-0321122261

More Books

Students also viewed these Databases questions