Unit B Excel Flashcards
complex formula
one that uses more than 1 arithmetic operator
standard order of precedence
uses these rules in doing complex formulas.
functions
predefined worksheet formulas that enable you to perform complex calculations - use insert function button Fx
auto complete features
suggests function depending on the first letters you type
to copy and move cells use
cut, copy, and paste, and fill handles.
office clipboard
temporary storage area that holds the selections you copy out
relative cell reference
changes the cell as you copy and paste them to new locations
round function
rounds your result - to eliminate many decimals
launcher
item on ribbon that opens a dialog box
fill handle
lets you copy cell contents