Cell A1 has the number "3" in it. Cell A2 has the value "5" in it. If you merge these two cells together, what is left in the merged cell?

How do you debug a formula by looking at each part of the formula individually?

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')

The ____ function is useful when you want to assign a value to a cell based on a logical test.

The ____ dialog box provides options for moving charts between worksheets and chart sheets.

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 ____.