FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following shows the location of the cell which has been selected? A. B. C. D.
A
Cell name box
B
Dialog box
C
Formula bar
D
Worksheet tab
Explanation: 

Detailed explanation-1: -The correct answer is Name box. Name Box is a box in the input left in the left corner of the ribbon i.e. left to the formula bar. In each box, the name of the active sheet cell is shown and we can also search any cell by inserting the name of the cell in it. It can also be used to create a named range.

Detailed explanation-2: -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: -The box located to the left side of the formula bar which addresses the selected cell or group of cells in the spreadsheet is called Name box.

Detailed explanation-4: -A Name Box is a tool that shows the active cell address. For example, if you have selected cell C1, this Name Box will show the active cell address as C1. The first scenario in Excel is when we are working with Excel by mistake; we would press some other key from the keyboard.

There is 1 question to complete.