FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
____ displays the contents of the active cell.
A
Formula bar
B
Name box
C
Scroll bars
D
Worksheet tabs
Explanation: 

Detailed explanation-1: -The correct answer is the Formula bar. The formula bar displays the content of the active cell in MS Excel. The formula bar can be used to edit the content of any cell and can be expanded to show multiple lines for the same formula.

Detailed explanation-2: -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-3: -After typing the formula and pressing the Enter key, the resulting value will be displayed. Formula Bar: The formula bar appears directly above the column headings of a spreadsheet and will display what has been typed into the active cell.

Detailed explanation-4: -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.

There is 1 question to complete.
Previous
Next