- There are two types of replication in Spreadsheets. Name each and describe what happens when a formula is replicated using it
- There are two types of Data Linkage, Static and Dynamic, Describe the difference between the both of them
Remember you are on the internet just now! So there are no excuses for not knowing!
8 comments:
Relative - When you copy a formula from one cell to another the formula changes accordingly to suit.
Absolute - The formula stays the same when copied from one cell to another. This is achieved by putting a dollar symbol in the formula.
Static Linkage is when 2 or more GPP's are linked. A change in one of them would mean a change in the rest.Dynamic linkage is the opposite, a change in one GPP has no effect on the rest.
Absolute is when The formula stays the same when copied from one cell to another. This will happen when a dollar sign ( $ ) is added to the formula .
Relative is when you copy a formula from one cell to another the formula will changes accordingly to suit the cells .
***
With static data linkage if we had to paste something from one ggp to another there will be no change in the original file if we change the file in another ggp . With dynamic if we edit the original document it will automatically update the file in the other gpp .
absoloute and relative
when a formula is replicated absolutely (with dollar signs) there is no change but when it is relative it changes accordingly
When a table is copied from one document toanother , if you change the original and the copy changes it is dynamic if the copy does not change it is static
(:
hollie miller
???
relative and absolute replicating
when changing the formula with relative, the change you make to the chosen formula reflects all the others.
absolute replicating
absolute replicating is the exact opposite of relative. when you change the formula it does not influence others.
Data linkage - static and dynamic
static - this type of data linkage does not change anything else other than the program you are working in.
dynamic - when you change something within one program, the program with the link is then changed also.
Relative Reffrencing - When you copy a formula from one cell to another the formula changes along with it. eg: =sum(a4:f5)
Absolute Reffrencing : The formula stays the same when copied from one cell to another. This is achieved by putting a "$" in the formula. eg : =sum($a$4:$f$5)
Static Linkage is when 2 or more GPP's are linked.
A change in one of them would makes a change in the rest of them.
Dynamic linkage is the opposite, a change in one GPP has no effect on the rest.
Absolute-the formula stays the same when its copied using dollar sign.
relitive-the formula changes when its copied to another cell automatically.
static-linkage is where 2 or more gpps are linkd.
dynamic-?
1. Relative
- When a formula is replicated it changes to suit the cell it is in...
Absolute
- When a formula is replicated it does not change. ( $ is used. )
Static data linkage is when there is no link between 2 or more GPPs.
Dynamic data linkage is when you change something from one GPP it automatically makes the same changes to the other GPP. :]
Post a Comment