Makahanap ng mga solusyon sa iyong mga problema gamit ang IDNStudy.com. Magtanong at makatanggap ng eksaktong sagot mula sa aming mga bihasang miyembro ng komunidad.
[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 :
Pinahahalagahan namin ang bawat ambag mo. Magpatuloy sa pagtatanong at pagbibigay ng mga sagot. Sama-sama tayong magtutulungan upang makamit ang ating mga layunin. Salamat sa pagpili sa IDNStudy.com. Umaasa kami na makita ka ulit para sa mas maraming solusyon.
