# Formulas and cell references

> An expression in a spreadsheet cell that calculates a result.

Course: [Spreadsheet skills](https://studybrix.com/en/courses/spreadsheets/index.md)
Level: university
Prerequisites: Basic arithmetic and computer literacy.

## Notes

### Formula

An expression in a spreadsheet cell that calculates a result.

### Cell reference

An address identifying a worksheet cell.

### Relative reference

A reference that adjusts when a formula is copied.

### Absolute reference

A reference fixed to a location when copied, often marked with dollar signs.

## Practice questions

### 1. Which term best matches this description: An expression in a spreadsheet cell that calculates a result.

A. Absolute reference
B. Relative reference
C. Cell reference
D. Formula

Answer: Formula

Explanation: Formula is the matching concept in this lesson.

### 2. Which term best matches this description: An address identifying a worksheet cell.

A. Formula
B. Cell reference
C. Absolute reference
D. Relative reference

Answer: Cell reference

Explanation: Cell reference is the matching concept in this lesson.

### 3. Which concept would you apply first in a situation where a reference that adjusts when a formula is copied.

A. Formula
B. Cell reference
C. Absolute reference
D. Relative reference

Answer: Relative reference

Explanation: The scenario directly calls for Relative reference.

### 4. Name the concept described as: A reference fixed to a location when copied, often marked with dollar signs.

Answer: Absolute reference

Explanation: The intended concept is Absolute reference.

### 5. Which statement about Formula is most accurate?

A. An expression in a spreadsheet cell that calculates a result.
B. An address identifying a worksheet cell.
C. A reference that adjusts when a formula is copied.
D. A reference fixed to a location when copied, often marked with dollar signs.

Answer: An expression in a spreadsheet cell that calculates a result.

Explanation: The definition in the lesson notes gives the required condition.

### 6. Explain one important difference between Formula and Cell reference.

Sample answer / marking guidance: Formula: An expression in a spreadsheet cell that calculates a result. Cell reference: An address identifying a worksheet cell.

Explanation: Credit a clear distinction using both definitions and an appropriate example if supplied.

### 7. Give a short example showing how Relative reference would be used in practice.

Sample answer / marking guidance: A valid example should demonstrate this idea: A reference that adjusts when a formula is copied.

Explanation: Credit a relevant scenario that applies the concept rather than merely naming it.

### 8. Summarize why Absolute reference matters in the lesson “Formulas and cell references”.

Sample answer / marking guidance: Absolute reference matters because A reference fixed to a location when copied, often marked with dollar signs.

Explanation: Credit the core purpose, scope and any important limitation from the notes.

## Further reading

- https://support.microsoft.com/excel

Original AI-assisted educational draft; not independently teacher-reviewed. References support further study, not copied exercises, affiliation or curriculum accreditation.