Using formulas, how could I combine text resulting in "Check # 1234 paid 02/15/2013 - pending cash application"? Cell B4 refers to the date.

If you have a worksheet that's several pages long, how can you get the column headers across row 5 to print at the top of each page?

What would the function '=Large(DataRange, 2)' return?

True or False: The SUMIF function adds values in a range that cannot be defined by the user.

What is the function used for removing all non-printable characters from a string in Excel?

Which Excel feature allows a user to split apart values in a text string into separate fields?

The default format for cells that meet a condition with conditional formatting is ____.

You relate tables to one another by using _______ fields.

In producing a newsletter, you should develop ____ with as few words as possible.

____ is extremely useful for making large tables more manageable in size and appearance.

Which of the following is a statistical function? _____