OneStream Certified Associate (OCA) Practice Exam

What happens when choosing to dynamically highlight evaluated cells when adding a Cube View Connection?

This option auto-resizes column widths based on the settings from the Cube View users choose This option will highlight a cell if the formula reference has changed without having to refresh a Spreadsheet This option allows users to enter formulas in the Cube View and retain those formulas pre-submission and post-submission of the sheet or workbook This option will remove all formatting on add

Correct Answer:

This option will highlight a cell if the formula reference has changed without having to refresh a Spreadsheet

Explanation:

When you enable dynamic highlighting for evaluated cells with a Cube View Connection, the worksheet visually marks cells whose formula references to the cube data have changed. This means you can see, in real time, which cells have recalculated because the underlying cube values changed, without needing to manually refresh the spreadsheet. This immediate visual cue helps you verify data updates and track how the Cube View affects results as soon as changes occur. The other options describe unrelated features—auto-resizing column widths, entering and retaining formulas through submissions, or removing formatting—which don’t provide the live indication of changed formula references that this highlighting offers.

Access more questions from this quiz

Continue to OneStream Certified Associate (OCA) Practice Exam for more practice questions and the full quiz experience.

Access More Questions