FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which area, on the left side of the formula bar, can you look at to determine the cell address of a selected cell?
A
Cell box
B
Address box
C
Name box
D
None of the above
Explanation: 

Detailed explanation-1: -Explanation: In Microsoft Excel, the Name Box is the box to the left of the formula bar that displays the cell that is currently selected in the spreadsheet.

Detailed explanation-2: -These two references are separated by a colon ( : ) which tells Excel to include all the cells between these start and end points. 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.

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

Detailed explanation-4: -The name box in excel is located on the left side of the excel window and it is used to give a name to a table or any cell, for any normal cells by default the name is the row character and the column number such as cell A1.

There is 1 question to complete.