Question

How do you refer to the range of cells from 6th row 7th column to 9th column 7th row in MS Excel?​

Answer 1

Answer:

The required range is (F7;I7)

Explanation:

A cell range refers to a single cell or a group of cells.

Range of cell: A collection or a group of two or more cells picked in the same direction is referred to as a cell range. Cell ranges are normally symmetrical, although they can also be made up of individual cells.

A range reference is formed by separating the addresses of the upper left and bottom right cells with a colon.

Suppose your data is in 10 cells and you have to do any operation on it, then you work directly on a range so that all the cell names do not have to be entered separately.

Its notation would be- (F7;I7)

#SPJ3