CLASS X – PART B – UNIT 2
UNIT 2 – ELECTRONIC SPREADSHEET QUESTION ANSWERS
Answer the following questions
Q1. Define the terms
(a) Consolidate function
(b) What-if analysis
(c) Goal seek
Ans. (a) Consolidate function: Consolidate function used to combine information from
multiple sheets of the spreadsheet into one place to summarize the information.
(b) What-if analysis: What-if analysis tool is a planning tool for what-if questions. In this,
the output is not shown in the same cells, whereas it uses a drop-down list to display
the output depending upon the input.
(c) Goal seek: Goal Seek in LibreOffice Calc is a feature that helps to find the right input
value for a formula to achieve the desired result. In other words we can say that it helps
in finding out the input for the specific output.
Q2. Give one point of difference between
(a) Subtotal and What-if
(b) What-if scenario and What-if tool
Ans. (a) What-If Analysis: This feature is used to explore and compare various
outcomes based on changing conditions. It’s particularly useful for financial modeling
and forecasting.
The Subtotal tool in Calc creates the group automatically and applies common functions
like sum, average on
the grouped data.
(b) What-if Scenario: This refers to a set of values used to explore and compare various
alternatives based on changing conditions. It allows you to create different scenarios on
the same sheet, each with some different values.
What-if tool: This tool is a planning tool for what-if questions. In this, the output is not
shown in the same cells, whereas it uses a drop-down list to display the output
depending upon the input.
Q3. Give any two advantages of data analysis tools.
Ans. Two advantages of data analysis tools are:
Data analysis is very useful in the beginning of any project to optimize the output.
Data analysis is used to predict the output while changing the inputs which reflects the
output and thus one can choose the best plan of action based on it.
Q4. Name any two tools for data analysis.
Ans. Two tools used for data analysis are:
Goal Seek
Scenarios
Q5. What are the criteria for consolidating sheets?
Ans. Criteria for consolidating sheets are:
1. Data types across all the sheets to be consolidated should be same.
2. Label should match from all the sheets which are used for consolidating.
3. Designate the first column as the primary column on the basis of which the data is to
be consolidated.
Q6. Which tool is used to create an outline for the selected data?
Ans. Group and Outline in Calc is used to create an outline of the selected data.
Analyse data using Scenarios and Goal Seek Question Answers
Q1. What is a Macro? List any two real life situations where they can be used.
Ans. A macro is a sequence of instructions or commands that automate repetitive tasks
in software applications. In other words we can say that a macro is a single instruction
that executes a set of instructions.
Here are two real-life situations where macros can be used
Data Entry
Document Formatting
Q2. List the actions that are not recorded by a macro.
Ans. Actions that are not recorded by a macro are:
Opening of windows
Actions carried out in another window than where the recording was started.
Window switching
Actions that are not related to the spreadsheet contents.
Selections are recorded only if they are done by using the keyboard (cursor traveling),
but not when the mouse is used.
The macro recorder works only in Calc and Writer.
Using macros in Spreadsheet
Q3. How is LibreOffice Macros Library different from my Macros?
Ans.
LibreOffice Macro Library My Macros
This library is inbuilt in
This is user defined library
LibreOffice
This library contains macros
This library contains inbuilt
recorded by user
macros which
which can not changed at any
can not be changed
time.
Using macros in spreadsheet
Q4. Differentiate between predefined function in Calc and Macros as a function
Ans.
Predefined function Macros as a function
These are user defined
These are built in functions
functions.
It does not involve any
It involves writing code in Basic.
programming
It cannot be customized It can be customized
Using macros in spreadsheet
Q5. List the rules that should be kept in mind while naming a macro.
Ans. Rules that should be kept in mind while naming a macro are:
Name should begin with a letter
Name should not contain spaces
Name should not contain special characters except for _(underscore)
Q6. Give any one advantage of macros.
Ans. Macros automate repetitive tasks, saving time and increases efficiency and
consistency.
Q1. Name the two ways to link the sheets in a LibreOffice Calc.
Ans. The two ways to link the sheets in a LibreOffice Calc are
1. Creating reference to other sheets/documents by using keyboard and mouse.
2. By linking external data.
Q2. Differentiate between Relative and Absolute Hyperlink.
Ans. An absolute hyperlink stores the complete location where the file is stored. So, if
the file is removed from the location, absolute hyperlink will not work. For example:
C:\Users\ADMIN\Downloads\[Link] is an absolute link as it defines the complete path
of the file.
A relative hyperlink stores the location with respect to the current location. For example:
Admin\Downloads\[Link] is a relative hyperlink as it is dependent on the current
location. If the complete folder containing the active spreadsheet is moved the relative
link will still be accessible as it is bound to the source folder where the active
spreadsheet is stored.
Q3. Write steps to extract a table from a web page in a spreadsheet.
Ans. Steps to extract a table from a web page in a spreadsheet are:
1. Open the spreadsheet where external data is to be inserted.
2. Select Sheet > External Links…
3. The External Data dialog box will open.
4. Type the URL of the source document and press enter.
5. A dialog box is displayed to select the language for import. Selecting Automatic
shows data in the same language as in the webpage.
6. From the Available Tables/Ranges list, choose the desired table and click OK.
7. Table will be inserted in the spreadsheet
Q4. Write steps to register a data source that is in *.odb format.
Ans.
1. Select Tools > Options > LibreOffice Base > Databases. The Options – LibreOffice
Base-Databases dialog box appears.
2. Click the New button to open the Create Database Link dialog box.
3. Click Browse to open a file browser and select the database file.
4. Type a name to use as the registered name for the database and click OK.
Q5. State advantages of extracting data from a web page into spreadsheet.
Ans. Advantages of extracting data from a web page into spreadsheet are:
Accuracy: Extracting data directly from a webpage, ensure that the information is up-to-
date and accurate.
Efficiency: Extracting data automates the process of gathering data from a webpage.
Collaboration: It also facilitates organization and collaboration of data.
Q1. Define the terms
(a) Sharing Spreadsheet
(b) Record changes
Ans. (a) Sharing Spreadsheet : Sharing a spreadsheet allows multiple users to open the
same file for editing at the same time.
(b) Record changes: This feature of LibreOffice Calc provides ways to record the
changes made by one or other users in the spreadsheet.
Q2. Write the commands to perform
(a) Sharing Spreadsheet
(b) Record changes
Ans. (a) Tools > Share Spreadsheet
(b) Edit > Track Changes > Record
Q3. Which menu is used to perform the functions
(a) Track Changes
(b) Saving Spreadsheet
Ans. (a) Edit menu
(b) File menu
Q4. What do you understand by reviewing the changes in the spreadsheet?
Ans. Reviewing changes means to go through all the changes made by the different
users and to decide which changes should accept or reject to prepare the final
spreadsheet.
Q5. Differentiate between Merging and Comparing Spreadsheet.
Ans. When multiple reviewers return edited copies of a spreadsheet. In this case, it may
be faster to review all of the changes at once, rather than one review at a time. For this
purpose, we can merge documents in Calc.
Sometimes reviewers may not record the changes they make. In this case Calc can find
the changes by comparing documents.
Question and Answers (Electronic Spreadsheet (Advanced)
Q1. How can we rename a worksheet?
Ans. There are three ways you can rename a worksheet
a. Double-click on one of the existing worksheet names.
b. Right-click on an existing worksheet name, then choose Rename from the resulting
Context menu.
c. Select the worksheet you want to rename (click on the worksheet tab) and then select
the Sheet option from the Format menu. This displays a submenu from which you
should select the Rename option.
Q2. What are the two ways of referencing cells in other worksheets?
Ans. Two ways to reference cells in other sheets: by entering the formula directly using
the keyboard or by using the mouse.
Q3. Differentiate between Relative and absolute hyperlinks.
Ans. Hyperlinks can be used in Calc to jump to a different location from within a
spreadsheet. 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. For
instance, if you have two spreadsheets in the same folder linked to each other and you
move the entire folder to a new location, a relative hyperlink will not break.
Q4. List the procedure involved in Linking HTML Tables to Calc Worksheet.
Ans. You can insert tables from HTML documents, and data located within named
ranges from an [Link] Calc or Microsoft Excel spreadsheet, into a Calc
spreadsheet.
We can do this in two ways: using the External Data dialog or using the Navigator.
Using the External Data dialog
a. Open the Calc worksheet where the external data is to be inserted. This is the target
worksheet.
b. Select the cell where the external data is to be inserted.
c. Choose Insert -> Link to External Data.
d. On the External Data dialog, type the URL of the source worksheet or click the […]
button to open a file selection dialog. Press Enter to get Calc to load the list of available
tables.
e. In the Available tables/range list, select the named ranges or tables you want to
insert. You can also specify that the ranges or tables are updated every (number of)
seconds.
f. Click OK to close this dialog and insert the linked data.
Electronic Spreadsheet
Q5. What is the purpose of adding comments?
Ans. Comments are mostly used in shared Calc sheet which is used to explain the
changes made in the sheet to the author of the sheet.
Q6. How can we add comments to the changes made?
Ans. Comments can be added as follows:
1. Make the change to the spreadsheet.
2. Select the cell with the change.
3. Choose Edit > Changes > Comments. The automatically-added comment provided
by Calc appears in the title bar of this dialog and cannot be edited.
4. Type your own comment and click OK.
After you have added a comment to a changed cell, you can see it by hovering the
mouse pointer over the cell.
Q7. What are Macros?
Ans. A macro is a saved sequence of commands or keystrokes that are stored for later
use. Macros are especially useful to repeat a task the same way over and over again.
Q8. How can we record a Macro?
Ans. Steps to record macro are as follows
a. Use Tools > Macros > Record Macro to start the macro recorder. The Record Macro
dialog is displayed with a stop recording button.
b. Perform the actions you want to be recorded in the document.
c. Click Stop Recording.
d. The Macro dialog appears, in which you can save and run the macro.
Fill in the blanks (Electronic Spreadsheet (Advanced))
1. At the bottom of each worksheet window is a small tab that indicates the name of the
worksheets in the workbook.
2. A cell reference refers to a cell or a range of cells on a worksheet and can be used to
find the values or data that you want formula to calculate.
3. Spreadsheet software allows the user to share the workbook and place it in
the Network location where several users can access.
4. Spreadsheet software can find the changes by Comparing Sheets.
5. Macros are useful to repeat a task the same way over and over again.
------------------------------------------------------------------------------------------------------------
