Question

what are the two ways of referencing cells in other worksheets​

Answer 1

Answer:

Absolute and Relative References Are the two ways of referencing cells in other worksheets

Answer 2

The two ways of referencing cells in other worksheets​ are as follows:

• Relative references and Absolute references are used in referencing cells.
• Relative references are the point to a cell which is based on its position relative to the current cell.
• The absolute references point to a cell which directs to an exact location.
• However, cell referencing refers to a cell or a range of cells on a worksheet.
• It can be used in a formula so that Microsoft Office Excel can find the values or data that users want to calculate.
• It is also known as the cell's address and identifies a cell or range of cells.
• For example, A1 refers to the cell at the intersection of column A and row 1.

#SPJ3