Cells and ranges in a worksheet can be formatted ____.

In the formula =int(average(a1:a100)), which would occur first? ____

Spreadsheets are particularly useful for ____.

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

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

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

If cell A1 contains the value '32.96' and you format the cell to show only 1 decimal place, which value is displayed?

Function used to join several text strings to one is:

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

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

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?