A Company Wants to Locate a New Warehouse to Minimize

Multiple Choice

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)