Please help ke with the formulas fod fidst name last name and initials

D$10$

$f_x=$RIGHT$(C19,2)$

A

You are to fill in the missing cells in the table below with the appropriate calculated text. You may use the open space on the rest of this worksheet to build formulas to derive the pieces you will need, and then you may simply add referral formulas in the table to pull the text from wherever you produce it$.$ For this exercise, the grader will be primarily checking the results of your work, and verifying that you used only the approved functions listed in the syllabus in your formulas.

$\frac{1}{2}$

$\backslash$table$[[,,,,],[$LastName$,$ FirstName MI$.,$FIRST NAME,MIDDLE INITIAL,LAST NAME,Initials for this$],[$ROSS$,$ MARY F$.,,,,],[$STEVENS$,$ JENNIFER F$.,$F$.,,,],[$WRIGHT$,$ DOROTHYY.,F$.,,,],[$ANDERSON$,$ HARRY B$.,$Y$.,,,],[$CRAWFORD$,$ JERRY O$.,$B$.,,,],[$MURPHY$,$ NATHAN F$.,$O$.,,,],[$PARKER$,$ ERICZ.,F$.,,,],[$GRAY$,$ ANGELA M$.,$Z$.,$M$.,,]]$

$12$

middle innitial

last name

ROSS, MARY F$.$

F$.$

STEVENS, JENNIFER $F.$

WRIGHT, DOROTHY Y$.$

ANDERSON, HARRY B$.$

CRAWFORD, JERRY O$.$

MURPHY, NATHAN F F$.$

PARKER, ERICZ. Z$.$

GRAY, ANGELA M$.$ M