FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

MODIFYING PAGE SETUP PROPERTIES IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The contents of the active cell, or its formula is always displayed in the ____
A
Namebox
B
Formula Bar
C
Column
D
Column
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 formula bar in Excel is located next to the name box and above the worksheet area. It displays the data stored in the active cell. The formula bar is used to view, enter, and edit values and formulas in cells. A spreadsheet formula is a mathematical equation that will calculate a result.

Detailed explanation-3: -In Excel, the Name Box refers to an input box directly to the left of the formula bar. The Name Box normally displays the address of the “active cell” on the worksheet. You can also use the name box to quickly create a named range. Another use for the Name Box is to navigate quickly to any range in a worksheet.

Detailed explanation-4: -Explanation: Name Box refers to an input box directly to the left of the formula bar. The Name Box normally displays the address of the “active cell” on the worksheet.

There is 1 question to complete.
Previous
Next