13

Complete Live Case section in the Scenario worksheet. There are 4 scenarios in this model: Consensus, Bull, Bear, and Other. The numbers in the live case should reflect one of the cases based on cell K14, which is dynamically linked to the scenario selected in the dropdown menu at the top of the worksheet. What formula will you use to fill cell G21 (online stores for 2018E)?

Review Later

=CHOOSE($B$1,G76,G130,G184,G238)

=CHOOSE($K$14,G76:Q238)

=CHOOSE($K$14,G76,G130,G184,G238)

=CHOOSE($B$1,G76:Q238)