2. Complete this problem on Sheet2. The location of an object can be described by its...

Transcribed Image Text:

2. Complete this problem on Sheet2. The location of an object can be described by its x and y coordinates. Let's say that you want to know the distance between two mountain peaks. The first peak is located at (x1, yl) and the second peak is located at (x2, y2). y (x2, y2) y2-yl (x1, yl) (0,0) х2 —х1 The distance, d, between two points in space can be calculated by using the following equation: d- J(x, - x,' + (y; – y,) Type the values of x1 and yl into cells B1 and B2. Next type the values of x2 and y2 into cells DI and D2. Then create a macro named caledist that will accomplish the following tasks: • Obtain the values for x1 and yl from the worksheet and store them in variables • Obtain the values of x2 and y2 from the worksheet and store them in variables • Calculate the distance between the two mountain peaks and store this value in a variable • Output the distance to cell C5 Create a run button on Sheet2 that will execute the macro calcdist. Before clicking the run button, make sure that you input the values of x1 and yl in cells BI and B2, and input the values of x2 and y2 into cells DI and D2. To test your code, try typing 2 and 4 into cells B1 and B2, and type 5 and 6 into cells D1 and D2. Then click the run button. The distance between the two points is, d- (5- 2)° + (6- 4)* - V3 +2 - V13 - 3.606 If the units of x1, yl, x2, and y2 are miles, then the two peaks are about 3.6 miles away other. 2. Complete this problem on Sheet2. The location of an object can be described by its x and y coordinates. Let's say that you want to know the distance between two mountain peaks. The first peak is located at (x1, yl) and the second peak is located at (x2, y2). y (x2, y2) y2-yl (x1, yl) (0,0) х2 —х1 The distance, d, between two points in space can be calculated by using the following equation: d- J(x, - x,' + (y; – y,) Type the values of x1 and yl into cells B1 and B2. Next type the values of x2 and y2 into cells DI and D2. Then create a macro named caledist that will accomplish the following tasks: • Obtain the values for x1 and yl from the worksheet and store them in variables • Obtain the values of x2 and y2 from the worksheet and store them in variables • Calculate the distance between the two mountain peaks and store this value in a variable • Output the distance to cell C5 Create a run button on Sheet2 that will execute the macro calcdist. Before clicking the run button, make sure that you input the values of x1 and yl in cells BI and B2, and input the values of x2 and y2 into cells DI and D2. To test your code, try typing 2 and 4 into cells B1 and B2, and type 5 and 6 into cells D1 and D2. Then click the run button. The distance between the two points is, d- (5- 2)° + (6- 4)* - V3 +2 - V13 - 3.606 If the units of x1, yl, x2, and y2 are miles, then the two peaks are about 3.6 miles away other.

Answer rating: 100% (QA)

Stepl Open an excel and enter values in cells B1B2C1 and C2 a... View the full answer