Cell A1 contains "Chang", and cell A2 contains "Pie". What is the result of the formula: =CONCATENATE(A1," ","and"," ",A2)

What does the VALUE function do?

Let's say your workbook has 5 worksheet tabs, and you want to group only the 1st, 3rd, and 5th sheets. How can you do this?

Which formula will provide the same result as the following: =CONCATENATE('Smarter','er')

Cell A2 has the name DAVID HAWLEY in it. Which formula extracts the first name from the cell?

How do you generate random numbers 1-100?

The ____ criteria filter requires the records displayed to have the current date.

The ____ aggregate function finds the largest value.

Tables are organized into rows, called ____.

The underline format will underline ____

Which of the following is not a date function? ____