Question

Write the options available in consolidate dialog box.​

Answer 1

Answer:

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.

plz mark me branlist and follow me

Answer 2

1. SUM: The total value of the numbers in a list or cell range.
2. COUNT: The number of numeric values in a list or array of numbers.
3. COUNTA: Count Nums The number of non blank cells in a list or cell range.
4. AVERAGE :The arithmetic mean of a list or array of numbers.
5. MAX :The largest value in a list or array of numbers.
6. MIN :The smallest value in a list or array of numbers.
7. PRODUCT: The product of all the numbers in a list or cell range.
8. STDEV: The standard deviation based on a sample.
9. STDEVP: The standard deviation based on an entire population.
10. VAR: The compound variance based on a sample.
11. VARP: The variance based on an entire population

MARK BRAINLIEST PLEASE