Person have cloned a cell with a formula to the rows below it, but the copied cells' results are all zeros the reason of this is If an absolute cell reference is required.
Cells are the boxes in an Excel worksheet's grid, such as this one. On a worksheet, each cell is identified by its reference, the column letter, and the row number that intersect at its place.
This cell is known as cell D5 since it is in column D and row 5. In a cell reference, the column always comes first.
Thus, an absolute cell reference is required to check original formula.
For more details about cell in Excel, click here
https://brainly.com/question/917595
#SPJ1
