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.
Easily calculate the ratio of two numbers in Excel with Excel formulas. Ratios are a common way to compare amounts. To calculate ratios you need to calculate the highest common factor. You can easily do this with the GCD function.