What does "Merge Cells" do?

Suppose you want VBA to run a loop that will continue until it finds an empty cell. Which of the following will allow you to do this?

The values for A1:A5 are A1=1, A2=3, A3=2, A4=5, A5=4. The formula PERCENTRANK(A1:A5,A2) returns the value:

I have a column of values in ranges A2:A100 that I need to concatenate with the number 2. Which of the following is not a way to do this?

What tab would you use to format a section of text as a table?

What will F11 command do?

Which of the following can be accomplished by Creating Highlighted Cell Rules?

How to change the number of sheets in new workbooks?

Extract word that begins with specific character as following formula?

The following formula uses Get last name from name?

Excel provides the following analysis features for instant data analysis, Choose a True statements?