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