Page 255 - Trackpad 402_Class-X_Final
P. 255
6. What is Scenario?
Ans. Scenarios are what-if analysis tools of OpenOffice Calc. They help you set multiple values for the same cell that can be used
for calculations or data analysis.
7. Mention any four options present in the Create Scenario dialog box.
Ans. Name of Scenario, Display border, Copy back, and Prevent changes
8. What is the use of Goal Seek feature?
Ans. Goal Seek helps you to do backward calculation of the input to obtain the desired output. It is a What-if Analysis Tool of
OpenOffice Calc.
9. What are relative hyperlinks?
Ans. Relative Hyperlink refers to reaching the linked document with respect to the current location. It will include the partial cell
address in hyperlink. If the start and target locations change relative to each other, then relative hyperlink will not work.
10. List the names of the options present in the External Data dialog box while linking a worksheet with external data.
Ans. • URL of external data source
• Available tables/ ranges
• Update every
B. Long answer type questions:
1. Explain any three options present in the Create Scenario dialog box?
Ans. Name of the Scenario: Has the default name as Sheet1_Scenario_1. Change it to a relevant name that clearly identifies a
scenario in the drop-down list and in the Navigator window.
Comment: It is optional and is the extra information required. When you select the scenarios then this information is
displayed in the Navigator.
Settings: It has several options where the settings can be changed as per the situations.
2. What is the purpose of adding comments? Give steps to add comments.
Ans. Comments increase the readability of the cells by giving the information about the changes made in a shared document.
The steps are:
Step 1: Click on Edit → Changes → Comments.
Step 2: In the dialog box that appears → In the Text - Type your own comment.
Step 3: Click on OK button.
3. Name two different ways of adding Cell Reference?
Ans. ● Keyboard
● Mouse
4. Name any three What-if Analysis tools.
Ans. ● Goal Seek
● Solver
● Scenario
5. What are the advantages of using macros?
Ans. The main advantages of using macros are:
● It helps you save time as the long and time consuming tasks are saved as macros and can be executed with a click of a
button.
● It saves you from the tedious repetitive tasks.
● The chances of errors in the complex task are reduced.
● You can run a macro as many times as you want until you delete it from the computer.
6. Explain the rules used with solver.
Ans. It works on rules applicable for different variables used in the formula:
• The variables in the formula should be greater than, less than or equal to the desired value entered in Solver.
• If you do not want the variable to change then the value of the variable should be equal to the desired value entered
in Solver.
Electronic Spreadsheet (Advanced) 255

