Ask Question
7 May, 21:33

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
Answers (1)
  1. 8 May, 00:15
    0
    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.
Know the Answer?
Not Sure About the Answer?
Find an answer to your question ✅ “Leo needs to consolidate data in multiple worksheets by performing a calculation across all worksheets on the same cells. Which feature ...” in 📘 Computers and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers