In cell c17 create a nested formula using the index – In the realm of data manipulation, nested formulas emerge as a powerful tool, enabling users to perform intricate calculations…