Cambridge International School
Electronic Spreadsheet
Test Total Marks-25
1. What is refered to the collection and the integration of data from multiple worksheets or
workbooks into a single worksheet?
A) Consolidating Data B) Sorting Data
C) Subtotal D) Combine Data
2. This is used to automatically create groups and apply inbuilt functions like SUM, COUNT,
AVERAGE to summarize data.
A) Analysis B) Subtotal
C) Total Data D) Scenaio
3. Which function isn't available in subtotal in open office Calc?
A) Max and Min B) Sum and Count
C) Average and Product D) Percentage
4. Which option is used to make a group of items in subtotal?
A) Group By B) Join By
C) Add By D) Collect By
5. When you open a new spreadsheet, by default, it has a sheet named ________ which is
managed using tabs at the bottom of the spreadsheet.
A) Sheet1 B) Untitled1
C) Worksheet1 D) New Sheet
6. Which among the following is an elaborate form of Goal seek and deals with multiple
unknown variables?
A) Solver B)Subtotal C) Macro D) Average
7. Which type of hyperlink will stop working, if the target location is moved to a new
location?
A) Relative B) Absolute C) New link D) Outside
8. What is the name of the automatically created library which gets automatically loaded
when the document is opened or when a document is created and saved in Calc?
A) Customised B) Standard C) Xls D) Spreadsheet
9. Which menu and option is used to share a workbook by multiple people at the same time?
A) Toos🡪Merge document B) Tools🡪 Shared document
C) Format🡪Share D) None of these
10. In the ________tool, you may maximise, minimise the result according to a set of rules
that you define.
A) Solver B) Subtotal C) Scenario D) None of these
11. Nehal and Nikita were sharing worksheets; but they forgot to record the changes they
made. How the Calc software can help them to find the changes done in worksheets?
A) By duplicating B) By comparing C)By checking D) By sharing
12. Which of the following function, adds data arranged in arrays and then choose statistical
function to apply to them?
A) ConsolidationAdd B) Subtotal C) Scenario
13. Which of the following tool does not falls under ‘what if analysis’?
A) Macros B) Scenarios C) Goal Seek D) Solver
14. How can you switch between scenarios?
A) Find and replace B) Data Source C) Navigator D) None of the above
15. Which tool is used to find the result by adjusting an input value?
A) Goal seek B) Solver C) Target value
16. What formula would be written to refer to a cell B1 in a sheet named savings.
A) =savingsB1 B) =savings.B1 C) =’savings’.B1 D) =”savings”.B1
17. Which of the following changes are not recorded in shared worksheet?
A) Change any number B) Change any text C) Insert any Picture
18. Which of the following is not a correct method of renaming a sheet in Calc?
A) Double click in the sheet name B) Right click in sheet name and rename
C) Format🡪Rename D) Edit🡪Rename
19. Which option should be selected in Data Consolidation dialog box to automatically
update the target range when any values are updated in the source range?
A) Row labels B) Column labels C) Link to source data D) Update link
20. In Scenario dialog box, if you do not select this option, the scenario is not changed when
you change cell [Link] is that option?
A) Display border B) Copy back C) Copy entire sheet D) No Update
21. Rohit have two spreadsheets in the same folder linked to each other.
What will happen to the relative hyperlink, if he moves the entire folder to a new location?
A) The link will not work B)The link will work C) The link will be deleted
22. Ms. Neha entered some data in a Calc worksheet1 and applied some functions, formulas
and [Link] wants to repeatedly use those functions/formulas and formatting used in
worksheet1 in other sheets [Link] feature of Calc should she use to do the task?
A) Editing B) Formatting C) Macro D) Functions
23. Mr Sandeep is the sponsor of a Basketball team. The coach has submitted a budget to him
for the season and he edits the cost and returns it [Link] Sandeep is concerned that
whatever changes he is doing in the budget, will that changes be easily visible to the coach?
So he decided to use Calc, but what feature should be turned on, so that the changes made by
Sandeep are easily visible to the coach?
A) Edit🡪Changes🡪Comments B) Edit🡪Changes🡪Accept C) Edit🡪Changes🡪Record
24. Neel wants to calculate the interest amount. Initially he has 20000 as Principal amount,
rate of interest as 5% and Time is 3 [Link] he wants to see the changes that will result in
interest amount by changing the principal amount from 20,000 to 50000 and then by 75000.
Which feature of Calc should he use to see the effect of changing the Principal in the
investment amount?
A) Goal Seek B) Scenarios C) Average D) Link data
25. Rohit, Mohit and Prashant are working in K& S co. Ltd. As Sales executives. The
company wants to find the total sales done by them month [Link] feature of Calc should
the company use or employ for finding the sales done by the salesman in different months
e.g. Total Sales for the month of October, November and December etc. ?
A) Data Consolidation B) Pivot Table C) Sum D) Subtotal