DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Name Box
|
|
|
Formula Bar
|
|
|
Both A and B
|
|
|
None of the above
|
Detailed explanation-1: -Explanation: The present cell address in Excel is displayed in the Name Box. The formula bar’s left side is where this Name Box is situated in Excel. In Excel, this particular option is used for displaying the cell which is at the moment selected by the user in the spreadsheet.
Detailed explanation-2: -Detailed Solution. The address of the Current Active Cell is displayed in the Cell Name box. Data or Formula of Current Active Cell can be viewed inside the Cell Contents box of the Excel Formula bar.
Detailed explanation-3: -The correct answer is the Formula bar. The formula bar displays the content of the active cell in MS Excel.
Detailed explanation-4: -The formulas bar, sometimes called fx bar, displays text or number data in active or current cells, formulas in an active cell or range of cells in place of a selected data series in an Excel chart.
Detailed explanation-5: -Excel Formula Bar is a thin bar below the ribbon that displays the selected cell’s content and displays the cell address of the selected cell on the left side. You can also enter a value into the cell from the formula bar. It has three buttons (Enter, Cancel, and Insert a Function).