FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

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 displays the cell reference of the active cell. The Name Box can also be used to assign names to cells or ranges of cells. To name a cell or range, highlight the cell or range you would like to name, type the name in the Name box, and press ENTER.

Detailed explanation-2: -The active cell is also shown in the top-left portion of the window (Name box), which is “D8” in our example.

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 UsedRange allows you to refer to any cells that have been changed. 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