Question

which of the following option allows to select source of data for consolidation (a)function, (b)consolidation ranges, (c)source data range, (d)copy results to​

Answer 1

Answer:

If you have a group of tables (or lists) it is possible to combine (or consolidate) all this data into one table (or list). This can be done using the (Data > Consolidate) dialog box. You can use (Data > Consolidate) to combine the corresponding values in up to 255 different worksheets into a single worksheet.