In the Survey worksheet, enter a conditional function in cell M# to calculate average satisfaction of service for store 251 (cell L#). Format the results with the Number format with two decimal points. Use fill handle in cell M# to copy the function down to complete the calculations. Be sure to use appropriate mixed or absolute referencing in M3 before copying.

Tom L Tarbell Tarbell_e08c1C Share AutoSave (.. o File Home Insert Page Layout Formulas Data Review View Developer Add-ins Help PDF Tell me what you want to do L7 AB Store Average Service Sohsfach Rank # VALUE ! Service 1 Highly dissatisficd 2 Dissatisfied 3 Neither 4 Satisfied 251 251 251 251 251 251 251 251 Correleho 372 679 679 6T9 679 6T9 679 6T9 679 6T9 679 372 372 372 372 372 372 372 372 372 2 Survey Wait Time Ready