click below
click below
Normal Size Small Size show me how
Excel Lesson 5
| Term | Definition |
|---|---|
| argument | the value of function uses to perform a calculation, including a number, text, or a cell reference that acts as an operand |
| date and time functions | functions that convert serial numbers to a month, a day, or a year, or that insert the current date or the current date and time |
| financial functions | functions that are used to analyze loans and investments |
| Formula AutoComplete | a tool to help you enter a formula with a valid function name and arguments |
| function | a shorthand way to write an equation that performs a calculation |
| logical function | functions that display text or values if certain conditions exist |
| mathematical functions | functins that manipulate quantitative data in a worksheet |
| statistical functions | functions that are used to describe large quantities of data |
| text functions | functions that are used to format and display cell contents |
| trigonometric functions | functions that manipulate quantitative data in a worksheet |