In the Name Box or by starting the Goto facility by pressing the F5 key and typing into the reference box.
The Name Box. If you type in a cell reference in the Name Box, and press Enter, it will bring you to that cell. You can also press F5 to open the Goto dialog box and use that to go to a particular cell too.
No. You can type directly into a cell too.No. You can type directly into a cell too.No. You can type directly into a cell too.No. You can type directly into a cell too.No. You can type directly into a cell too.No. You can type directly into a cell too.No. You can type directly into a cell too.No. You can type directly into a cell too.No. You can type directly into a cell too.No. You can type directly into a cell too.No. You can type directly into a cell too.
It is a relative cell reference.
It is a relative cell reference.
It is a relative cell reference.
It is a relative cell reference.
It is a relative cell reference.
Cell references are relative references initially, but you can directly type them in as mixed or absolute, so unless you are clicking on a cell or moving to a cell as you type the formula, it is not completely true to say that there is a default reference. There are also a lot of functions that do not use cell references at all.
It is a relative reference.
No, you type formulas either directly into the cell or into the formula bar. You can enter a cell reference like A1:C3 into the name box to select those cells.
It is a relative cell reference.