You are here:

- Home
- Teens
- Homework/Study Tips
- Calculus
- Cell Reference in Excel application.

Advertisement

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

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

- Add to this Answer
- Ask a Question

Rating(1-10) | Knowledgeability = 10 | Clarity of Response = 10 | Politeness = 10 |

Comment | Dear Prof Abe Thank you. Thanks & Regards, Prashant S Akerkar |

Calculus

Answers by Expert:

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!

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