How do you select noncontiguous cells?

When you write a formula in Excel, the references in the formula are limited to that worksheet only.

Column A contains an apartment number, column B is the street number, and column C contains the street name. I would like all these values to be in the same cell; what function could I use to accomplish this?

If you want to enter the days of the week across a row, how can you save a lot of typing?

A formula with brackets such as {sum((C2:C1)*(D2:D11))} is called:

Function used to join several text strings to one is:

The general form of the vlookup function is ____

The countif function is sometimes referred to as a(n) _____ count.

The ________ function returns one value if a condition is met, and a different value if it is not.

The ____ of a cell determines how the labels and values look.

Spreadsheets are particularly useful for ____.