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?

data consolidation

3-D reference

grouped cells

linked cells

3-D reference is the correct answer to the given question.

Explanation:

In Excel the Three dimensional relates to the similar cell or the ranges of the cell range on the several worksheets. This is a very simple but easy way to measure the information through the multiple worksheets with the same framework, and it can be a good solution to the Detail Summarize function.

The Leo used 3-D reference and requires to aggregate the data in several worksheets by measuring on the same cells across all the worksheets. All the other Options are not related consolidate data in multiple worksheets So these are incorrect Options.