How can we help?

You can also find more resources in our Help Center.

CBA CHS Lesson 5

STUDY
PLAY
Argument
The value the function uses to perform a calculation, including a number, text, or a cell reference that acts as an operand (EX 105).
Date and time functions
Functions that are used to insert dates and times in a worksheet (EX 118).
Financial functions
Functions used to analyze loans and investments (EX 114).
Formula AutoComplete
As you begin to type a function name, this feature shows a list of functions below the active cell (EX 108).
Function
Shorthand way to write an equation that performs a calculation (EX 105).
Logical functions
Functions that display text or values if certain conditions exist (EX 117).
Mathematical functions
Functions, such as the square root and rounding functions that manipulate quantitative data in a worksheet (EX 109-110).
Statistical functions
Functions used to describe large quantities of data (EX 112).
Text functions
Functions that are used to format and work with cell contents (EX 119).
Trigonometric functions
Functions, such as the natural logarithm, that manipulate quantitative data in a worksheet (EX 109-110).