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