You are here:

Geometry/Cell Reference in Excel application.

Advertisement


Question
QUESTION: Dear Prof Azeem

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: Hi Prashant,

The current convention is preferred by most people.  Data is typically arranged in rows, then columns.  In many other contexts, the convention is "horizontal, then vertical," and Excel is in line with that.  I do not see any positive impact of indexing cells column-row.

Thanks for asking,
Azeem

---------- FOLLOW-UP ----------

QUESTION: Dear Prof Azeem

Thank you.

Example
-------

A1=3
R1C1=3

if i say 1A=3, can it impact other excel features viz formulas, creating charts,pivot table etc ?.


if it doesn't impact
other excel features, we can say
A1=R1C1=1A=3.


Awaiting your reply,

Thanks & Regards,
Prashant S Akerkar

Answer
Hi Prashant,

A1=R1C1=1A=3.
The letter always refers to the row and the number always refers to the column, but this is still a dangerous thing to do.  Not wrong, but dangerous.  Either way, there is still a convention that must be remembered (letter for column, number for row), so we might as well all just stick with row-column as usual.


Regards,
Azeem

Geometry

All Answers


Answers by Expert:


Ask Experts

Volunteer


Azeem Hussain

Expertise

I welcome your questions on algebra, 2D and 3D geometry, parabolic functions and conic sections, and any other mathematical queries you may have.

Experience

4 years as a drop-in and by-appointment tutor at Champlain College. Private tutor for dozens of clients over the past 8 years.

Publications
CALPHAD: Computer Coupling of Phase Diagrams and Thermochemistry

Education/Credentials
Bachelor of Science, Major Mathematics and Major Economics, McGill University, 2014. Diploma of Collegiate Studies; Pure and Applied Science, Champlain College Saint-Lambert, 2010.

©2016 About.com. All rights reserved.