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

Go to the Text Sheet. Separate the headers and the company 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]

Start the IF in cell G11 to check if the job status is FT.  …

Start the IF in cell G11 to check if the job status is FT.  FT is in the input cell F4.  If it is, the VLOOKUP should find the percent of the raise they will earn in the VLookup Values Table.  If the job status is not FT, the IF should leave the cell looking empty. Multiply the salary by the percent found with the Vlookup function to compute the salary with the raise. Make sure to do the math to compute the new raise in the correct place. Fill in all 4 arguments for the VLOOKUP function. Paste your function in the blank: [BLANK-1]

Enter a function in B7 on the Birthday sheet to compute how…

Enter a function in B7 on the Birthday sheet to compute how much will have accumulated by Tina’s 20th birthday if her mother invested $1,000 for her on her birthday each year starting on her 3rd birthday. The annual interest rate is 6.25%. Use the input cells in B3:B5. Paste the function in the blank. [BLANK-1]

On the Choose sheet, Enter a combination of two functions in…

On the Choose sheet, Enter a combination of two functions in E1 that will return values between 0 through 15 when generating random whole numbers. You want a potential 0 and a 15. One of the functions should be the integer function.   You will not get any credit for using the Randbetween function. You can copy the function down and over F1 through M10 to see if you get a 0 and a 15. Paste your function in the blank. [BLANK-1]