You are here:

Calculus/Cell Reference in Excel application.

Advertisement


Question
Dear Prof Abe

http://en.wikipedia.org/wiki/Microsoft_Excel‎
http://en.wikipedia.org/wiki/Matrix_(mathematics)‎

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 ?.


Example :

E3=7
R3C5=7
E3=R3C5

if i write 3E instead of using E3 and R3C5 cell references
saying 3E=7

Is   3E=E3 ?
    3E=R3C5 ?

Awaiting your reply,

Thanks & Regards,
Prashant S Akerkar

Answer
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
identical.

See?

Abe

Calculus

All Answers


Answers by Expert:


Ask Experts

Volunteer


Abe Mantell

Expertise

Hello, I am a college professor of mathematics and regularly teach all levels from elementary mathematics through differential equations, and would be happy to assist anyone with such questions!

Experience

Over 15 years teaching at the college level.

Organizations
NCTM, NYSMATYC, AMATYC, MAA, NYSUT, AFT.

Education/Credentials
B.S. in Mathematics from Rensselaer Polytechnic Institute
M.S. (and A.B.D.) in Applied Mathematics from SUNY @ Stony Brook

©2016 About.com. All rights reserved.