JAMB - Computer Studies (2024 - No. 50)
What is the advantage of using cell references in formulas compared to entering constant values?
Cell references improve formula accuracy by reducing manual data entry.
Cell references make formulas less flexible and adaptable to changes.
Cell references make formulas more complex and difficult to understand.
Cell references are only necessary for complex formulas with multiple functions.
Explanation
Cell references are crucial for maintaining dynamic formulas. When a value in a referenced cell changes, the formula automatically recalculates the result based on the updated data. This saves time and reduces errors compared to manually entering constant values within the formula itself.
Comments (0)
