Question

Explain data consolidation, subtotals and scenario tools in spreadsheet. class 10th agar kisne sirf data c9nsolidation ya spam kiya vo behen ka loda ab thik answer do mai brainlist mark karunga ok​

Answer 1

Answer:

Hey mate,

Your answer is as follows:

1)  

Data Consolidation allows you to gather together your data from separate worksheets into a master worksheet. In other words, the Data Consolidation function takes data from a series of worksheets or workbooks and summaries it into a single worksheet that you can update easily.

2) Subtotal adds data arranged in an array—that is, a group of cells with labels for  columns and/or rows. It is available in Data Tab, using the Subtotals dialog, you  can select arrays, and then choose a statistical function such as Count, Min, Max  etc. to be applied on arrays. For efficiency, one must choose up to three groups  of arrays to which to apply a function.

3) Scenario manager in excel is a part of three what-if-analysis tools in excel, which are built-in in, excel. In simple terms, you can see the impact of changing input values without changing the actual data. Scenario Manager in Excel allows you to change or substitute input values for multiple cells (maximum up to 32).

Explanation:

Hope You Find It Useful..

Thanks & Regards..

Doo mark my answer as Brainliest..