FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
It indicates the location of the active cell, which is the selected cell. It also shows the name assigned to a cell or range of cells. It can be used to navigate to the different cells in your worksheet.
A
Namebox
B
Group
C
Ribbon
D
None of the above
Explanation: 

Detailed explanation-1: -The name box is the box at left end of the formula bar that identifies the selected cell, chart item, or drawing object. The Name Box displays the cell reference of the active cell. The Name Box can also be used to assign names to cells or ranges of cells.

Detailed explanation-2: -Excel allows you to easily see the location of the currently selected cell by examining the contents of the Name Box, to the left of the Formula Bar.

Detailed explanation-3: -The current active cell can be identified as being the one that has a darker black border around it. Also, the active cell reference is listed in the Name Box directly above the spreadsheet’s column headings.

Detailed explanation-4: -Select Using UsedRange Property So the below code would select all the used cells in the active sheet.

Detailed explanation-5: -The name box in the worksheet displays the address of the selected cell.

There is 1 question to complete.
Previous
Next