You can easily switch between these sets using the Navigator or a drop-down list which can be shown beside the changing cells.įor 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. A scenario is essentially a saved set of cell values for your calculations. When you print the spreadsheet, only the content of the currently active scenario is printed. Each scenario is named, and can be edited and formatted separately. Scenarios are a tool to test “what-if” questions. So here goal is set and according to it Jack will find one unknown variable IT marks. He wants to calculate the score in IT he needs to achieve 85 percent in aggregate. The process involves using a specific operator in a formula, which can be calculated using computer software.Įxample: Set Cell: It specifies the cell whose value will be changed to the desired value after the result of the Goal Seek operation.Įxample: Jack scored 25 out of 30 in English, 22 out of 30 in Maths. Goal seeking is a general term used to describe the process involved in figuring out your input value based on an already known output value. Using the Goal Seek option under the Tools menu, you can discover what values will produce the result that you want. For efficiency, one must choose up to three groups of arrays to which to apply a function. Using the Subtotals dialog, you can select arrays, and then choose a statistical function (sum, average, max, min) to apply to them. SUBTOTAL: totals/add data arranged in an array-that is, a group of cells with labels for columns and/or rows. During consolidation, the contents of cells from several sheets can be combined in one place. Consolidate provides a graphical interface for copying data from one range of cells to another, then running one of a dozen functions on the data.

The Data Consolidation function takes data from a series of worksheets or workbooks and summarizes it into a single worksheet that you can update easily. (a) Consolidating data (b) Subtotals (c) Goal seek (d) Scenario (e) Solverĭata Consolidation allows you to gather together your data from separate worksheets into a master worksheet. Electronic Spreadsheet Question Answersĭefine and Explain the usage of the following terms with Reference to OpenOffice Calc.

Practice these Class 10 IT unit 2 Electronic Spreadsheet Question Answers to score best in your final exam.

Electronic Spreadsheet question answers have been given here in this post.

Openoffice calc merge cells