Excel Unit B

Fill button list arrow

can be used to fill cels containing formulas going left, right, up, down, and in series

Relative cill reference

changes the cells as you copy and paste them to new locations =sum(b5:E5)

F4

converts a relative cell reference to an absolute cell reference

To copy and move cells use

cut, copy, past, and fill handles

Absolute cell reference

formulas that do not change when copied =$c$12+$d$12

To enter a function

insert funct. Button, use sum list arrow ro use autocomplete

Launcher

item on ribbon that opens a dialog box

Fill handle

lets you copy cell contents or continue a series of data into a range of selected cells

Complex formula

one that uses more than 1 arithmetic operator: (addition and multiplication) =(4+2)*5

Mixed cell reference

part of the formula changes when copied and part does not =$c14+$d14

Functions

predefined worksheet formulas that enables you to perform complex calculations- use insert function button Fx

Standard order of precendence

use these rules in doing complex formulas

Round function

rounds your result- to eliminate many decimals

Auto complete feature

suggests function depending on the first letters you type. -displays list in alphabetical order

Office clipboard

temporary storage area that holds the selections you copy or cut