Generate random excel scenarios using the specified excel functions. NO INFORMATION IS MISSING, THE DATASETS CAN BE RANDOM.

*****EACH SCENARIO CAN HAVE RANDOM DATASETS, IT DOES NOT HAVE TO BE THE SAME*****

****SHOW FORMULAS AS WRITTEN TEXT NEXT TO EACH SCENARIO'S SOLUTION******

*****GENERATE FOUR DIFFERENT DATASETS********

Scenario one: Generate an Excel dataset using the excel function of INDEX FUNCTION. Explain the function's usefulness

Scenario Two: Generate an Excel dataset using the excel function COUNTIF and COUNTA FUNCTIONS. Explain the function's usefulness.

Scenario Three: Generate an Excel dataset using the excel functions NPV and XNPV FUNCTIONS. Explain the function's usefulness.

Scenario Four: Generate an Excel dataset using the excel functions IRR, XIRR, and MIRR FUNCTIONS. Explain the function's usefulness.