FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

WORKBOOK THEMES

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Where is a name box and what does it do?
A
It is a box to the right of the formula bar that displays the cell that is currently selected in the spreadsheet.
B
It is a toolbar at the top of MS Excel spreadsheet .window that you can use to enter or copy an existing formula into the cells or charts.
C
It is a box to the left of the formula bar that displays the cell reference of the cell that is currently selected.
D
It is a single spreadsheet that contains cells organized by rows and columns.
Explanation: 

Detailed explanation-1: -In Microsoft Excel, the Name Box displays the cell that is currently selected in the spreadsheet. It is located to the left of the formula bar. If a name is defined for a cell that is selected, the Name Box displays the name of the cell. You can use the Name Box to define a name for a selected cell, as well.

Detailed explanation-2: -Define a name for a cell or cell range on a worksheet Select the cell, range of cells, or nonadjacent selections that you want to name. Click the Name box at the left end of the formula bar. Type the name you want to use to refer to your selection.

Detailed explanation-3: -The box located to the left side of the formula bar which addresses the selected cell or group of cells in the spreadsheet is called Name box.

Detailed explanation-4: -What Is The Name Box? The Name Box has several functions. It displays the address of the active cell. It displays the name of the cell, range or object selected if this has been named. It can be used to name a cell, range or object like a chart.

Detailed explanation-5: -Expert-Verified Answer The Name Box displays the cell and Formula bar is used to see the formulas. Explanation: The Name Box indicates the cell actually picked in the spreadsheet. It is situated at the left hand side of the formula sign.

There is 1 question to complete.