19. You are the practice scheduler for the local racing circuit. The list below represents the entrants for this Sunday's event and you need to separate first and last names. What Excel function should you employ? B First Name Last Name 1 Full Name 2 Lewis Hamilton 3 Sebastian Vettel 4 Daniel Ricciardo 5 Romain Grosjean 6 Valtteri Bottas Data Validation Paste Special Flash Fill Justify 20. You are responsible for valuing the inventory of a crude oil depot based on daily closing prices, and you have created a spreadsheet to help you. The cells in column A tell the ownership status of individual grades of oil (Holding or Not Holding), column B reports the closing price, and column C issues instructions based on the closing price (Bid, Offer, or Do Nothing). The rules for taking action are as follows: . . If the closing price is >=$75 and we own the oil, we will offer it for sale. If the closing price is =75). "Offer", IF ((A2="Not Holding".B2=75), "Offer",IF(AND(A2=" Holding",B2