Below is a partial screenshot of an Excel project you are working on. Columns A, B, and C list the first name, last name, and middle initial of your clients. Suppose you want to combine them into a full name field (Column D) in the form of first name, space, last name, a comma and space, middle initial and a period. A sample result is already provided in Cell D2. Please write the exact Excel function you'd type in D2 such that it can be quickly duplicated to the rest of the column.

You may assume there are no leading or trailing spaces in any of the text fields. To be accurately graded by Canvas, your answer must a) include the equal sign, b) be in all CAPS, and c) contain no spaces except the ones used as text.

Continuing from the previous question, suppose you are asked to generate a unique computer ID for each of the clients by combining the first two letters of their first name, the middle initial, and the first two letters of their last name - all in lower cases. For example, for Graham K. Eaton, the ID should be grkea. Please write an Excel function for this in cell E2 such that it can be quickly duplicated to the rest of the column. To be automatically graded by Canvas, you answer must 1) include the equal sign "=", 2) be in all CAPS, and 3) contain no spaces.

Below is a partial screenshot of an Excel project you are working on. Columns A, B, and C list the first name, last name, and middle initial of your clients. Suppose you want to combine them into a full name field (Column D) in the form of first name, space, last name, a comma and space, middle initial and a period. A sample result is already provided in Cell D2. Please write the exact Excel function you'd type in D2 such that it can be quickly duplicated to the rest of the column. You may assume there are no leading or trailing spaces in any of the text fields. To be accurately graded by Canvas, your answer must a) include the equal sign, b) be in all CAPS, and c) contain no spaces except the ones used as text. A 1 FIRST 2 Graham 3 Roxana 4 Dolores 5 Elizabeth 6 Charles 7 Linda 8 Robert B LAST Eaton Uhlig Forrester Whitney Bullock Coulahan Burns D M.I. FULL NAME K Graham Eaton, K. Q L S J Y