Question

In excel which ome denotes the range of A1 to D6

Answer 1

Answer:

• Select the range for which you want to create a Named Range in Excel.
• Go to Formulas –> Define Name.
• In the New Name dialogue box, type the Name you wish to assign to the selected data range. ...
• Click OK.

Answer 2

In a cell range the denotion of A1 to D6 is represented.

Definition of cell range;

• The cell range is represented in the excel file. It is showed in the spreadsheet in reference to the upper left cell (minimum value) and the lower right cell (maximum value).
• They are used to create a graph, or used to bookmark data.

Representation of A1 to D6;

• These upper left cell and the lower right cell of the range are added in the table or spreadsheet. The ranges called as irregular cell range.
• The columns shows the letters (A,B,C,D) and rows by the numbers (1,2,3,4,5) and so on.
• The A1 reference style represents the beginning columns with letters  D6 refers to the sixth row of column.

To select a cell;

1. Click a cell to select it.
2. A border will appear the at the selected cell, with the representation of column heading and row heading with the highlighted portion.

To select a cell range;

1. Click and drag the mouse till the adjoining cells get selected.
2. Release the mouse too select the particular cell you want. The cell will remain selected until the another cell you selects.

Therefore, the A1 TO D6 represents the desired cell range that is columns and rows denotes the letters and numbers.