Electronic Spreadsheet Class 10 Board Questions and Answers provides important exam-oriented questions based on the Electronic Spreadsheet chapter of Class 10 Information Technology. It covers key concepts, functions, formulas, and spreadsheet features that students should revise for their board examination. The answers are written in simple and easy-to-understand language.
Electronic Spreadsheet Class 10 Board Questions and Answers
Answer the given questions in 20 – 30 words each.
Q1. Briefly explain the purpose of the Subtotal tool in the LibreOffice Calc software.
Answer: The Subtotal tool is used to automatically group data and apply summary functions like Sum or Average. It helps in analyzing data by class or category without using filters.
Q2. Give any two prerequisites before consolidating data in Calc.
Answer:
- The data types in all sheets must match.
- The labels (row or column headings) must be the same in all sheets.
Q3. What is a Macro? Give any two rules that should be followed while naming a Macro or module in Calc.
Answer: A Macro is a set of recorded instructions that can be run later to automate repeated tasks.
Rules:
- The name must start with a letter or underscore.
- It should not contain spaces or special characters.
Q4. What is the main purpose of Goal Seek in Calc? Give an example to support your answer.
Answer: Goal Seek is used to find the input value for a specific output. For example, if a student wants 70% average marks, Goal Seek can calculate how many marks are needed in the last subject to reach that percentage.
Q5. What is the purpose of consolidating data in spreadsheets? Discuss briefly.
Answer: Consolidating data combines information from multiple sheets into one sheet. It helps in summarizing, comparing, and identifying trends and relationships in data.
Q6. What are the two parts of a cell reference while referencing data on other sheets? Explain with an example.
Answer: The two parts are:
- Sheet name
- Cell address
- Example: Sheet2.A1 means cell A1 from Sheet2.
Q7. What is the role of the External Data Dialog box in LibreOffice Calc? Briefly discuss.
Answer: The External Data Dialog box is used to link data from external sources into a spreadsheet. It helps in updating the spreadsheet automatically when the external data changes.
Q8. Briefly discuss the significance of using a Macro as a function in LibreOffice Calc.
Answer: Using a Macro as a function allows us to automate calculations or formatting. It saves time, avoids mistakes, and ensures consistency in repeated tasks.
Q9. What is the meaning of “Shared Spreadsheet” in LibreOffice Calc? Give any two advantages of sharing a spreadsheet.
Answer: A Shared Spreadsheet allows multiple users to edit the same file at the same time.
Advantages:
- Saves effort of maintaining multiple copies.
- Helps in collaborative editing and teamwork.
Q10. What is Relative and Absolute Hyperlink in a spreadsheet?
Answer:
- Relative hyperlink → Uses the relative path of the file location.
- Absolute hyperlink → Uses the full path of the file location.
Q11. Give any two uses of creating hyperlinks in a spreadsheet.
Answer:
- To quickly open another file or webpage.
- To link to a specific cell or sheet within the same spreadsheet.
Q1. Differentiate between data organized in a flat file and a relational form.
Answer:
- Flat file → Data is stored in a single table, without relationships.
- Relational form → Data is stored in multiple tables, linked by keys, which reduces duplication and improves consistency.
Q2. How can you confirm that sharing has been disabled in the spreadsheet?
Answer: When sharing is disabled, the Shared Spreadsheet option will not be visible in the status bar, and only one user can edit the file at a time.
Q3. What is a Macro? List any two real life situations where they can be used.
Answer: A Macro is a set of recorded instructions used to automate repeated tasks.
Examples:
- Typing school name and address with the same formatting in every sheet.
- Applying the same formula in a particular cell across multiple sheets.
Q4. What are the benefits of sharing a spreadsheet?
Answer:
- Saves effort of maintaining multiple copies of the same file.
- Allows collaborative editing by many users at the same time.
Q5. Differentiate between a Primary key and Foreign key.
Answer:
- Primary key → A unique identifier for each record in a table.
- Foreign key → A field in one table that refers to the primary key in another table, used to link tables.
Q6. Explain the term ‘Scenarios’ in relation to the Spreadsheets with example.
Answer: Scenarios are sets of values used to explore and compare alternatives in a spreadsheet. For example, in a loan sheet, different scenarios can be created for loan amount and number of years to see how EMI changes.
Q7. Mention any two operations that can be performed using Macros in a spreadsheet.
Answer:
- Automating formatting tasks like font style and size.
- Applying formulas repeatedly across different sheets.
Q8. What do you mean by Hyperlinks in Spreadsheets? Give the two different types of Hyperlinks that can be used in Spreadsheets.
Answer: Hyperlinks are links used to connect a spreadsheet to another file, webpage, or location.
Types:
- Relative hyperlink → Uses relative path of file location.
- Absolute hyperlink → Uses full path of file location.
Q9. Guneet has completed his assessments in four subjects and received the following marks: 75 in Math, 68 in Science, 82 in English, and 70 in History. The student needs to achieve an overall aggregate of 75% across all five subjects to meet his academic goals. He still has to take the exam in the fifth subject, which is Geography. Which Calc tool and menu option he can use to check how many marks he has to score in the 5th subject to get the required percentage?
Answer: Guneet can use the Goal Seek tool from the Tools menu. It will calculate how many marks he needs in Geography to reach the required 75% aggregate.
Answer the given questions in 50 – 80 words each.
Q1. Mr. Prasanna, a General Manager in a multinational company, has been given two spreadsheets: Bill.ods and Rev_Bill.ods. Both contain customer billing details prepared by different teams. Write the steps he should follow to compare these worksheets and identify the differences between them.
Answer:
- Open the original file Bill.ods in LibreOffice Calc.
- Go to Edit → Track Changes → Compare Document.
- Select the reviewed file Rev_Bill.ods.
- Calc will highlight the differences between the two spreadsheets.
- The manager can then accept or reject the changes as needed.
Q2. Mr. Amit, Sales Manager of ABC Sales Corporation has created a spreadsheet in LibreOffice Calc that lists Sales for different years in different regions in different worksheets.
(a) Which tool in Calc can be used to combine the sales data from multiple sheets into a single summary sheet?
Answer: The Consolidate function can be used to combine data from multiple sheets.
(b) Name the Menu Option and Sub‑Menu Option that can be used to generate combined summary of all the worksheets.
Answer: Use Data → Consolidate option.
(c) Name the function that can be used to display total of all sales.
Answer: The Sum function is used to display the total of all sales.
(d) He wants to open a summary document stored at a different location from within the sheet by clicking on a text stored in a cell. How can it be done?
Answer: This can be done by creating a Hyperlink in the cell that links to the summary document.
Q3. Explain four types of hyperlinks that can be applied in spreadsheets.
Answer:
- Internet hyperlink → Links to a webpage.
- Document hyperlink → Links to another document stored on the computer.
- Email hyperlink → Opens the default email application to send mail.
- Place in document hyperlink → Links to a specific cell or sheet within the same spreadsheet.
Q4. Distinguish between the following with respect to spreadsheets.
(a) Relative and Absolute hyperlink.
Answer:
- Relative hyperlink → Uses the relative path of the file location. It changes if the file is moved.
- Absolute hyperlink → Uses the full path of the file location. It remains fixed even if the file is moved.
Q1. Mr. Rakesh owns a small grocery shop. One of his friends suggested using LibreOffice Calc, which includes What‑if Analysis tools such as Multiple Operations.
(a) What is the use of What‑if Analysis tools?
Answer: What‑if Analysis tools are used to test different input values and see how they affect the output. They help in planning and decision‑making.
(b) What is the use of the Multiple Operations tool in LibreOffice Calc?
Answer: The Multiple Operations tool is used to calculate results for different sets of input values at the same time using a formula.
(c) Select the ___________ menu → Multiple Operations to use the Multiple Operations tool.
Answer: Select the Data menu → Multiple Operations.
(d) Multiple Operations tool uses (one/two/three) arrays of cells.
Answer: It uses two arrays of cells – one for input values and one for formulas/results.
Q2. In context of LibreOffice Calc, answer the following:
(a) Define the term Macros.
Answer: A Macro is a set of recorded instructions that can be run later to automate repeated tasks.
(b) State any two rules for naming a Macro.
Answer:
- The name must start with a letter or underscore.
- It should not contain spaces or special characters.
(c) Give the steps to record a Macro.
Answer:
- Go to Tools → Macros → Record Macro.
- Perform the actions you want to record.
- Click Stop Recording.
- Save the Macro with a name in the dialog box.
Q3. Explain the following w.r.t. spreadsheets:
(a) Scenario
Answer: A Scenario is a set of values used to test different conditions in a spreadsheet. For example, in a loan sheet, different scenarios can be created for loan amount and years to see how EMI changes.
(b) Goal Seek
Answer: Goal Seek is used to find the input value for a specific output. For example, it can calculate how many marks a student needs in the last subject to reach 70% average.
Q4. Arjun is preparing a project report in LibreOffice Calc.
(a) Why did the absolute hyperlink fail when Arjun shared the file, and how does a relative hyperlink solve this problem?
Answer: The absolute hyperlink failed because it used the full file path, which was different on another computer. A relative hyperlink solves this by using the relative path, so it works even if the file is moved.
(b) How does the Target in Document option increase the usefulness of hyperlinks in large spreadsheets?
Answer: Target in Document allows linking directly to a specific sheet or cell, making navigation easier in large spreadsheets.
(c) Arjun wants to ensure that anyone viewing his report can update data directly from a government website. Which feature should he use, and why is it beneficial?
Answer: He should use the Link to External Data feature. It is beneficial because it fetches live tables from a website and keeps the spreadsheet updated automatically.
(d) If Arjun wants to edit or remove a hyperlink later, what steps should he take?
Answer: He should right‑click on the hyperlink and choose Edit Hyperlink or Remove Hyperlink.
Q5. A Class X student is participating in a school competition where they need to analyse the performance of different sports teams.
(a) How are Macros in Calc helpful to him?
Answer: Macros help by automating repeated tasks like applying formulas or formatting, saving time during analysis.
(b) How to enable Macro in Calc?
Answer: Go to Tools → Options → LibreOffice → Advanced, and check the option Enable Macro Recording.
(c) Is solution*word a valid macro name? Justify.
Answer: No, it is not valid because macro names cannot contain special characters like * (asterisk).
(d) Mention any one operation which cannot be recorded by macro.
Answer: Opening or switching windows cannot be recorded by macro.
Q6. Anshita is preparing spreadsheet notes for her Term Exam. Help her to write short note on the following:
(i) Scenarios
Answer: Scenarios are sets of values used to test different alternatives in a spreadsheet. They help in comparing results under changing conditions.
(ii) Goal Seek
Answer: Goal Seek is a tool that finds the input value for a specific output. It works in reverse order to calculate the required input.
(iii) Subtotal
Answer: The Subtotal tool groups data automatically and applies summary functions like Sum or Average. It helps in analyzing grouped data easily.
Disclaimer: The content that is present on our website is based on the NCERT Class 10 Information Technology textbook and is provided for educational purposes only. All the content and images have been taken from Information Technology Class 10 NCERT Textbook. Images and content shown above are the property of individual organizations and are used here for reference purposes only. To make it easy to understand, some of the content and images are generated by AI and cross-checked by the teachers.
For more information, refer to the official CBSE textbooks available at cbseacademic.nic.in