$5$

$2$ points

You've collected job satisfaction data using $5$ questions, each scored on a $5$ point scale. You are asked to report about overall job satisfaction $($mean of the $5$ values$)$ for each department. F$2$ F$60$ contains the average values from questions $1-5.$ G$2-$ G$60$ contains the location for each employee. You are first requesting the average for the location Hayward, CA $($which is located in cell K$2).$

Which of the following formulas will provide the average job satisfaction rating for employee at the Hayward, CA location?

Which formula would be most appropriate.

None of these are correct

$=$ AveragelF$($$G$$2$:$G$$0,$ "Hayward, CA$",$ K$2)$

$=$ Average $,$ Hayward, CA$,$ $$G$$$2$:$$G$$$60)$

$=$ AveragelF$($$G$$2$:$G $$60,$ "Hayward, CA$",$ $F$$2$:$F$60)$