Nepal Judicial Service2081 BSQuestion 4 of 16
Explain the significance of relative and absolute cell references in electronic spreadsheets. Provide examples of scenarios where each type of reference would be used in formula calculations.
5 marks
Question source
- Exam year
- 2081 BS / 2024 AD
- Level
- Level 4
- Paper
- Subjective
- Section
- Section A: Technical Fundamentals (50 Marks)
Model answer
Relative references (A1) scale dynamically; Absolute references ($A$1) lock fixed rates like tax constants.