to allow excel to change the cell references in a formula or function from row to row or column to column as you fill with it, you must use an formula cells.
You must utilize a cell formula to allow excel to modify the cell references in a formula or function between row to row or column to column as you fill it out.
A cell reference is a name for a cell or a group of cells on a worksheet that may be used in a formula to tell Microsoft Office Excel where to look for the values or data that the calculation should compute.
The cell function in Excel returns data about a cell in a spreadsheet. info type specifies the type of information to be returned.
Cell may obtain information such as the cell's address and filename, as well as specific information about the cell's formatting.
Find out more information about 'Cell formula'.
https://brainly.com/question/26988565?referrer=searchResults
