Cell range excel is represented by using which sign
Answers
Answered by
2
A range is a group or block of cells in a worksheet that has been selected or highlighted. When cells have been selected they are surrounded by an outline or border
By default, this outline or border surrounds only one cell in a worksheet at a time, which is known as the active cell. Changes to a worksheet, such as data editing or formatting, by default, affect the active cell.
When a range of more than one cell is selected, changes to the worksheet – with certain exceptions such as data entry and editing – affect all cells in the selected range.
Contiguous and Non-contiguous Ranges
A contiguous range of cells is a group of highlighted cells that are adjacent to each other, such as the range C1 to C5 shown in the image above.
A non-contiguous range consist of two or more separate blocks of cells. These blocks can be separated by rows or columns as shown by the ranges A1 to A5 and C1 to C5.
Both contiguous and non-contiguous ranges can include hundreds or even thousands of cells and span worksheets and workbooks.
Naming a Range
Ranges are so important in Excel and Google Spreadsheets that names can be given to specific ranges to make them easier to work with and reuse when referencing them in such things as charts and formulas.
By default, this outline or border surrounds only one cell in a worksheet at a time, which is known as the active cell. Changes to a worksheet, such as data editing or formatting, by default, affect the active cell.
When a range of more than one cell is selected, changes to the worksheet – with certain exceptions such as data entry and editing – affect all cells in the selected range.
Contiguous and Non-contiguous Ranges
A contiguous range of cells is a group of highlighted cells that are adjacent to each other, such as the range C1 to C5 shown in the image above.
A non-contiguous range consist of two or more separate blocks of cells. These blocks can be separated by rows or columns as shown by the ranges A1 to A5 and C1 to C5.
Both contiguous and non-contiguous ranges can include hundreds or even thousands of cells and span worksheets and workbooks.
Naming a Range
Ranges are so important in Excel and Google Spreadsheets that names can be given to specific ranges to make them easier to work with and reuse when referencing them in such things as charts and formulas.
Similar questions