Microsoft Office Tutorials and References

In Depth Information

**APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE**

COLUMN(reference) [Category: Lookup & Reference]

Returns the column number of the given reference. Guru Tip: Writing

=COLUMN(B1) is a great way to write the number 2. This is particularly handy

when you have to use a similar VLOOKUP to return the 2nd, 3rd, … 12th

columns from a lookup table. Rather than hard-coding 2 as the 3rd argument

in the VLOOKUP, specify COLUMN(B1). As you copy this formula to the right,

the reference will automatically update to return COLUMN(C1) which is 3, then

COLUMN(D1) which is 4, and so on.

COLUMNS(array) [Category: Lookup & Reference]

Returns the number of columns in an array or reference.

COMBIN(number,number_chosen) [Category: Math]

Returns the number of combinations for a given number of items. Use COMBIN

to determine the total possible number of groups for a given number of items.

Guru Tip: You can ﬁ gure out the probability of your state lottery game using

COMBIN. If your lotto drawing draws 6 numbers from a pool of 40 numbers, use

=COMBIN(40,6) to show you that there are 3.8 million combinations.

COMPLEX(real_num,i_num,sufﬁ x) [Category: Engineering]*

Converts real and imaginary coefﬁ cients into a complex number of the form x +

yi or x + yj.

CONCATENATE(text1,text2,...) [Category: Text]

Joins several text strings into one text string. Guru Tip: Jeff Bissell notes that

you can also use the ampersand to join text together: =A2&B2&C2 is equivalent

to =CONCATENATE(A2,B2,C2).

CONFIDENCE(alpha,standard_dev,size) [Category: Statistical]]

Returns the conﬁ dence interval for a population mean. The conﬁ dence interval

is a range on either side of a sample mean. For example, if you order a product

through the mail, you can determine, with a particular level of conﬁ dence, the

earliest and latest the product will arrive.