Calculus/Cell Reference in Excel application.
Dear Prof Abe
Cell Reference is intersection of column,row where data is to be inserted in the cell.
For example : A3 Cell data is 5. Now A3 cell is column 1 and row 3.
Instead of addressing a cell as columnrow i.e. A3 would we had use addressing a cell as rowcolumn, it would have become 3A. Now 3A=5.
In this case, the cell reference is 3A, now if this convention had
been applied instead of the columnrow convention for cell representation, would it had impacted other excel features ?.
Examples : 5C, 4B, 9R instead of C5,B4,R9 respectively.
The Matrix form representation is m rows * n columns.
Example : The notation of a 3 * 2 matrix : A[3,2] where number of
rows = 3 and number of columns = 2. There are total six elements in the matrix. A[2,3] matrix will be 2 rows and 3 columns with number of six elements in the matrix.
In excel, cell representation is A3 where A = Column name and 3 = row number and not 3A. i.e. ColumnRow and not rowcolumn convention.
In this case, the cell reference is 3A, now if this convention had been applied instead of the columnrow convention, a rowcolumn convention for cell representation, would it had impacted other excel features ?.
if i write 3E instead of using E3 and R3C5 cell references
Is 3E=E3 ?
Awaiting your reply,
Thanks & Regards,
Prashant S Akerkar
The cell references are simply a matter of definition...someone's or group's personal
preference. With matrices in mathematics, we use "m x n" to refer "m rows" and "n columns."
So there it is "row" by "column" rather than the reverse way. Sure, if we switch things
there, we would need to modify all other references to rows and columns when identifying
a particular element. But all results would still work out the same (in the end).
Imagine if we read English from right to left instead of left to right. It would certainly
change how we read (and how reading material is assembled), but the content would be