Question

Good Morning


What is absolute Reference​

Answer 1

Answer:

good morning

When relative cell references are copied to more than one row or column, they change depending on their position, which is useful for performing the same calculation in each row or column.

In contrast, the definition of absolute cell reference is one that does not change when it’s moved, copied or filled. This way, the reference points back to the same cell, no matter where it appears in the workbook. It’s indicated by a dollar sign in the column or row coordinate.

Explanation:

please mark me as brainliest and thanks all my answers

Answer 2

Explanation:

In contrast, the definition of absolute cell reference is one that does not change when it's moved, copied or filled. This way, the reference points back to the same cell, no matter where it appears in the workbook. It's indicated by a dollar sign in the or row coordinate.

more information:

To create an absolute reference in Excel, add a dollar sign before the row and column. For example, an absolute reference to A1 looks like this:

=$A$1

An absolute reference for the range A1:A10 looks like this:

=$A$1:$A$10

Example

In the example shown, the formula in D5 will change like this when copied down column D:

=C5*$C$2

=C6*$C$2

=C7*$C$2

=C8*$C$2

=C9*$C$2

Note that the absolute reference to C2, which hold the hourly rate does not change, while the reference to hours in C5 changes with each new row.

ask a mod or unblock from website