Question

Data can be consolidated from two sheets only is it true or false​

Answer 1

Answer:

true data can be consolidate from two sheets only is it

Answer 2

It is false that data can be consolidated from two sheets only.

• It is feasible to integrate (or condense) all of this data into one table if you have several tables (or lists) (or list).
• The (Data > Consolidate) dialogue box can be used to accomplish this.
• To aggregate the corresponding values from up to 255 distinct worksheets into one worksheet, use (Data > Consolidate).
• Your data can be combined from multiple sources and shown on one worksheet, multiple worksheets within the same workbook, or even multiple workbooks.
• You must choose a location for the consolidated data before merging the data.
• It can be added to a worksheet in a different workbook or a separate worksheet in an existing workbook.

You can combine data from each worksheet into a master worksheet to summarise and report results from other worksheets. The worksheets may be located in other workbooks or in the same workbook as the master worksheet. Hence, the answer is false.

#SPJ2