Answer Happy

File LOG- Paste Clipboard 14 - Home A 3 4 Jonathan 5 Rohan 6 Gina 7 Jackson 8 Will 9 Bobby 10 Paulo 11 Peter 12 Mario 13 Max 4 ▸ Ready 14 Frederick 15 Jason First Name Last Name Callbri m Insert Page Layout Formulas A A == A. BIU FA B Font Burns Patel Davidson White Jones Williams Lopez Johnson Terranova Kolb Lamb Waung Payroll 11 ✓ fx с === . Payroll Position D Precision Building Foreman Foreman Office Manager Procurement Mgr Construction Level 1 Construction Level 1 Construction Level 2 Construction Level 2 Construction Level 2 Construction Level 3 Master Carpenter Master Carpenter + 10 5 8 Data 4 Alignment 3 3 6 5 3 7 10 5 Review Wrap Text Merge & Center E $75,000 $67,000 $45,000 $48,000 View $37,000 $38,500 $42,500 $44,750 $43,500 $52,000 $60,500 $57,500 F Tenure Compensatio Performance (Years) Rating 5 4 3 3 Custom 2 4 3 5 1 5 4 5 $ V Tell me what you want to do % Number G G Conditional Format as Cell Formatting Table Styles Styles H I Average Compensation by Performance Rating 5 4 3 2 1 Insert Delete Format Cells Task Instructions Σ AutoSum Fill ✓Clear AY O Sort & Find & Filter Select Editing X In cell 14, enter a formula using the AVERAGEIF function to calculate the average Compensation values found in range E4:E16 for records with a Performance Rating value of 5 in range F4:F16 Share Q Comments R + 100%