Spreadsheets: formulas, cleaning and charts

The concept

AI is at its best in a spreadsheet when it explains a formula you can then own. Ask for the formula and a line on each part, ask how to clean a messy column, ask which chart answers which question — then type it in and check it on a few real rows yourself. A formula you cannot explain line by line is a formula that breaks the week after you move on.

The mistake is pasting a formula you do not understand into a sheet a team relies on. The columns will change next month, and you will be the one asked to fix it — where "the AI wrote it" is not an answer. Type it in, test it on a few real rows, and keep the one-line explanation next to it.

In Google Sheets, column A holds full names like Asha Ramesh Patil.
Give me a formula for the first name and one for the last name, explain
each part so I could write it myself, and tell me what breaks for a name
with two words in the surname.

First name:  =LEFT(A2, FIND(" ", A2) - 1)
Last name:   =TRIM(RIGHT(SUBSTITUTE(A2, " ", REPT(" ", 99)), 99))

FIND finds the first space and LEFT keeps the part before it.
The last-name trick swaps every space for many spaces, then takes the
right-hand end, so a two-word surname stays whole.