Objectives Create a complex formula, insert a function,type a function, copy and move cell entries understand relative and absolute cell references, unCopy formulas with relative cell references,
Cop y formulas wit habsolurte cell referenfes , Round a value with a function.



Video 2 notes. Microsoft® Office 2007 - Illustrated Introductory Windows Vista Edition by
A complex formula is a formula that uses more than one operator.
*Can be used to calculate revenue.
*Adding sums and perecents of sums.

Adding a total to itself and then multiplying by .2 for a 20% increase.

In formulas containing more than one operator,Excel uses the standard order of precedence rules to determine which operator to use first.
Calculations in parentheses()
Reference operators : ,
Exponents

Addition and subtraction
Left to right for more than one of the same kind.
One change change order of predence through parenthesis  around part you want to calculate first.
*Adjust formula
Click to add cell with tab.
Editing group from home tab , fill button right to to fill formulas to the right with the formula in the active cell.(Drag the highlight from active cell to cells you wish to fill horizontall/vertically/

Inserting a function.
A function is a predefined worksheet formula.
Insert  function dialogue box gives you access to all available functions and walks you through the process of supplying all the necessary information
The dialogue box inserts  the equal sign for you because you need the equal sign no matter what type of formula is created.
Average>Function Arguments
Number 1 Field:Collapse Button>Minimizes dialgoue box>+(white) pointer drag to select range.
Release mount button>Restore dialogue box. All values you want to average are in the number 1 text field, click OK to confirm.
Autosum button list arrow in editing group on the home tab is a quickhand way to insert functions.

+ white(pointer ) drag after Average is selected from the list than Enter to have the calculated data appear.

Fill allows formulas to be copied down or up from a cell or left or right.


Type a Function:
Click Cell>Type = > Autocomplete displays list of fu nctions>Click MAX>Description from screentip shows>Double-Click MAX and then select range and then type enter to display desired Function calculation.

Minimum replace above instruction with minimum
^Autocomplete functions tutorial * Name and Intial characters of a function allows you to ulilize this feature for manually typing functions. Just type a letter after equals.

Selecting a range that contains two formulas will apply fill with the corresponding direction.
Right direction, in this case, so if the fill button will not confuse the two formulas in these cases.

Copying and Moving Cell Entries
1. Select a range, click copy in clipboard group on the home tab.(B3:E3 copied and pasted in B19
2. Click launcher in the clipboard group, click desired cell(B19 in this case)( Launcher shows what is in the clipboard currently,
3.Delete Copied data in cells b13:e13(Automatically placed in appropriate cells prior.)
You can paste as many times as you like as long as the item is in the clipboard.

Clicking clipboard contents in clipboard launcher will post onto active cell.

Hitting Ctrl while the




Select a function list sorted by category.
EX: Financial , date and time, statistical, etc.

Insert Function Button is on formula bar >Insert Function dialogue box