Lesson#5 Excel Cell Referencing Flashcards
1
Q
How do you normally refer cells in excel?
A
Via the A1 method, columns identified by letters and rows by numbers.
2
Q
What is an alternate way of referencing cells?
A
Via the R1C1 method, first column is 1 and the first row is 1
3
Q
What type of R1C1 reference do you create when using R#C#?
A
Absolute
4
Q
How do you refer to the current cell using R1C1?
A
RC
5
Q
How do you refer to the current row using R1C1?
A
RC#
6
Q
How do you refer to the current column using R1C1?
A
R#C
7
Q
What is the structure of a relative R1C1 reference?
A
R[#]C[#]
