Leo needs to consolidate data in multiple worksheets by performing a calculation across all worksheets on the same cells.Which feature should he use to perform this task?

A 3-D reference lets a formula refer to the same cell or range across multiple worksheets, so Leo can calculate using corresponding cells on each sheet. For example, a formula can sum cell B2 across several worksheets. Data consolidation combines data from ranges, but it is not the feature for directly calculating across matching cells in worksheets.

AI-written and checked against the verified answer.