Question

How would you refer to the range starting from first column first row and describe till 6th column and 3rd row

Answer 1

Answer:

Range = A1 : F3

Explanation:

A cell reference, or cell address, is an alphanumeric value used to identify a specific cell in a spreadsheet.

Generally rows are defined with numbers while the columns are defined with alphabets and each cell location has a specific column alphabet and row number.

Given the question statement, if we want to define the range of a table from row 1 and column 1(A), till row 3 and column 6 (F) then it can be written in excel as;

Range = A1 : F3