CBSE 10th class Unit 2: Chapter 3 LINKING SPREADSHEET DATA

 

Unit 2: 
Chapter 3
LINKING SPREADSHEET DATA

A. Multiple Choice Questions

1. (b) Insert
2. (a) $My Sheet.'G5'
3. (b) three
4. (b) Hyperlink

B. Fill in the blanks

1. current
2. Ctrl+A
3. .odb
4. Single quotes
5. Insert Sheet from Another File

C. State whether the following statements are True or False

1. False: A sheet can be added before or after the current sheet.
2. True: If a sheet has a reference to another sheet, changes made to the referenced sheet will be reflected in the referencing sheet.
3. False: You can link a sheet as a reference in another sheet using the INSERT -> LINK option.
4. True: You can insert data from a web page into a spreadsheet using the INSERT -> WEB PAGE option.
5. False: You can delete a hyperlink by right-clicking on it and selecting "Remove Hyperlink."

D. Answer the following questions

1. Name the two ways to link the sheets in a LibreOffice Calc.
• Direct Reference: Referencing a cell or range of cells in another sheet using the sheet name followed by the cell reference (e.g., Sheet2.A1).
• Hyperlink: Creating a hyperlink to a specific cell or range of cells in another sheet.
2. Differentiate between Relative and Absolute Hyperlink.
• Relative Hyperlink: The link is relative to the current position in the document. If you move the linked cell, the hyperlink will still work.
• Absolute Hyperlink: The link is fixed to a specific location in the document. If you move the linked cell, the hyperlink will no longer work.
3. Write steps to extract a table from a web page in a spreadsheet.
• Open the web page in your browser.
• Select the table you want to extract.
• Copy the table (Ctrl+C or right-click and copy).
• Open your LibreOffice Calc spreadsheet.
• Paste the table into the spreadsheet (Ctrl+V or right-click and paste).
4. *Write steps to register a data source that is in .odb format.
• Go to Tools -> Database -> Register Database.
• In the "Database Type" dropdown, select "HSQLDB".
• In the "Database URL" field, specify the path to your .odb file.
• Click "OK" to register the database.
5. State advantages of extracting data from a web page into a spreadsheet.
• Real-time data: You can extract the latest data from the web page.
• Automation: You can automate the data extraction process using macros or scripts.
• Data analysis: You can perform various data analysis tasks on the extracted data.

Lab Exercises

1. Create three sheets named Jan, Feb and March.
• Create three new sheets in your LibreOffice Calc document and name them "Jan," "Feb," and "March."
• Enter the attendance data for each month in the respective sheets, using "P" for present and "A" for absent.
• Use the COUNTIF function to count the number of "P"s in each sheet to calculate the total attendance.
2. Add another sheet named 'Consolidated Attendance' that stores total attendance of three months and calculates the percentage. ¹  
• Create a new sheet named "Consolidated Attendance."
• Use the SUM function to add the total attendance from the three months.
• Calculate the percentage attendance by dividing the total attendance by the total possible attendance (e.g., 31 days for January).
3. Create a spreadsheet containing the list of Prime Ministers of India with their tenure from the website [invalid URL removed].
• Open the website in your browser.
• Copy the table containing the list of Prime Ministers.
• Paste the table into a new LibreOffice Calc sheet.
• Use the COUNT function to count the number of Prime Ministers in the list.