30 important questions GoalSeek Solver Class 10 IT 402

This article focuses on questions GoalSeek Solver Class 10 IT 402 on the topic from Unit 2 Electronic SpreadSheet (advanced) of Information Technology 402. Let us begin with objective-type questions.

Objective Type Questions – questions GoalSeek Solver Class 10 IT 402

First, we start the article questions GoalSeek Solver Class 10 IT 402 with 1 mark questions.

1 Mark Questions (Fill in the blanks, MCQ , True/False or one-word answer)

1 A _______ feature provides a target-based result and informs the user about the changes in value in the applied formula.

Ans.: GoalSeek

2 To run a GoalSeek, at least one of the values for an argument must be

a) value

b) range

c) cell reference

d) b and c

Ans.: Option d) b and c

3 How many arguments can be altered in GoalSeek?

Ans.: One

4 You cannot replace the original value with GoalSeek resultant value. (True/False)

Ans.: False

5 You must place a cursor in a formula cell before using GoalSeek. (True/False)

Ans.: True

6 A ___________ option displays a cell address in GoalSeek dialogbox.

Ans.: Formula Cell

7 Which of the following option is used to type a resultant value to achieve the goal?

a) Goal Value

b) Target Value

c) Variable Value

d) GoalSeek Value

Ans. b) Target Value

8 The ______________ option allows to select a cell to display or set the result value in a GoalSeek dialog box.

Ans.: Variable Cell

9 OO Calc display the change of value in which of the following?

a) In the variable cell

b) In the dialog box

c) In a message

d) All of the above

Ans.: a) In the variable cell

10 When you click on OK button in GoalSeek dialogbox, ____________ will appear in OO Calc.

Ans.: GoalSeek Successful Message box

11 The GoalSeek Successful Message box will show only the target value as result. (True/False)

Ans.: False

12 A ___________ feature is more elaborate form of GoalSeek.

Ans. Solver

13 Which feature of OO Calc deals with formulas with multiple unknown value?

Ans.: Solver

14 Click on __________ -> ___________ to open GoalSeek dialog box.

Ans: Tools –> GaolSeek

15 Click on _______ -> _______ to open solver dialog box.

Ans.: Tools –> Solver

16 You can set any kind of value like greater than, lesser than, equal or specific value using solver. (True/False)

Ans.: True

17 You can optimize result to which of the following using solver?

a) Best value, Value of, Exact Value

b) Maximum, Minimum, Value of

c) Less Than, Greater than or Equal to

d) All of the above

18 In solver dialog box ____________ option indicates the formula cell.

Ans.: Target Cell

19 You cannot select any range for changing cells option in the Solver dialog box. (True/False)

Ans.: False

20 The solver dialog box displays the value as a result in a result message box. (True/False)

Ans.: False

In the next section of questions GoalSeek Solver Class 10 IT 402 we will discuss 2/3 marks for questions GoalSeek Solver Class 10 IT 402. Here we go!

2/3 Marks Questions – questions GoalSeek Solver Class 10 IT 402

1 What do you mean by GoalSeek?

Ans.:

Goal seek is an important feature of the spreadsheet that is used to find the values which are required to achieve a certain target. It allows changing the cell value which produces the desired target value. In goal seek any one value can be altered to get the desired result.

2 What are the basic predefined requirements for using GoalSeek?

Ans.:

To use goal seek you need to have values and a cell where a formula can be used.

3 Distinguish the Formula Cell and Variable cell.

Ans.:

The formula cell contains the formula.

Variable cell means in which cell you want to change the value to get desired goal.

4 Enlist the options provided by GoalSeek and explain all of them in one line each.

Ans.:

The options provided by Goal Seek are as follows:

  1. Formula cell – A cell where the formula is used
  2. Target Value – A numeric value that indicates what target can be achieved
  3. Variable Cell – The variable cell is a cell whose value can be altered
  4. OK Button – After setting up the goal seek parameter click on the OK button to see the result
  5. Cancel Button – If the user wants to change any of the goalseek settings this button should be used
  6. Help Button – If any assistance is required related to Goalseek, this button is used

5 What is Solver?

Ans.:

Solver is a more elaborated form of goalseek. As in goal seek you alter only one value can , in solver you can alter multiple values.

6 What is role of optimized result to option in the Solver dialog box?

Ans.:

The option optimized result to provide the value which can be achieved. OO Office calc provides 3 options to optimize results:

  1. Maximum – It is the highest value can be achieved through parameters provided
  2. Minimum – It is the lowest value that can be achieved through parameters supplied
  3. Value of – The exact value which can be achieved using a solver

7 What are the options available in options button of Solver dialog box?

Ans.:

The options button provides the settings related to the solver engine. It provides the option as follows:

OptionUse
Assume Variable as IntegerActivate by clicking on the small box if the variable is an integer
Assume variable as non-negativeBy clicking this option, it accepts the variable as non-negative onlu
Limit branch-and-bound- depthThis option allows to limit the branch
Solver engineHas option linear solver for OO spread calc

8 What happens when click on Solve button?

Ans.:

When the solve button is clicked it assumes the value can be put to achieve the desired goal. These values can be selected randomly and then the result is displayed in dialog box. If user want to keep the result he can otherwise he can cancel also.

Watch this video to get the solution to questions given in the CBSE study material:

5 marks questions GoalSeek Solver Class 10 IT 402

1 Write the complete procedure to perform GoalSeek in OO Calc.

Ans.:

  1. Enter the values required in the cells,
  2. Enter the desired formula.
  3. Click on Tools – Goal Seek
  4. Ensure the cell should be selected for the formula is correct.
  5. Enter the target value.
  6. Select the variable cell and click ok.

2 Write the complete procedure to use solver in OO Calc.

Ans.:

  1. Prepare worksheet and enter values as per the requirement.
  2. Click on Tools – Sovler.
  3. Now select the formula cell.
  4. Select the appropriate option to optimize the result out to maximum, mininum or value.
  5. Now select the cells/ranges to be selected by changing cells.
  6. Select various options to cell references conditions.
  7. Click on OK to get the result.

That’s all from questions GoalSeek Solver Class 10 IT 402. Thank you fo rreading!

Follow this link to read notes for the same topic.

Notes Goal Seek and Solver

Leave a Reply