Show and Tell 3. Try it: Show the New Scenarios Select a Scenario: Change Everything Click on Show. The numbers in Cells B1, B2 and B3 changed. All of the formulas in Column E updated and used the new data to calculate the Revenue.   Try This, Too: Show Another Scenario Select a Scenario: Change Back Click on Show. The numbers in Cells B1, B2 and B3 changed back. All of the formulas in Column E updated and recalculated the Revenue.   That's Scenarios: a useful tool for analyzing your data. You can save your spreadsheet. Data -> Data Tools ->What-If Analysis -> Scenario Manager Exam 77-888: Microsoft Excel Expert 2010 3. Presenting Data Visually 3.2. Apply data analysis: Data Tools What-If Analysis