Question

5.
It refers to changing the position of data either in the same or in a different
worksheet.
​

Answer 1

Answer:

You can use (Data > Consolidate) to combine the corresponding values in up to 255 different worksheets into a single worksheet. Your data can be consolidated from several different source, either on the same worksheet, on different worksheets within the same workbook or even in different workbooks.