Cinta

"CINTA yang dibina bukan cinta kosong tapi cinta yang punya pengertian
cinta yang luhur dan hanya dapat dirasakan dengan JIWA yang bersih
yang SENTIASA MENCARI..... ALLAH"

Biarkan waktu berputar seiring waktu berjalan

Biarkan waktu berputar seiring waktu berjalan

Istiqomah

Daisypath Anniversary tickers

AH

Daisypath Anniversary tickers

Daughter

Lilypie Pregnancy tickers

BF

Lilypie Breastfeeding tickers

Thursday, 31 March 2011

Absolute and Relative References

Salam.

This is my second post; I would like to share with those all of you about what I have learned in CSC134.

Absolute and Relative References

1.    Absolute References

-       Using absolute reference means that the formula always refers to a specific cell. 
-       Regardless whether you copy the formula across rows or down columns, the absolute reference does not change.
-       Symbol $, example: $A$2.  A is the cell and 2 is the number of cell.

2.    Relative References

-       Based on the relative position of the dependent cell and the cell the references refer to.
-       So, if you copy the formula across rows or down columns, the reference automatically adjusts.

Example: A2*B1

Absolute and Relative References used in Microsoft Office Excel for office purposes.  If there any question you like to ask about this post, do comment this post.  Thank you and do follow me for the next post.



Wassalam.

No comments:

Post a Comment