In the Survey worksheet, enter a conditional function in cell M3 to calculate average satisfaction of service for store 251 (cel
l 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
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.
