Part-2

• What if tools-Multiple operations

Like scenarios, Data > Multiple Operations is a planning tool for “what if” questions. To use the Multiple Operations tool, you need two arrays of cells. The first array contains the original or default values and the formulas applied to them. The formulas must be in a range.

The second array is the formula array. It is created by entering variables—alternative values—for one or two of the original values. Once the variable values are created, you use the Multiple Operations tool to specify the formulas you are using, as well as the original values altered by the variables. The result is the outcome of the formulas using each variable.

• Goal Seek

Goal seeking is the process of finding the correct input value when only the output is known.

To use Goal Seek:

• Fill the cell with the unknown data with a 0 (or any other value).
• Select the cell containing the Formula (in our example the Average grade) and Choose Tools -Goal Seek from the main menu.
• Solver

Tools > Solver amounts to a more elaborate form of Goal Seek. The difference is that the Solver deals with equations with multiple unknown variables. It is specifically designed to minimize or maximize the result according to a set of rules that you define.

Each of these rules defines whether an argument in the formula should be greater than, lesser than, or equal to the figure you enter.

Video Tutorial

Q 1. Give any three ways to add a sheet to the Calc file.

Ans.  1.  Select Insert>sheet from the Menu bar.

2. Right-click on the sheet tab and click on the Insert sheet

3. Click in an empty space at the end of the line of sheet tabs.

Q 2. What are the two ways of referencing cells in other worksheets?

Ans.  1. Creating the Reference with the Keyboard

2. Creating The Reference with The mouse

Q 3. Differentiate between relative and absolute hyperlinks.

Ans.  An absolute link will stop working only if the target is moved. A relative link will stop working only if the start and target locations change relative to each other.

Ans.  Consolidating data from other workbooks is referred to as linking.  A link is a reference to a cell or a range of cells in another workbook.

Q.5.    Write the cell address of the following:

1. First row and First Column: A1
2. First column and last row:  A16384
3. Last column and First row: XFD1
4. Seventh column and tenth row: G10
5. Tenth column and nineteenth row: J19

Q 6. What is the difference between the problems where only Goal seek can be used and one where only solver can be used?

Ans. The difference is that the solver deals with equations with multiple unknown variables.

Q.7.  Define the following:

1. What-if Multiple operations:

Ans. Multiple Operations is a planning tool for “what if” questions. To use the Multiple Operations tool, you need two arrays of cells.

1. Goal Seek

Ans. Goal seeking is the process of finding the correct input value when only the output is known.

1. Solver

Ans. It is specifically designed to minimize or maximize the result according to a set of rules that you define.  Each of these rules defines whether an argument in the formula should be greater than, lesser than, or equal to the figure you enter.

error: Content is protected !!