CAI 4.01 Functions Basic
About this set
Created by:
tmccall0902 on March 27, 2009
Subjects:
Log in to favorite or report as inappropriate.
Order by
11 terms
Terms | Definitions |
|---|---|
 spreadsheet functions | predefined formulas that perform calculations by using specific values, called arguments, in a specfic order |
| cell reference | indicates a cell's location and provides instructions for how cell data is copied or used in calculations |
| relative cell reference | cell value changes as the formula is copied |
| absolute cell reference | cell value remains static when copied to other locations |
| mixed cell reference | indicates the combination of an absolute cell and a relative cell, such as $A4 |
| parentheses | control the order of operations |
| conditions or criteria | tell the function how to calculate the results and what data to use |
| Sum | adds the range of cells |
| Average (AVG) | determines the average of the range of cells |
| Maximum (MAX) | finds the highest number in the range of cells |
| Minimum (MIN) | finds the lowest number in the range of cells |
First Time Here?
Welcome to Quizlet, a fun, free place to study. Try these flashcards, find others to study, or make your own.
Completed “Learn” mode
TomboyGirl , isjord , The-Brain , paulelgin , Stori , linzbby , QianQian , skippyjr505