Generate random excel scenarios using the specified excel functions. NO INFORMATION IS MISSING, THE DATASETS CAN BE
Question:
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******
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.