Problem
The most common excel functions used for data analytics are vlookup (), concatenate, len, counta, countifs, sumifs, find/search, averageifs. Iferror, left/right, rank, minifs, maxifs, sumproduct.
• What are these Excel functions that are listed above, and
• What purpose would you use them in data analytics for your facility? Give at least 3 references and in-text citations.