## You are learning Cell Referencing in MS Excel

What happens to formulas with cell references when copied diagonally?

When formulas with cell references are copied diagonally in Excel, their behavior depends on the type of cell references used in the formula:

| Type of Cell Reference | Behavior When Copied Diagonally |

|---|---|

| Relative References | References are adjusted based on the relative change in position. <br> Example: <br> - Formula in A1: '=A1+B1' (adds the values in A1 and B1) <br> - Copied to B2: becomes '=B2+C2' (adjusts to add values in B2 and C2) |

| Absolute References | Absolute references remain unchanged regardless of where the formula is copied. <br> Example: <br> - Formula in A1: '=$A$1+$B$1' (always adds the values in cells A1 and B1) <br> - Copied to B2: remains '=A$1+$B$1' (still refers to A1 and B1) |

| Mixed References | Mixed references (one absolute, one relative) have the absolute part remain unchanged and the relative part adjust based on the copy direction. <br> Example: <br> - Formula in A1: '=A$1+B1' (adds the value in A1 to the value in B1) <br> - Copied to B2: becomes '=A$1+C2' (A1 stays absolute, B1 adjusts to C2) |

| Range References | The entire range reference adjusts based on the diagonal movement. <br> Example: <br> - Formula in A1: '=SUM(A1:B1)' (sums the values in A1 and B1) <br> - Copied to B2: becomes '=SUM(B2:C2)' (sums the values in B2 and C2) |

# This code snippet does not require running or generating any output,

# as it provides a textual explanation

print("When formulas with cell references are copied diagonally in Excel, their behavior depends on the type of cell references used in the formula:")

print("\n1. Relative References:")

print(" - References are adjusted based on the relative change in position.")

print(" - Example:")

print(" - Formula in A1: '=A1+B1' (adds the values in A1 and B1)")

print(" - Copied to B2: becomes '=B2+C2' (adjusts to add values in B2 and C2)")

print("\n2. Absolute References:")

print(" - Absolute references remain unchanged regardless of where the formula is copied.")

print(" - Example:")

print(" - Formula in A1: '=$A$1+$B$1' (always adds the values in cells A1 and B1)")

print(" - Copied to B2: remains '=A$1+$B$1' (still refers to A1 and B1)")

print("\n3. Mixed References:")

print(" - Mixed references (one absolute, one relative) have the absolute part remain unchanged and the relative part adjust based on the copy direction.")

print(" - Example:")

print(" - Formula in A1: '=A$1+B1' (adds the value in A1 to the value in B1)")

print(" - Copied to B2: becomes '=A$1+C2' (A1 stays absolute, B1 adjusts to C2)")

print("\n4. Range References:")

print(" - The entire range reference adjusts based on the diagonal movement.")

print(" - Example:")

print(" - Formula in A1: '=SUM(A1:B1)' (sums the values in A1 and B1)")

print(" - Copied to B2: becomes '=SUM(B2:C2)' (sums the values in B2 and C2)")

# Note: Although the code snippet doesn't explicitly mention it, Excel by default cannot copy diagonally.

# Diagonal copy effects can be achieved using functions like INDEX or OFFSET.

Note: Although the code snippet doesn't explicitly mention it, Excel by default cannot copy diagonally. Diagonal copy effects can be achieved using functions like INDEX or OFFSET.