Which among the following is a valid cell address in MS-Excel?

Question

Accepted Answer

The correct option is (3):
A cell address in MS-Excel uses the A1 reference style by default, which is the universally accepted standard. This format requires the column letter(s) to be written first, immediately followed by the row number, with absolutely no spaces or special characters in between. The option **D6** perfectly conforms to this standard: 'D' is a valid column identifier, and '6' is a valid row identifier. The combination 'D6' thus uniquely and correctly identifies the single cell located at the intersection of column D and row 6, which is the definition of a valid cell address.

The incorrect option is (1): A:20.
This option is invalid because of the colon (:) operator. In Excel, the colon is specifically used to denote a range of cells, for example, 'A1:A20' refers to all cells from A1 through A20. It is not used to represent a single cell address. A single cell address must directly combine the column letter and row number without any special characters or operators.

The incorrect option is (2): B 15.
This address is invalid due to the presence of a space between the column letter 'B' and the row number '15'. Cell references in MS-Excel must be contiguous; no spaces or other separating characters are permitted within the address of a single cell. Introducing a space violates the fundamental syntax of the A1 reference style.

The incorrect option is (4): 10H.
This option inverts the standard convention of the A1 reference style. Excel's standard requires the column letter(s) to precede the row number, as in 'H10'. By placing the row number (10) before the column letter (H), the address '10H' becomes syntactically invalid under the A1 style. While Excel does support an R1C1 style, '10H' does not conform to that alternate notation either.