This is a case from the Financial Modeling World Cup 2021, Stage 3 (Mar 26-29) competition. This is a straightforward case, where you will have to match different Excel formulas with their respective descriptions.

Case description:

To expand the knowledge of Excel formulas and features for FMWC participants. To challenge financial modelers to broaden their arsenal of techniques in using Excel.

It is common for financial modelers to stop learning Excel formulas after they have learned the minimum number of formulas that can do the work. This may result in them not knowing the best formula to use for certain situations, leading to time-consuming workarounds. In this case, financial modelers are challenged to match Excel formulas with their definitions to broaden their knowledge of Excel.

The downloadable file consists of the following:
-Task: PDF file with Case Materials and Task Description
-Solution: PDF file with correct Answers in Bold

This model awarded 250 points, while the whole 2h Stage allowed to earn 1,000 points in total.

For your questions/suggestions/consideration please reach out to the Organizing Committee of the Financial Modeling World Cup at info@fmworldcup.com
You can also buy tickets to participate in the future FMWC Stages at https://fmworldcup.com/shop/