Electronic Spreadsheet (LibreOffice Calc)
Class 10 CBSE IT (402) - Important Questions & Answers
1. 1. What is the significance of Subtotal feature in a spreadsheet?
The Subtotal feature automatically calculates totals such as Sum, Average, Count, Maximum, and Minimum for grouped data. It helps summarize large datasets and makes data analysis easier.
2. Briefly describe a scenario/example where Data Consolidation is useful.
Data Consolidation is useful when combining sales data from different branches or monthly worksheets into one summary sheet for easy analysis and reporting.
3. Write steps to apply two scenarios one by one.
Select the data → Go to Tools → Scenarios → Create and name each scenario → Save both scenarios → Open Navigator and double-click a scenario to view and compare results.
4. What do you mean by Formula Cell, Target Value and Variable Cell in Goal Seek?
Formula Cell: Contains the formula. Target Value: Desired result. Variable Cell: Cell whose value changes automatically to achieve the target value.
5. Solver is an advanced form of Goal Seek?
Solver can change multiple variable cells, apply constraints, and find the best solution, while Goal Seek changes only one variable cell.
6. Why sort data before applying Subtotal?
Sorting groups similar records together. The Subtotal feature inserts calculations for each group, so unsorted data produces incorrect or incomplete subtotal results
7.How is Scenario different from Goal Seek? Explain with an example.
SScenario compares different sets of input values, while Goal Seek finds one input needed to achieve a desired result. Example: Comparing budgets (Scenario) versus finding required marks (Goal Seek).
8. Suitable feature for Ajit's sales data?
Scenario, because it compares different sales values and estimates earnings.
9. Suitable feature for Ajit's savings?
Goal Seek, because it finds the required savings to meet a target expense.
10. Relative Path vs Absolute Path.
A Relative Path is based on the current file location and changes when moved. An Absolute Path gives the complete file location and remains fixed.
11. Advantage of Relative Hyperlinking.
Relative hyperlinks continue working even if the folder is moved to another location, provided the linked files remain together, making file sharing easier.
12. Reference to cell B5 in mysheet1.
mysheet1.B5
13. Reference to B5 in workbook myworkbook.
'myworkbook'#mysheet1.B5
14.What do you mean by Registered Data Source?
A Registered Data Source is a database registered with LibreOffice, allowing documents to access and use external data for reports, labels, forms, and mail merge.
15. Why share documents?
Sharing documents allows multiple users to work on the same file, improving collaboration, reducing duplicate work, and increasing productivity.
16.What is the advantage of tracking changes in a shared document?
Track Changes records all edits made by different users, making it easy to review, accept, reject, and identify who made each change..
17. What actions can you take on the changes done by other users in a shared document?.
You can accept, reject, accept all, reject all, or review each tracked change individually before finalizing the document.
18. . What is the basic difference between Track Changes comments and General comments?
TTrack Changes comments are linked to tracked edits and explain modifications. General comments are regular notes or suggestions that do not record document changes.
