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 to calculate the distance between two coordinates is the distance formula, which is the square root of (x2-x1)^2 + (y2-y1)^2. This formula is represented by the given option C.

A Company Wants to Locate a New Warehouse to Minimize