A company wants to locate a new warehouse to minimize the distance traveled by its delivery trucks. It has four stores and their coordinates are listed in the accompanying spreadsheet. What formula goes in cell D4 of the spreadsheet?
A) =(B4-$B$3)^2+(C4-$C$3)^2
B) =SQRT((B4-$B$3)+(C4-$C$3))
C) =SQRT((B4-$B$3)^2+(C4-$C$3)^2)
D) =(B4-$B$3)+(C4-$C$3)

Question

A company wants to locate a new warehouse to minimize the distance traveled by its delivery trucks. It has four stores and their coordinates are listed in the accompanying spreadsheet. What formula goes in cell D4 of the spreadsheet? 
A) =(B4-$B$3)^2+(C4-$C$3)^2 
B) =SQRT((B4-$B$3)+(C4-$C$3)) 
C) =SQRT((B4-$B$3)^2+(C4-$C$3)^2) 
D) =(B4-$B$3)+(C4-$C$3)

Quizplus · Accepted Answer

The formula is calculating the distance between the coordinates of the store (B4 and C4) and the potential warehouse location ($B$3 and $C$3). To find the distance, the formula needs to calculate the square of the difference of the x-coordinates (B4-$B$3)^2 plus the square of the difference of the y-coordinates (C4-$C$3)^2, then take the square root of the sum of these two terms. Therefore, option C =SQRT((B4-$B$3)^2+(C4-$C$3)^2) is the correct formula to calculate the distance.

A Company Wants to Locate a New Warehouse to Minimize