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?
Answers
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