Tóm tắt:
|
Naming Cells and Ranges.When entering formulae or referring to any area in a workbook, it is usual to refer to a ‘range’. For example, B6 is a range reference; B6:B10 is also a range reference. One problem with this sort of reference is that it is not very meaningful and therefore easily forgettable. If you want to refer to a range several times in formulae or functions, you may find it necessary to write it down, or select it, which often means wasting time scrolling around the workbook.
|