IDNStudy.com, ang iyong mapagkukunan para sa maaasahan at pangkomunidad na mga sagot. Sumali sa aming platform ng tanong at sagot upang makakuha ng eksaktong tugon sa lahat ng iyong mahahalagang tanong.
[tex]computer[/tex]
1. Cell reference
a. Address of the cell b. Column letter and row number of the cell c. Constant data d. Example: A8
2. Cell referencing
a. Finds the data you want to use in a formula b. Means giving cells a label or an address c. Has three types : relative , absolute and mixed d. Means computing for formulas in a given cell
3. Relative referencing
a. Copies the original formula exactly b. Referring to cells using only their column and row labels C. Cell addresses will be changed relative to the row and column to where they are moved. d. E5=C5+D5 will become E6=C6+D6 when copied from cell E5 to E6.
4. Absolute referencing
a. Means that the formula will not change even after you copy it to another cell b. Used when you want to copy a formula to another cell and you want the cell references to change. C. Copies the original formulas exactly d. Uses dollar signs before the column and row of both cells.
5. Mixed Referencing
a. Used when you want to either the row or column to be absolute b. Uses dollar sign on either a row or column C. E5=C$5+$D5 will become E7=C$5+$D7 when moved from cell E5 to E7. d. Does not use dollar sign
Sagot :
Salamat sa iyong pakikilahok. Patuloy na magbahagi ng iyong mga ideya at kasagutan. Sama-sama tayong magpapaunlad ng isang komunidad ng karunungan at pagkatuto. Ang IDNStudy.com ay nangako na sasagutin ang lahat ng iyong mga tanong. Salamat at bisitahin kami palagi.