PLEASE USE THE STATED FUNCTIONS IN THE QUESTIONS FOR YOUR FORMULAS

PLEASE USE THE STATED FUNCTIONS IN THE QUESTIONS FOR YOUR FORMULAS

PLEASE SHOW FORMULAS ONCE COMPLETED That is all I need

In the Full list tab, create the Management column as column H that shows if an occupation is a management position. a. A management position is defined as a title with either Executive" or "Manage" in it. b. Use table structured reference together with the FIND function and IF statement to create this column. Never count or point to any specific cell manually. The formula should look the same for all cells in this column. Create the fastest growing column as column L. a. If an occupation is among the fastest growing in the FastestGrowing table, it is a fastest growing job. b. Use table structured reference together with IF, ISTEXT and VLOOKUP to create this column. Never count or point to any specific cell manually. The formula should look the same for all cells in this column. A B H Fastest Growing Employment Employment RSE 140886310 8909910 3229990 200480 2984920 838050 22520 732490 278690 453800 83040 59850 101970 1 Occupation title 2 All Occupations 3 Management Occupations 4 Top Executives 5 Chief Executives 6 General and Operations Managers 7 Advertising, Marketing, Promotions, Public Relations, and Sales Managers 8 Advertising and Promotions Managers 9 Marketing and Sales Managers 10 Marketing Managers 11 Sales Managers 12 Public Relations and Fundraising Managers 13 Public Relations Managers 14 Fundraising Managers 15 Operations Specialties Managers 16 Administrative Services and Facilities Managers 17 Administrative Services Managers 18 Facilities Managers 19 Computer and Information Systems Managers 20 Financial Managers 21 Industrial Production Managers 22 Purchasing Managers 23 Transportation, Storage, and Distribution Managers 24 Compensation and Benefits Managers 25 Human Resources Managers 26 Training and Development Managers 27 Other Management Occupations 28 Farmers, Ranchers, and Other Agricultural Managers 29 Construction Managers 30 Education and Childcare Administrators 31 Education and Childcare Administrators, Preschool and Daycare 32 Education Administrators, Postsecondary 33 Education Administrators, All Other 34 Architectural and Engineering Managers 35 Food Service Managers 36 Entertainment and Recreation Managers 37 Gambling Managers 20 Cntortainment and Darrostion Mansoor Cycont Gambling Full list Fastes Growing Ready Accessibility: Investigate * 23190 2116020 325850 224620 101230 485190 681070 192270 69310 144640 15330 E F G Employment per 1,000 jobs Mean hourly wage Annual mean wage Management 0 0 1000 28.01 58260 0.002 63.242 59.31 123370 0.004 22.926 57.94 120520 0.016 1.423 102.41 213020 0.005 21.187 55.41 115250 0.008 5.948 69.77 145130 0.034 0.16 68.68 142860 0.009 5.199 70.48 146600 0.01 1.978 73.77 153440 0.012 3.221 68.46 142390 0.017 0.589 63.85 132800 0.022 0.425 66.35 138000 0.018 0.165 57.4 119400 0.005 15.019 67.26 139900 0.007 2.313 52.69 109590 0.007 1.594 54.34 113030 0.013 0.719 49.03 0.009 3.444 78.33 162930 0.006 4.834 73.78 153460 0.006 1.365 56.62 117780 0.009 0.492 64.71 134590 0.011 1.027 50.76 105580 0.025 0.109 67.05 139470 0.014 1.182 65.67 136590 0.012 0.254 61.92 128800 0.003 19.348 51.55 107230 0.056 0.037 37.71 78440 0.015 2.021 52.02 108210 0.005 3.812 47.73 99280 0.027 0.401 25.87 53800 0.003 1.107 53.49 111260 0.017 0.355 45.54 94730 0.009 1.328 76.43 158970 0.019 1.495 30.75 63970 0.028 0.152 36.75 76430 0.035 0.026 42.88 89190 166530 35830 2725860 5220 284750 537100 56430 155990 49970 187100 210680 21460 3660 1700n n 126 25 10 72010 + In the Full list tab, create the Management column as column H that shows if an occupation is a management position. a. A management position is defined as a title with either Executive" or "Manage" in it. b. Use table structured reference together with the FIND function and IF statement to create this column. Never count or point to any specific cell manually. The formula should look the same for all cells in this column. Create the fastest growing column as column L. a. If an occupation is among the fastest growing in the FastestGrowing table, it is a fastest growing job. b. Use table structured reference together with IF, ISTEXT and VLOOKUP to create this column. Never count or point to any specific cell manually. The formula should look the same for all cells in this column. A B H Fastest Growing Employment Employment RSE 140886310 8909910 3229990 200480 2984920 838050 22520 732490 278690 453800 83040 59850 101970 1 Occupation title 2 All Occupations 3 Management Occupations 4 Top Executives 5 Chief Executives 6 General and Operations Managers 7 Advertising, Marketing, Promotions, Public Relations, and Sales Managers 8 Advertising and Promotions Managers 9 Marketing and Sales Managers 10 Marketing Managers 11 Sales Managers 12 Public Relations and Fundraising Managers 13 Public Relations Managers 14 Fundraising Managers 15 Operations Specialties Managers 16 Administrative Services and Facilities Managers 17 Administrative Services Managers 18 Facilities Managers 19 Computer and Information Systems Managers 20 Financial Managers 21 Industrial Production Managers 22 Purchasing Managers 23 Transportation, Storage, and Distribution Managers 24 Compensation and Benefits Managers 25 Human Resources Managers 26 Training and Development Managers 27 Other Management Occupations 28 Farmers, Ranchers, and Other Agricultural Managers 29 Construction Managers 30 Education and Childcare Administrators 31 Education and Childcare Administrators, Preschool and Daycare 32 Education Administrators, Postsecondary 33 Education Administrators, All Other 34 Architectural and Engineering Managers 35 Food Service Managers 36 Entertainment and Recreation Managers 37 Gambling Managers 20 Cntortainment and Darrostion Mansoor Cycont Gambling Full list Fastes Growing Ready Accessibility: Investigate * 23190 2116020 325850 224620 101230 485190 681070 192270 69310 144640 15330 E F G Employment per 1,000 jobs Mean hourly wage Annual mean wage Management 0 0 1000 28.01 58260 0.002 63.242 59.31 123370 0.004 22.926 57.94 120520 0.016 1.423 102.41 213020 0.005 21.187 55.41 115250 0.008 5.948 69.77 145130 0.034 0.16 68.68 142860 0.009 5.199 70.48 146600 0.01 1.978 73.77 153440 0.012 3.221 68.46 142390 0.017 0.589 63.85 132800 0.022 0.425 66.35 138000 0.018 0.165 57.4 119400 0.005 15.019 67.26 139900 0.007 2.313 52.69 109590 0.007 1.594 54.34 113030 0.013 0.719 49.03 0.009 3.444 78.33 162930 0.006 4.834 73.78 153460 0.006 1.365 56.62 117780 0.009 0.492 64.71 134590 0.011 1.027 50.76 105580 0.025 0.109 67.05 139470 0.014 1.182 65.67 136590 0.012 0.254 61.92 128800 0.003 19.348 51.55 107230 0.056 0.037 37.71 78440 0.015 2.021 52.02 108210 0.005 3.812 47.73 99280 0.027 0.401 25.87 53800 0.003 1.107 53.49 111260 0.017 0.355 45.54 94730 0.009 1.328 76.43 158970 0.019 1.495 30.75 63970 0.028 0.152 36.75 76430 0.035 0.026 42.88 89190 166530 35830 2725860 5220 284750 537100 56430 155990 49970 187100 210680 21460 3660 1700n n 126 25 10 72010 +