Solved

A Company Wants to Locate a New Warehouse to Minimize

Question 11

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 D9 of the spreadsheet? 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 D9 of the spreadsheet?   A)  =MIN(D4:D7) ^2 B)  =SUM(D4:D7)  C)  =SQRT(D4^2+D5^2+D6^2+D7^2)  D)  =SQRT(MMULT(B3:C3,D4:D7) )


A) =MIN(D4:D7) ^2
B) =SUM(D4:D7)
C) =SQRT(D4^2+D5^2+D6^2+D7^2)
D) =SQRT(MMULT(B3:C3,D4:D7) )

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions