1.

Data consolidation
The Data Consolidation tool summarizes data from multiple worksheets or workbooks into a single
worksheet that you can simply update.
2. Subtotal
SUBTOTAL: totals/adds data in an array—that is, a collection of cells with column and/or row labels.
3 groups
No percentage function
3. Goal Seek
The word “goal seeking” refers to the act of determining your input value based on a previously
determined output value.
4. Scenario
Scenarios are a tool to test “what-if” questions.
Each scenario is given a unique name and can be changed and presented independently.
Only the content of the currently active scenario is printed when you print the spreadsheet.
A scenario is essentially a set of saved cell values that you may use in your calculations.
Using the Navigator or a dropdown list displayed beside the changing cells, you may simply switch
between these sets.
5. Solver
The Solver option in the Tools menu is essentially a more advanced version of Goal Seek. The Solver, on
the other hand, deals with equations involving several unknown variables. It is meant to minimize or
maximize the result based on a set of rules that you specify.
6. relative and absolute hyperlinks.

A relative hyperlink says, Here is how to get there from where you are now (meaning the folder in which
your current document is saved) while an absolute hyperlink says, Here is how to get there no matter where
you start from.

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.

Absolute hyperlinks can break when the web page is moved or renamed (full address). A relative
hyperlink is a hyperlink that contains a partial URL of the destination web page. A relative hyperlink is
used to link to a web page that is in the same domain or subdirectory as the current web page.

A relative link would only include /images /puppies. gif in the a href tag.
An absolute link, on the other hand, would include https:// www. example.com/ image/ puppies.

7. rename a worksheet in Spreadsheet

three different ways
->double-click on the sheet tab
->Right-click an existing worksheet name, then select Rename from the Context menu that appears.
->Select the worksheet you want to rename (by clicking on the worksheet tab), then choose Sheet from the
Format menu.
8. sharing worksheet data
Enhance the speed of data entering
To facilitate collaboration, make things easy.
9. features and use of Record changes.
 keep track of what data was modified, when it was updated, who performed the modification, and
which cell it happened in.
A colored border appears around a cell where changes were made, with a dot in the upper left-hand
corner.
 Other reviewers will easily notice which cells have been changed.
 A strong colored bar indicates a deleted column or row.
10. adding comments
Comments from reviewers and authors can be added to explain their changes.
11. What are Macros? How can we record a Macro?

When the same set of operations must be completed repeatedly, such as formatting or applying a similar
formula to a similar piece of data, macros can save time.
It can be used to name and track a sequence of events.

To record a macro, follow these steps:

1. Input data
2. Before performing any operation, go to tools->macro->record macro.
3. Now repeat the motion you just did.
4. Select “Stop Recording” from the drop-down menu. Now save the macro by giving it a name.
12. What are the two ways of referencing cells in other worksheets?
There are two ways to reference cells in other sheets:
->by entering the formula directly using the keyboard
->or by using the mouse.
13. What is the name of the master worksheet where the spreadsheet summaries all the data?
a. Insert b, Consolidation c. Data d. reference
14. Which of the following is What-If Analysis?
a. Consolidation b. Data table c. Sub Total d. Solver
15. Which of the following functions is used to change the data in a formula and analyze how it affects the end
result?
a. Goal Seek b. Data Table c. Solver d. Scenario Manager
16. _______ is specifically designed to minimize or maximize the result according to the set of rules that you
define in the spreadsheet.
Goal seek b. Scenario c. Solver d. Subtotal
17. Which of the following refers to cell A3 in sheet 3 for creating a reference?
a. Sheet A3 b. Sheet3.A3 c. Sheet3$A3 d. $ Sheet3!A3
18. Subtotal is available in ______ menu
a. Tools b. Format c. Insert d. Data
19. Worksheets can be merged from _____________ menu.
a. Edit b. File c. View d. Tools
20. Macros are especially useful to ____ tasks.
a. Do b. Repeat c. Simplify d. Complicate
21. Comments put in cells are called:
a. Smart top b. Cell tip c. Web tip d. Soft tip
22. Each scenario has a name true
23. Scenarios names can be edited and formatted separately yes
24. When we print a spreadsheet, only the content of the active scenario is printed yes
25. We can shift from one scenario to another by 1. navigator 2. Drop down list
26. The default name of the first scenario created in Sheet1 of Calc is Sheet1_Scenario_1
27. where the name of the Scenario is displayed navigator/title bar
28. Information about the scenario can be written in the comment box
29. We can consolidate data by row label/column label
30. In which option we have to specify the target range (Where we want the result to be displayed) and copy
results to
31. In which option do we have to specify the ranges to consolidate? Source data range
32. Which option is used to name a range of cells define ange
33. Subtotals is available in __________ menu. data
34. _________ totals data arranged in an array that is, a group of cells with labels for columns and / or rows
totals. Subtotal
35. A ______ hyperlink contains the full address of the destination file or web page. Absolute
36. An __________ link will stop working only if the target is moved while a__________ link will stop
working only if the start and target locations change relative to each other. absolute, relative
37. Hema holds the title of chartered accountant. On a daily basis, she used to keep track of the accounts on a
spreadsheet. There are a number of steps that she must follow at all times. Can you recommend a
spreadsheet feature that will allow her to complete these activities quickly and without having to repeat the
processes each time? Using Macros
38. Raj has produced a worksheet in which he has entered all of his employees’ details. He wants each
employee to look over the spreadsheet and, if necessary, change their address and phone number. He’d also
like to know what modifications his employees have made. Which aspect of the spreadsheet should he
enable so that he can view the changes that his staff have made? Track Changes
39. Sunita is working on a spreadsheet project. Her friend taught her how to rename a spreadsheet, which will
make it easier for her to identify the worksheet data. She was excited and told her brother about it. A
worksheet in spreadsheets can be renamed in ________different ways, according to her brother.3
40. Rohit received a 25 out of 30 grade in English and a 22 out of 30 grade in Math. In order to calculate the
score in IT, he needs to acquire an overall score of 85 percent. Provide him with the best selection from the
list below. Goal Seek
41. As a school project, Krish and Kritika conducted a survey of their neighborhood’s literacy rates by age,
which they recorded in a spreadsheet. They both want to work on it at the same time to finish it on time.
Which option should they use to access the same Spreadsheet in order to save time? Shared Worksheet
42. You can use ________ to combine data from multiple worksheets into a master worksheet. Data
Consolidation
43. Which option should we use to define the target range? (Where we want the result to be displayed). Copy
results to
44. Which option is used to name a range of cells? Define Range
45. In Subtotals we can select up to _______ groups of arrays.3
46. We can shift from one scenario to another by _____________ Navigator
47. Which option is suitable to calculate the effect of different interest rates on an investment .Scenario
48. ____________ is a more elaborate form of Goal Seek. Solver
49. Which feature of Calc helps to see the changes made in the shared worksheet? Record Changes
50. 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: work
51. How can Suman and her friends work together in a spreadsheet? By sharing a workbook
52. What color border appears around a cell where changes were made in a shared worksheet. Red
53. After sharing a worksheet, what word is displayed on the title bar after the worksheet’s title? Shared
54. Mention3 features that are disabled in a shared spreadsheet.
a. Insert > Names
b. Insert > Comment
c. Edit > Changes, except for Merge Document
55. How many types of hyperlinks are shown on the left-hand side of the Hyperlink dialog box in Calc?4
56. Can we give different colors to different scenarios? True
57. An absolute hyperlink will stop working only if the target is moved. True
58. What is a saved sequence of commands or keystrokes in Calc called? Macro
59. What option should be clicked to stop the macro recorder in Calc? Stop Recording
60. 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? By comparing
61. Which tool is used to find the result by adjusting an input value?Goal seek
62. If you are continuously working with the same range, then what should be preferably be used to refer that
range? Define Range
63. In Scenario dialog box, if you do not select this option, the scenario is not changed when you change cell
values..What is that option? Copy back
64. Calc provides a feature to review all the changes at once when multiple reviewers return edited versions of
a worksheet at the same time. Edit🡪Changes🡪 Merge Document
65. 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 back.Mr 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? Edit🡪Changes🡪Record
66. 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 wise.Which 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. ? Subtotal
67. 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? Link to source data
68. 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? Standard