Which setting indicates that evaluated cells should be highlighted when the formula reference changes, without refreshing?

Which setting indicates that evaluated cells should be highlighted when the formula reference changes, without refreshing?

• A. Retain Formulas in Cube View content
• B. Dynamically Highlight Evaluated Cells
• C. Refers To
• D. Convert XFGetCells

Answer: (B)

The setting is about providing immediate visual feedback of which cells are involved in a formula’s evaluation as you change its references, without needing to refresh. Enabling dynamically highlight evaluated cells makes the grid automatically mark the cells being evaluated and updates that highlighting on the fly as references change, so you can see dependencies and effects in real time. This is why it fits best: it directly controls whether the UI highlights those evaluated cells dynamically, without requiring a refresh. The other options don’t offer this dynamic visual feedback—retaining formulas affects whether formulas stay visible, Refers To relates to what a formula points to, and Convert XFGetCells deals with how cell data is retrieved, none of which implement the on-the-fly highlighting behavior described.

The setting is about providing immediate visual feedback of which cells are involved in a formula’s evaluation as you change its references, without needing to refresh. Enabling dynamically highlight evaluated cells makes the grid automatically mark the cells being evaluated and updates that highlighting on the fly as references change, so you can see dependencies and effects in real time.

This is why it fits best: it directly controls whether the UI highlights those evaluated cells dynamically, without requiring a refresh. The other options don’t offer this dynamic visual feedback—retaining formulas affects whether formulas stay visible, Refers To relates to what a formula points to, and Convert XFGetCells deals with how cell data is retrieved, none of which implement the on-the-fly highlighting behavior described.