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?

In the following formula, where is the Table Array located? =VLOOKUP(A5:A19,[RegionalSales]FY2012!$D$2:$J$31,7,FALSE)

The function DAY(date)

Tables are organized into rows, called ____.

The underline format will underline ____

Which of the following is not a date function? ____

You insert a comment in a worksheet by using a command on the ____ tab on the ribbon.

You can split the worksheet window into ____ separate panes.