Question

31. How inany arguments can be altered in Goal Seek?
32. What is data consolidation? What is the use of it?
33. What do you understand by 'What-if-analysis'? What is the significance of it?
34. What are the various what-if tools available in Calc?
35. What are the options available in consolidate dialogue box?​

Answer 1

Answer:

31= 32

32= data consolidation allow you to gather together your data from separate worksheets into master worksheet . In words, the data consolidation function takes data from a series of worksheet are workbook and summarise into a

single worksheet that you can update easily.

33= what if analysis in the process of changing the values in cell see how those changes wheel effect the outcome of of formulas on the worksheet.

34= three kinds of what if analysis tools from which Excel: Scenarios, goal seek, and data table.

35= if you have a group of table ( or list) it is possible to combine ( or consolidate) all these data into one table ( or list) this can be done using ( data > consolidate) dialog box .

I hope is helpful mark Mein brilliant please