Explain how to do it in excel please

21. A distribution center is considering four possible locations for their new facility The following table (in DC.xls) presents the x and y coordinates of these locations The management is planning to choose the location that would minimize the total distance traveled to serve their customers. File Customers.xls, worksheet Locations contains the location of the customers Calculate the total distancetraveled from each candidate location to the customers. Consider Euclidean distance between locations. Calculate the distances in DC.xls referencing customer locations in Customers.xls Using the Create Name option, name the range of cells that presents the distances from a particular location to all customers. Use the formulas '=sum(A)' to '=sum(D), to calculate the total distance from a candidate location to all customers Note that: the Euclidean distance between locations A and B is calculated as Distance From/To C1 y-Coord 300 155 225 350 DC Location x-Coord 200 100 135 250 C2 C3 C4 Total Customers Location C1 C2 C3 C4 x-Coord 190 210 144 180 y-Coord 178 89 344 310