UNIT-2 Electronic Spreadsheet
(Pending Questions)
Session 1: Scenario Analysis
Q12. What is Solver? Name some application areas of solver tool.
Ans: Solver tool is a more elaborate form of Goal seek and it deals
with equations with multiple unknown variables. Aim of solver is to
find the maximum or minimum result from a multiple unknown
variables.
Solver can be used for portfolio optimization, production planning,
resource allocation, budgeting, transportation problems, and any
situation where you need to optimize a value subject to multiple
constraints.
Session 2 (Linking spreadsheet data)
Q9. Imagine you are a student organizing a fundraising event for
your school club. You have a spreadsheet in Libreoffice Calc that
lists donations from different sponsors. Each sponsor has
contributed multiple times and you need to summarize the total
amount donated by each sponsor.
a. Which tool in Calc can be used to create the group
automatically?
Ans: Subtotals tool
b. Which function can be applied to the grouped data?
Ans: Sum function
c. Which menu option is used to apply this tool?
Ans: Data ->Subtotals menu option
d. What is the purpose of (-) or (+) signs on grouped data?
Ans: The purpose of (-) is to collapse the data and to expand the data
(+) is used. By using (-) we can see the summary i.e., grand total,
item wise total only and by using (+) we can see the complete data.
Session 3
14. Which command opens a document in shared mode?
Ans: Opening a shared document is similar to the way we open other
documents ie by using command File ->Open or by pressing the
shortcut Ctrl+O
15. Which command opens a document in record changes mode?
Ans: The command to open a document in record changes mode is
Edit ->Track Changes ->Record
16. While saving a shared document, if you are resolving the
conflicts in changes, can any other user save the document at that
time?
Ans: No other user can save the document at that time because
shared spreadsheet file is locked same time.
Session 4
Q6. Describe the process of recording a macro in libreoffice calc.
Ans: To run a macro in libreoffice calc do the following
1.Click Command Tools ->Macro ->Record Macro
2. It will start recording of actions in macro and display Record
Macro Toolbar with one icon on it to Stop Recording
3. Now start performing the actions which you want to include in
macro.
4. Click Stop Recording button.
5. It will open LibreOffice Basic Macro Dialog.
6. Expand My Macros then Standard and click on Module1
7. Type the desired macro name inside macro name box
8. Click on save button
Q7. How can you run a macro in libreoffice calc?
Ans: To run a macro in libreoffice calc do the following
1. Click command Tools ->Macro ->Run Macro
2. Choose the name of macro you want to run
3. Click on Run button.
Q8. How can you use a macro has a custom function in Libreoffice
calc?
Ans: To use a macro has a custom function in Libreoffice calc, follow
the command sequence given below
1. Open LibreOffice Basic Macros dialog using command
Tools->Macros->Organize Macros -> LibreOffice Basic
2. Click on any macro name and click edit
3. Now type
Function Functionname( )
Functionname=value to be returned
End Function
4. Now save the code by pressing Ctrl+S or click the save icon on
toolbar
