Required:

Match the Excel menu option $($Data Analysis, What$-$if Analysis$)$ to the analytics technique used.

$\backslash$table$[[$Analytics Technique Used,Excel Menu Option$],[$Average of sales for the last five years,$],[$Goal$-$seek analysis to determine the desired CPM rate,$],[$Scenario analysis to select the best advertising campaign,$],[$Correlation of user clicks, of internet advertisements and sales revenue,$],[$Regression of the relationship between advertising expense and sales revenue,$]]$