0
Each cell on a spreadsheet is unique, as all cells have different cell references. So there is only one cell G4 on a sheet for example. In a formula you can refer to that cell and it will not be confused with any other cell. Cells and cell ranges can be given names, but the same name cannot be used for separate cells or separate ranges.
In a database situation, you can set up fields that cannot have duplicate values. These can be primary keys. If you try and enter the same value again, it will not allow you. This allows you to uniquely identify each record in the database.
An Excel cell reference identifies the location of the cell. It is indicated as an intersection of columns and rows.
EXAMPLE:
The cell in the top left corner is referenced as A1(column A, row 1).
Cells get their names from the column and row they are in. The cell that is where column K meets row 15 is cell K15 for example. Through the Name Manager it is also possible to give a cell a specific name. This can be useful for remembering a cell in a formula. So the cell in which you had calculated a total profit could be given the name Profit and then this could be used as part of a formula. If the profit was in cell K15 and you gave the name Profit to it and you then wanted to multiply it by 10%, then either of these two formulas would work:
=K15 * 10%
=Profit * 10%
Add your answer:
Earn +20 pts
What is the use of name menu in Microsoft Excel?
I am not aware of a name menu in Excel. However, Excel has a name box that displays the name or cell reference of the active cell.
What does excel display in an invalid reference?
If there is an invalid cell reference you will see #REF! in the cell. If you refer to a defined range name that does not exist or a function name that does not exist you will see the #NAME! error.
As you type Excel displays the entry in the and also displays the active cell reference in the name box on the left?
As you type, Excel displays the entry in the FORMULA BAR, and also displays the active cell reference int he Name box on the left.
Where in Excel do you type a cell reference and then move directly to that cell?
In the Name Box or by starting the Goto facility by pressing the F5 key and typing into the reference box.
What is the refernce name of the last cell in the first row in excel 2007?
XFD1 is the cell reference at the end of the first row in Excel. Column XFD is the 16384th column.
What is the cell reference area located below the ribbon?
The cell reference area below the ribbon is called the Name Box in Excel. It displays the address or name of the currently selected cell in the worksheet. It can also be used to navigate to specific cells by typing in the cell reference directly.
Where do you type a cell reference and then move directly to that cell in Excel?
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.
What shows the position of the cell which you have selected in Excel?
You will see it in the Name Box. It will have the cell reference in it, or the name if a cell or range has been named. The header of the current row and current column will also be highlighted.
What are things should be kept in mind while giving the range name in Microsoft Excel?
It should be short and meaningful. It should not be the name of a cell or function in Excel. It should be easy to remember. It should be unique.
How do you know in which cell you are working in excel?
At the top of your worksheet is the formula bar. On the left side of the formula bar is a small window that displays the active cell reference or name.
How do you reference between worksheets in Excel?
You use the name of the sheet, followed by an exclamation mark and then the cell reference. If you were on sheet1 and wanted to refer to cell A2 on Sheet2 and cell A10 on Sheet3, you would do so as follows: =Sheet2!A2 =Sheet3!A10
Can you type formulas into excel name box?
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.
