Take a look at the Data Source and Klip Below. In order to build the “Delayed Units” Series, why is it necessary to use the LOOKUP function?

1. Because certain States have higher numbers of Units
2. Because each State has a different numbers of Cities
3. Because not all States have “Delayed” orders
4. Because there are four different Regions, and each Region has a different number of States.
5. Because the “Units” column has numerical data.

Correct Answer:

• Because not all States have “Delayed” orders