Which of the following formulas contains only absolute references?1 point=SUM (A: A)=SUM ($A$1: $A$10)=SUM ($A1: A$10)=SUM (A1:A10)

1. Break Down the Problem

To determine which formula contains only absolute references, we need to identify the type of references in the given formulas.

2. Relevant Concepts

• Absolute Reference: A reference that does not change when the formula is copied to another cell. It is written with dollar signs, such as $A$1.
• Relative Reference: A reference that changes based on the position of the cell in which the formula is copied, such as A1.

3. Analysis and Detail

Let’s analyze each formula:

1. SUM(A:A): This uses a relative reference for the entire column A.
2. SUM($A$1:$A$10): This uses absolute references for both the row and column.
3. SUM($A1:A$10): This has a mix of absolute and relative references (absolute column and relative row, plus absolute row and relative column).
4. SUM(A1:A10): This uses relative references for both the row and column.

4. Verify and Summarize

Only the second formula, SUM($A$1:$A$10), contains only absolute references, as both the row and column are fixed.

Final Answer

The formula that contains only absolute references is: SUM($A$1:$A$10).