Self-reference for cell, column and row in worksheet functions

Question

In a worksheet function in Excel, how do you self-reference the cell, column or row you're in?

Answer 1

where F13 is the cell you need to reference:

=CELL("Row",F13)  yields 13; its row number

=CELL("Col",F13)  yields 6; its column number;  

=SUBSTITUTE(ADDRESS(1,COLUMN(F13)*1,4),"1","") yields F; its column letter