Excel Job Interview Questions by Position

In this article, I summarize the MOST COMMON Excel questions that are currently asked during interviews. This covers positions such as business or MIS analyst, Data Analyst, Financial Analyst or more senior positions. You'll be surprised at the level of Excel that's currently required for some of these positions.

MAXIFS MINIFS with Multiple Criteria

Excel MAXIFS MINIFS (MAX MIN with Multiple Criteria) Finding the largest or smallest value in a set is one of the first tasks beginning Excel users discover.  Just after the SUM function, the MAX and MIN functions quickly become one of the