$\backslash$table$[[$First$,$Last,Grade,Full Name,Income,CORRECT$],[$John$,$Doe,A$,\backslash$table$[[$John Doe$],[$Jane Doe$],[$Bill Smith$],[$Bree Smith$],[$Cary Williams$]],50000,$ENTER CORRECT FORMULA$],[$Jane$,$Doe,$A,60000,],[$Bill$,$Smith,B$,70000,],[$Bree$,$Smith,B$,80000,],[$Cary$,$Williams,C$,90000,]]$

Create$($calculate$)$ Full Name in D$4$

Use TextJoin to create Full Name with space in between e$.$g$.$ John Doe. Skip the second value where it asks fo Use Autofill to complete rest of rows Row D$5$ thru D$8$ In E$4$ thru E$8$ insert Income. Use the Sequence function to input income for five people with starting value of

Enter Formula in A$10$

In A$10,$ use Sort function to sort by First name Ascending $--$ Sort functions need data i$.$e$.$ A$4$:E$8,$ Sort column and sort order i$.$e$.$ Ascending you will type for $1$ for Ascending i$.$e$.=$sort$(x,x,x).$ You do not need the last value function for COL $.$ Your Answer Should should look like picture shown below