(a) Compute the projected absolute and percentage increase over the current value for each occupational category.

(b) Use the VLOOKUP function to obtain the projected value for Social Scientists. Please display the VLOOKUP formula in your answer.

(c) Use the XMATCH function to find which row in the table is for Social Scientists. Please provide the XMATCH formula in your answer.

12345 A 6 Occupation 7 Scientists 8 Life scientists 9 Mathematical/computer scientists 10 Computer specialists 11 Mathematical scientists 12 Physical scientists 13 Social scientists 14 Engineers 15 All occupations 16 17 18 19 20 B Current 3,241 184 2,408 2,318 89 239 410 1,465 145,571 C Projected 5,301 218 4,308 4,213 95 283 492 1,603 167,754 D E F G H T J