Question

where is the adress of the active cells displayed in an active worksheet​

Answer 1

Answer:

Address of Current Active Cell is displayed in Cell Name box. 2 - Data or Formula of Current Active Cell can be viewed inside Cell Contents box of Excel Formula bar.

Explanation:

hope it helps

Answer 2

Answer:

HERE IS YOUR ANSWER

Explanation:

All the cells on a worksheet are separated by grey lines, known as gridlines and a group of adjacent cells is known as a Range of cells.

There are three types of cell reference operator that can be used to identify cells and ranges. The colon, comma and the space.

Colon ( : ) - This is used to define a range of cells (e.g. "A1:D4"). A range of cells is described in terms of the top left cell and the bottom right cell references separated by a colon.

Comma ( , ) - This is used to define non adjacent cells (e.g. "A1", "B2"). The comma is also known as the union operator.

Space ( ) - This is used to combine the intersection of two blocks of cells (e.g. "A1:D4 B2:C3"). When you use this operator the two blocks of cells must overlap. If not then an error message will appear. The space is also known as the intersection operator.

Multiple cell ranges are commonly known as non adjacent or non contiguous ranges. These are ranges of cells that are not in a nice rectangular block.

PLEASE MARK ME AS BRAILIEST AND RATE ME AND ALSO LIKE MY ANSWER AND ALSO FOLLOW ME FOR MORE ANSWERS OF YOUR ALL QUESTIONS......