Creating Scenarios :ġ) Select the cells that contain the values that will change between scenarios.ģ) On the Create Scenario dialog, enter a name for the new scenario. For example, if you wanted to calculate the effect of different interest rates on an investment, you could add a scenario for each interest rate, and quickly view the results. You can easily switch between different scenarios by using the Navigator. Each scenario is named, and can be edited and formatted separately. Scenarios are a tool to test “what-if” questions. Steps to insert subtotal values into a sheet:Ģ) In the Subtotals dialog, in the Group by box, select the column that you want to add the subtotals to.ģ) In the Calculate subtotals for box, select the columns that you want to subtotal.Ĥ) In the Use function box, select the function. Using the Subtotals dialog, you can select arrays, and then choose a statistical function to apply to them. SUBTOTAL, totals/adds data arranged in an array-that is, a group of cells with labels for columns and/or rows. NOTE : Use Data > Define Range to give name to a range Creating Subtotals : The text in the labels must be identical in all the specified Source range. The Sum function is the default setting.ħ) Select either Row labels or Column labels. The selected range now appears on the Consolidation ranges list.Ĥ) Select additional ranges and click Add after each selection.ĥ) Specify where you want to display the result by selecting a target range from the Copy results to box.Ħ) Select a function from the Function list.

In other words, the Data Consolidation function takes data from a series of worksheets and summaries it into a single worksheet.ġ) Open the worksheet that contains the cell ranges to be consolidated.Ģ) Choose the Consolidate option under the Data menu.ģ) Select Source data range and click Add. SESSION 1: Analyze data using SCENARIOS AND GOAL SEEKĭata Consolidation allows you to gather together your data from separate worksheets into a master worksheet. SESSION 1: ANALYSE DATA USING SCENARIOS AND GOAL SEEK SESSION 2: LINK DATA AND SPREADSHEETS SESSION 3: SHARE AND REVIEW A SPREADSHEET SESSION 4: CREATE AND USE MACROS IN SPREADSHEET Spreadsheet Class 10 Notes UNIT-2: ELECTRONIC SPREADSHEET (ADVANCED)

Open office calc