Question

Divya wants to prepare a master sheet with a combination of data from another 3 worksheets. Which of the following feature is useful for her?
a) Data Table
b) Data Consolidate
c) Link worksheets
d) Cell Referencing​

Answer 1

Answer:

a) Data Table

hope it helps

Answer 2

Link worksheet

Explanation:

The HYPERLINK creates a shortcut that jumps to another location in the current workbook, or opens a document stored on a network server, an intranet, or the Internet.

When one click a cell that contains a HYPERLINK function, Excel jumps to the location listed, or opens the document that is specified.

The data table is a range of cells in which you can change values in some of the cells and come up with different answers to a problem.

Data Consolidation allows one to gather together their data from separate worksheets into one master worksheet.

A cell reference refers to a cell or a range of cells on a worksheet and can be used.