Correct Answer - Option 2 : B1
A cell reference, or cell address, is an alphanumeric value used to identify a specific cell in a spreadsheet. Each cell address contains 'one or more letters followed by a number. The letter or letters identify the column and the number represents the row. In row-major order, the consecutive elements of a row reside next to each other.
Address of the second cell in an MS-Excel worksheet=?
The letter represents the column, So the second cell in the first row = B
The number represents the row, So the second cell in the first row = 1
Address of the second cell in an MS-Excel worksheet= B1
Hence the correct answer is B1.