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))

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 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))

Quizplus · Accepted Answer

The Answer of 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 Company Wants to Locate a New Warehouse to Minimize