Which of the following is true about metrics in a workbook?

The statement that metrics must always return a single value is correct because metrics are designed to quantify performance indicators or measures in a workbook. By definition, a metric aggregates data and provides a singular, definitive output that reflects the state or performance of a given aspect, such as sales, efficiency, or compliance. This single value can be a result of calculations performed on the provided data, showcasing key insights at a glance.

In a practical scenario, this means that when developing dashboards or reports, each metric indicates a specific aspect of performance consistently. Having metrics return only a single value ensures clarity and focus in reporting, allowing users to quickly understand key results without confusion or ambiguity. This single value nature is vital for decision-making, as it emphasizes the most important data points and simplifies analysis.

The other choices introduce ideas that do not align with the fundamental principles of metrics in a workbook. For example, saying metrics can be edited in any workbook implies a flexibility that may not exist if a specific workbook is designed to lock certain functionalities for integrity. Mentioning that metrics can only compare two datasets unnecessarily limits their applicability, as metrics can often incorporate more involved calculations that reference multiple datasets. Lastly, the idea that all metrics require multiple worksheets contradicts the function of a metric, which