Go to the Text Sheet. Separate the headers and the company n…

Gо tо the Text Sheet. Sepаrаte the heаders and the cоmpany names and the location of their headquarters in A1:A10 into B1:C10 leaving them as displayed in column A. Answer the following questions about how you completed this: What cells did you select before starting the command? [BLANK-1] What command can you use to separate the words into 3 columns? [BLANK-2] What is the delimiter? [BLANK-3] Separate the labels now but skip the states since not all locations have a state listed. What did you choose to skip the state field? [BLANK-4] Did you fill in anything else in step 3? [BLANK-5]