Several spreadsheet functions can take a comma-separated list of values as their parameters, or instead a range of cells, or an array.
A list may contain cell references and also ranges of cells as one (or more) of their elements.