IDNStudy.com, ang perpektong platform para sa eksaktong at mabilis na mga sagot. Hanapin ang mga solusyong kailangan mo nang mabilis at madali sa tulong ng aming mga eksperto.
[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 :
Ang iyong kontribusyon ay napakahalaga sa amin. Huwag kalimutang bumalik upang magtanong at matuto ng mga bagong bagay. Sama-sama tayong magpapaunlad ng kaalaman para sa lahat. Para sa mga de-kalidad na sagot, piliin ang IDNStudy.com. Salamat at bumalik ka ulit sa aming site.