What are the meanings of absolute refrences, goal seek and formatting in excel?
I need thе meaning οf thеѕе three things, whаt thеу аrе used fοr аnd thе instructions οf hοw tο υѕе thеm (іn Excel). All аnѕwеrѕ appreciated… Thanks very much !
I need thе meaning οf thеѕе three things, whаt thеу аrе used fοr аnd thе instructions οf hοw tο υѕе thеm (іn Excel). All аnѕwеrѕ appreciated… Thanks very much !
Well how much about Excel do you know?
Cell or Array referance in Excel are of two type 1. Absolute and 2. Relative Referances.
Absolute ranges have a $ character before the address part of the reference at other hand Relative ranges do not use the $ character. in simple words Absolute referances are Fix addresses that do not increment or decrement with the change of formula place. but relative referance are refered in distance with present
There are three absolute styles:
Reference Style Meaning
$A$1 Both the column and row reference are flat. Neither will be incremented or changed during a copy or fill operation.
$A1 Only the column reference is flat. It will not change during a fill or copy, but the row will change.
A$1 Only the row reference is flat. It will not change during a fill or copy, but the column will change.
Relative Reference Style: like if you type =a1 formula in B1 and copy and paste it to b2. the formula automatically will refer to =A1 and if as a replacement for if you copy it on C1 the referance will be B1.
Relative referances refers to R-1,C-1 or R+1,C+1 meance Row and column differance from the present cell.
—————–
goal seek is a very excellent tool provided by excel.
a cell containing a formula that is producing some result performing some calculation on any other cell, but still it is not exect as per your expectation. there you can use the goal seek tool.
like in A1 you have Value 100 and in A2 you have 10
and in A3 you have a formula =A1+A2 (that is resulting 110)
if you want the result 100 then use goal seek
Set Cell [A3] (cell that is containing the formula)
to Value [100] (much loved result)
By changing cell [A1]
(address of the cell that contains constant value on which the formula cell performing calculation. this cell will be changed to produce you much loved result).
Now click on OK and observ that cell “A1″ is automatically has changed to 90 and the Cell A3 has value 100.
you can use this tool to produce your required result in very complex series of formulas also.
(*.*)