Ch 4: Scenarios and Goal Seek
Consolidating Data
Consolidate: combines information from multiple sheets into one place to summarise and compare data. Path: Data > Consolidate. Default function = Sum.
Subtotals
The Subtotal tool (Data > Subtotals) automatically creates groups and applies functions like Sum or Average using Group & Outline.
What-if Scenarios
Scenario: a named set of values used in a sheet's calculations. Several scenarios can be compared on the same sheet. Path: Tools > Scenarios.
Goal Seek
Goal Seek: works in reverse — it finds the INPUT value needed to reach a target OUTPUT value. Path: Tools > Goal Seek.
Example: a student wants a 70% aggregate — Goal Seek finds the marks needed in the 5th subject.
Quick difference: Scenario → change inputs, see the output. Goal Seek → fix the output, find the required input.
Summary
- Consolidate merges sheets (default = Sum); Subtotal groups data and applies functions.
- Scenarios compare named value sets; Goal Seek is reverse analysis.
Data Consolidate करना
Consolidate: कई sheets की जानकारी को एक जगह जोड़कर summarise और compare करता है। Path: Data > Consolidate। Default function = Sum।
Subtotals
Subtotal tool (Data > Subtotals) अपने आप groups बनाकर Sum या Average जैसे functions लगाता है (Group & Outline)।
What-if Scenarios
Scenario: sheet की calculations में उपयोग होने वाला named values का set। एक ही sheet पर कई scenarios compare किए जा सकते हैं। Path: Tools > Scenarios।
Goal Seek
Goal Seek: उल्टा काम करता है — target OUTPUT पाने के लिए ज़रूरी INPUT value ढूँढता है। Path: Tools > Goal Seek।
Example: एक student को 70% aggregate चाहिए — Goal Seek 5वें subject के ज़रूरी marks बता देता है।
अंतर: Scenario → input बदलो, output देखो। Goal Seek → output fix करो, ज़रूरी input ढूँढो।
सारांश
- Consolidate sheets जोड़ता है (default = Sum); Subtotal data group करके functions लगाता है।
- Scenarios named values compare करते हैं; Goal Seek reverse analysis है।
Frequently Asked Questions
What is Goal Seek?
Goal Seek is a reverse-analysis tool that finds the input value required to achieve a desired target output value.
What is the default function of Consolidate?
The default function of the Consolidate tool is Sum.