WorksheetsOPEN OFFICE CALC
Total questions: 24
Worksheet time: 12mins
1 _________ allows you to gather data from different worksheets into a master worksheet.
Data Consolidation
Goal Seek
Solver
Subtotal
Which of the following functions are available in consolidate window?
Max
Min
Count
All of the above
Subtotals is available in __________ menu.
Data
Tools
Format
Insert
In Subtotals we can select up to _______ groups of arrays.
1
2
3
4
Scenarios are tool to test _________ analysis questions.
if else
what else
what if
none of these
By default ________________ sheets are present in Spreadsheet
1
2
3
4
. Formula to refer a cell A3 in sheet named S1 is
S1.A3
S1A3
A3
'S1.A3
Hyperlink option is available in ______ menu.
DATA
TOOLS
FORMAT
INSERT
Hyperlink in Calc can be used to
to jump from one sheet to another sheet.
to jump from one sheet to website
to link to an email or news
all of the above
Which feature of Calc help to see the changes made in the shared worksheet
Record changes
solver
subtotal
none of the above
To activate the record changes feature in shared worksheet ___________
Select File > Changes > Record from the menu bar
Select Edit > Changes > Record from the menu bar.
Select View > Changes > Record from the menu bar
_____________ is a saved sequence of commands or keystrokes that are stored for later use
share worksheet
Autosum
Command
Macro
Which option is suitable to calculate the effect of different interest rates on an investment.
Scenario
Subtotal
Consolidate
none of these
We can rename an existing sheet in Calc by
Double click on one of the existing sheet
Right click on existing sheet and then choose rename
Both of the above
None of the above
What should be entered in formula cell, target value and variable cell if we want to calculate marks to be obtained in english in semester 4 in order to attain 75 % using goal seek
Formula cell-B5, TARGET VALUE-75, VARIABLE CELL- B6
FORMULA CELL- B6, TARGET VALUE- B5, VARIABLE CELL-75
FORMULA CELL- B6, TARGET VALUE- 75, VARIABLE CELL-B5
________amounts to a more elaborate form of Goal Seek
what if
find what
solver
multiple operations
Scenario option is accessed from which menu?
Tools
data
Format
Create
Scenarios are tool to test _________ analysis questions.
if else
what else
what if
none of these
Divya wants to prepare a master sheet with a combination of data from another 3 worksheets. Which of the following feature is useful for her?
Data Table
Data Consolidate
Link worksheets
Cell Referencing
The difference between Consolidation ranges and Source data ranges are
A: Consolidation ranges are selected from source ranges only
B: Source data ranges are actual ranges from the data worksheet
a) A is correct and B is not correct
b) B is correct and A is not correct
c) A and B both are correct
d) A and B both are incorrect
Shaan is working on a spreadsheet and he performed the operation data consolidation. But he wanted to generate the results in the target instead of the actual results. Select the appropriate option he can choose?
a) Copy to
b) Consolidation Ranges
c) Link to source data
d) Function
Which of the following tool is used to test the what-if questions?
a) goal seek
b) scenarios
c) subtotal
d) Consolidate data
The scenario name is displayed on
a) Sheet tab
b) Name box
c) Navigator and Title bar of scenario
d) Top of the row
Akshat wants to predict his result from the given set of data from recently exam results. Which option is useful for him?
a) Scenario
b) Multiple operations
c) Solver
d) Goal Seek
