Ang cell reference | Dapat munang alamin

preview_player
Показать описание
The tutorial explains what a cell reference is in Filipino language.
A cell reference, or cell address, is an alphanumeric value used to identify a specific cell in a spreadsheet. Each cell reference contains one or more letters followed by a number. The letter or letters identify the column and the number represents the row.

In a standard spreadsheet, the first column is A, the second column is B, the third column is C, etc. These letters are typically displayed in the column headers at the top of the spreadsheet. If there are more than 26 columns, the 26th column is labeled Z, followed by AA for column 27, AB for column 28, AC for column 29, etc. Column 55 is labeled BA. Rows simply increment numerically from top to bottom starting with "1" for the first row.

Examples of cell references are listed below:

First column, seventh row: A7
Tenth column, twentieth row: J20
Sixty-first column, three hundred forty-second row: BI342
One thousand column, two thousandth row: ALL2000

Cell references are helpful in two ways: 1) They provide an easy way to locate a specific value within a spreadsheet, and 2) they are used in creating formulas.
Рекомендации по теме
Комментарии
Автор

thank you so much kuya ang galing nyo po magturo, aralin ko po muna lahat ng yan, mamaya aaralin po naman ng tutorial nyo sa excel ng incoming grade 7 kong anak. God bless and more power.

cocoskitchen
Автор

Paano brod mag type at maglagay nf mga color sa cel at mag lagay ng boundaries, , paturo nman po pano gumawa ng mga attendace record ng mga workers, parang payroll narin sya
Thank you po

joelcasas