SARASWATI SHISHU VIDYA MANDIR BARGANDA GIRIDIH
(ADVANCE FEATURES OF SPREADSHEET)
CLASS X
LibreOffice Calc
What do you mean by Data consolidation?
Data consolidation means collection and integration of data from multiple worksheets or
workbooks into a single master worksheets.
What is the use of Subtotal command?
Subtotal command is used to automatically create groups and apply inbuilt function like
SUM, COUNT, AVERAGE, PRODUCT, MAX, MIN,
What do you mean by What If Analysis?
What if analysis is a useful feature that helps to analyses all the possible outcomes with
change in input value? it is helpful in situation where there are many possibilities and
outcomes
List various tools in spreadsheet which is use to check what if analysis?
Following tools are used to implement what if analysis in spreadsheet
1) Scenarios
2) Multiple operation
3) Goal Seek
4) Solver
What is Grouping feature in libre calc?
Group is a feature in calc that enables to organize selected data by creating an outline. It
lets to group rows and columns together.
What is Scenarios?
Scenario is a set of values that helps to explore different possibilities of a situation by
inserting different combination of input values in a [Link] using a scenario arguments of
a formula can be quickly changed and the new results can be viewed.
What is multiple operations?
Multiple operations is a planning tool for what if analysis. It create a formula array in a
separate set of cells that give all the alternative results for the formulas used.
How many cells are there in Multiple operation dialog box?
Multiple operations dialog box contains following three cells
1) Formula: use to enter the cell reference contains formula
2) Row Input Cell: use to enter cell address of the first cell of the range from rows
3) Column Input Cell: use to enter cell address of the first cell of the range from column
What is Goal Seek?
Goal Seek is used when the output or target value is fixed and we required to make
changes in any of the input cell [Link] reverse the usual order of a formula.
How many fields are there in Goal seek dialog box?
Goal seek window has following three components
Formula Cell: in the formula cell we enter the address of the cell which contain the
formula
Target Value: in this we specifies the value we want to achieve as a new result
Variable Cell: in this we specifies the cell address where we want to change the value
What is solver?
Solver is a advance and descriptive form of Goal seek. It can generate solution with
equation having multiple unknown variables. Solver can manipulate values of more than
one cell.
What is Macros in clac?
Macros are a set of stored commands or keystrokes that can be used to apply action or
processes that are repeated often.
What is Macros in clac?
Macro is a sequence of instructions consisting of commands or keystrokes that are
recorded and save as module for later use.
In which programming language Libreoffice record macro.
The actions recorded by macro in Libreoffice calc are recorded as instruction in a
programming language called LibreOffice basic.
What is function in macro?
A function is a set of instructions placed separately which can be included in a program at
any appropriate place. It eliminate the repeated composing of same set of instruction.
What is arguments in function?
Argument is a variable passed to a function in order to produce output.
What is clipboard?
Clipboard is a location in memory wherer data cut or copied by user lies temporarily till it
is pasted in another location.
Explain uses of changes record feature of calc ?
All the changes mad by a proof reader are recorded, such as addition deletion text
alteration and usual formatting in a calc worksheet. For enabling this feature we have to
select. Edità changesàrecord
How changes record report once any changes done in worksheet
Calc automatically adda a comment to the cells where any changes are recorded
describing what changes has been made along with the name, date time and change value
in the comment box
What is comment feature used for in calc worksheet?
Authors and reviewers use comments to exchange ideas, ask for suggestion or for
brainstorming.