Make the direct marketing 2 worksheet active. Create a scenario named best case, using the number of ads and click rate. Enter these values for the scenario: 40,000, and 6.5%.
A. Excel formula for CTR
B. Scenario manager in Excel
C. Data validation in Excel
D. Conditional formatting in Excel