Microsoft Office Tutorials and References

In Depth Information

**APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE**

CEILING(number,signiﬁ cance) [Category: Math]

Returns number rounded up, away from zero, to the nearest multiple of

signiﬁ cance. For example, if you want to avoid using pennies in your prices and

your product is priced at $4.42, use the formula =CEILING(4.42,0.05) to round

prices up to the nearest nickel.

CELL(info_type,reference) [Category: Information]

Returns information about the formatting, location, or contents of the upper-left

cell in a reference. (See page 31)

CHAR(number) [Category: Text]

Returns the character speciﬁ ed by a number. Use CHAR to translate code page

numbers you might get from ﬁ les on other types of computers into characters.

Guru Tip: character 65 is a capital letter A. Character 90 is a capital letter Z. To

ﬁ ll the letters of the alphabet, select cells A1:A26. Type =CHAR(ROW(A65)) and

press Ctrl+Enter.

CHIDIST(x,degrees_freedom) [Category: Statistical]]

Returns the one-tailed probability of the chi-squared distribution. The γ2

distribution is associated with a γ2 test. Use the γ2 test to compare observed

and expected values. For example, a genetic experiment might hypothesize that

the next generation of plants will exhibit a certain set of colors. By comparing the

observed results with the expected ones, you can decide whether your original

hypothesis is valid.

CHIINV(probability,degrees_freedom) [Category: Statistical]]

Returns the inverse of the one-tailed probability of the chi-squared distribution.

If probability = CHIDIST(x,...), then CHIINV(probability,...) = x. Use this function

to compare observed results with expected ones to decide whether your original

hypothesis is valid.

CHITEST(actual_range,expected_range) [Category: Statistical]]

Returns the test for independence. CHITEST returns the value from the chi-

squared (γ2) distribution for the statistic and the appropriate degrees of freedom.

You can use γ2 tests to determine whether hypothesized results are veriﬁ ed by

an experiment.

CHOOSE(index_num,value1,value2,...) [Category: Lookup & Reference]

Uses index_num to return a value from the list of value arguments. Use CHOOSE

to select one of up to 29 values based on the index number. For example, if

value1 through value7 are the days of the week, CHOOSE returns one of the

days when a number between 1 and 7 is used as index_num. See Page 8.

CLEAN(text) [Category: Text]

Removes all nonprintable characters from text. Use CLEAN on text imported

from other applications that contains characters that may not print with your