Question

In the Survey worksheet, enter a conditional function in cell M3 to calculate average satisfaction of service for store 251 (cell L3). Format the results with the Number Format with two decimal points. Hint: On the Formulas tab, in the Function Library group, click the More Functions button, and then click Statistical. The function is

Answer 1

Answer:

The answer is "The method is AVERAGEIF ".

Explanation:

The spreadsheet is a part of Microsoft Excel, in which the AVERAGEIF is the method, that determines the number average in such a range, that needs to be supplied in the range of more rows, which includes number, name, sets, and links.  

• It is also known as the criteria-number, that express, reference to cells or message.  
• It is an average range, that is optional for the average unit.