the INDEX function referencing the row of distribution center names to find the name of the distribution center that should service that customer.$)$

Click on the datafile logo to reference the data.

DATA $\frac{?}{\text{b}\text{a}\text{r}}($ file $)$

$($Hint: The INDEX function may be used with a two$-$dimensional array: $=$INDEX$($array$,$ row$\_$num, column$\_$num$),$ where array is a matrix, row$\_$num is the row numbers and column$\_$num is the column position of the desired element of the matrix.$)$ each shipment. What is the total amount that Floyd's Bumpers spends on these May shipments?

If required, round your answers to two decimal places.

Check My Work $(2$ remaining$)$

Icon Key

Problem $10-20$ Algo $($Some Useful Excel Functions for Modeling$)$

Submit Assignment for Grading